Oracle notes

Oracle 10g is Buggy!
Out of box, 10g (10.1.0.2.0) ‘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
ERROR:
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
http://www.adp-gmbh.ch/ora/misc/dynamic_performance_views.html

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

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s