Home » RDBMS Server » Server Administration » Statpack Error
Statpack Error [message #250487] Tue, 10 July 2007 04:27 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
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


Re: Statpack Error [message #250504 is a reply to message #250499] Tue, 10 July 2007 05:37 Go to previous messageGo to next message
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



Re: Statpack Error [message #250514 is a reply to message #250504] Tue, 10 July 2007 05:53 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Statpack Error [message #250570 is a reply to message #250504] Tue, 10 July 2007 09:01 Go to previous messageGo to next message
joy_division
Messages: 4642
Registered: February 2005
Location: East Coast USA
Senior Member
ok, we all know now that you can cut and paste your original question.
Re: Statpack Error [message #250575 is a reply to message #250570] Tue, 10 July 2007 09:11 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Laughing
Previous Topic: TNS listener error please help
Next Topic: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
Goto Forum:
  


Current Time: Thu Dec 08 00:40:59 CST 2016

Total time taken to generate the page: 0.10825 seconds