Oracle notes

Oracle 10g is Buggy!
Out of box, 10g ( ‘s /rdbms/admin/spcreate.sql is broken. It would throw the following error when I tried to install statspack:
SQL> — Build the tables and synonyms
SQL> connect perfstat/&&perfstat_password
ORA-12162: TNS:net service name is incorrectly specified

I had to change the password and add in @ in the script to get the statspack installation complete.

Error! in spcreate.sql:
connect perfstat/&&perfstat_password

My correction in spcreate.sql:
connect perfstat/perfstat @ oracle

A Good Reference

To verify timed_statistics parameter
SQL> select name, value, isdefault from v$parameter where name = ‘timed_statistics’;


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s