OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Statpack Error

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Statpack Error [message #250487]

Tue, 10 July 2007 04:27

crussed_sonu
Messages: 51
Registered: July 2007
Location: Delhi

Member

Hi to all

i am in problem that occur
when i genreting statpack it automaticlly leave the sql prompt

Steps-------

CREATE TABLESPACE perfstat
DATAFILE '/u01/oracle/db/AKI1_perfstat.dbf' SIZE 1000M REUSE
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 512K
SEGMENT SPACE MANAGEMENT AUTO
PERMANENT
ONLINE;

then after run -- catdbsyn.sql as SYS
dbmspool.sql as SYS
scripts chalane ke bad path per aa zao
cd $ORACLE_HOME/rdbms/admin

1:25 PM sqlplus "/ as sysdba"

start spcreate.sql
Choose the PERFSTAT users password perfstat

scripts chalane ke bad path per aa zao
cd $ORACLE_HOME/rdbms/admin

1:25 PM sqlplus "/ as sysdba"

start spcreate.sql
Choose the PERFSTAT user's Temporary tablespace.

Enter value for temporary_tablespace: TEMP

after all it Run sometimes then leave the sql prompt

Reply me soon

Thanks

[Updated on: Tue, 10 July 2007 05:40]

Report message to a moderator

Re: Statpack Error [message #250499 is a reply to message #250487]

Tue, 10 July 2007 04:44

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Always copy and paste your screen then we can what you did and Oracle returned.

Use not "execute", "start".

Regards
Michel

Report message to a moderator

Re: Statpack Error [message #250504 is a reply to message #250499]

Tue, 10 July 2007 05:37

crussed_sonu
Messages: 51
Registered: July 2007
Location: Delhi

Member

Hi

CREATE TABLESPACE perfstat
DATAFILE '/u01/oracle/db/AKI1_perfstat.dbf' SIZE 1000M REUSE
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 512K
SEGMENT SPACE MANAGEMENT AUTO
PERMANENT
ONLINE;

then after run -- catdbsyn.sql as SYS
dbmspool.sql as SYS
scripts chalane ke bad path per aa zao
cd $ORACLE_HOME/rdbms/admin

1:25 PM sqlplus "/ as sysdba"

start spcreate.sql
Choose the PERFSTAT users password perfstat

scripts chalane ke bad path per aa zao
cd $ORACLE_HOME/rdbms/admin

1:25 PM sqlplus "/ as sysdba"

start spcreate.sql
Choose the PERFSTAT user's Temporary tablespace.

Enter value for temporary_tablespace: TEMP

after all it Run sometimes then leave the sql prompt

Reply me soon

Thanks

Report message to a moderator

Re: Statpack Error [message #250514 is a reply to message #250504]

Tue, 10 July 2007 05:53

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Please read and follow How to format your posts and How to get a quick answer to your question: TIPS AND TRICKS
Make sure that lines of code do not exceed 80 or 100 characters when you format.
Please always post your Oracle version (4 decimals).

Use SQL*Plus to execute this.
Then copy and paste your session.

Regards
Michel

Report message to a moderator