Home » RDBMS Server » Performance Tuning » Error while installing Statspack
Error while installing Statspack [message #137782] Fri, 16 September 2005 15:10 Go to next message
oracledbanewbie
Messages: 6
Registered: August 2005
Junior Member
Hi all,
I have been trying to install statspack in Oracle 9iR2 on Red Hat Linux 9.0. Please help me out. I do understand the meaning of the error but am at loss of methods to rectify it. Thank you all.

-Anand

Steps:

1. Logging as sys as sysdba into the DB.
2. Created user perfstat and assigned a default tablespace statspack to him. For this another tablespace "statspack" was created by me.
3. Then I ran ?/rdbms/admin/catdbsyn.sql and I get the following errors

@/opt/oracle/product/9.2.0/rdbms/admin/catdbsyn.sql
create or replace synonym DBA_CATALOG for SYS.DBA_CATALOG
*
ERROR at line 1:
ORA-01471: cannot create a synonym with same name as object


create or replace synonym DBA_CLUSTERS for SYS.DBA_CLUSTERS
*
ERROR at line 1:
ORA-01471: cannot create a synonym with same name as object


create or replace synonym DBA_CLU_COLUMNS for SYS.DBA_CLU_COLUMNS
*
ERROR at line 1:
ORA-01471: cannot create a synonym with same name as object


create or replace synonym DBA_COL_COMMENTS for SYS.DBA_COL_COMMENTS
*
ERROR at line 1:
ORA-01471: cannot create a synonym with same name as object


create or replace synonym DBA_CROSS_REFS for SYS.DBA_CROSS_REFS
*
ERROR at line 1:
ORA-01471: cannot create a synonym with same name as object


create or replace synonym DBA_DATA_FILES for SYS.DBA_DATA_FILES
*
ERROR at line 1:
ORA-01471: cannot create a synonym with same name as object


create or replace synonym DBA_DB_LINKS for SYS.DBA_DB_LINKS
*
ERROR at line 1:
ORA-01471: cannot create a synonym with same name as object


create or replace synonym DBA_EXP_FILES for SYS.DBA_EXP_FILES
*
ERROR at line 1:
ORA-01471: cannot create a synonym with same name as object


create or replace synonym DBA_EXP_OBJECTS for SYS.DBA_EXP_OBJECTS
*
ERROR at line 1:
ORA-01471: cannot create a synonym with same name as object


create or replace synonym DBA_EXP_VERSION for SYS.DBA_EXP_VERSION
*
ERROR at line 1:
ORA-01471: cannot create a synonym with same name as object


create or replace synonym DBA_EXTENTS for SYS.DBA_EXTENTS
*
ERROR at line 1:
ORA-01471: cannot create a synonym with same name as object


create or replace synonym DBA_FREE_SPACE for SYS.DBA_FREE_SPACE
*
ERROR at line 1:
ORA-01471: cannot create a synonym with same name as object


create or replace synonym DBA_INDEXES for SYS.DBA_INDEXES
*
ERROR at line 1:
ORA-01471: cannot create a synonym with same name as object


create or replace synonym DBA_IND_COLUMNS for SYS.DBA_IND_COLUMNS
*
ERROR at line 1:
ORA-01471: cannot create a synonym with same name as object


create or replace synonym DBA_OBJECTS for SYS.DBA_OBJECTS
*
ERROR at line 1:
ORA-01471: cannot create a synonym with same name as object


create or replace synonym DBA_SEQUENCES for SYS.DBA_SEQUENCES
*
ERROR at line 1:
ORA-01471: cannot create a synonym with same name as object


create or replace synonym DBA_TAB_COLUMNS for SYS.DBA_TAB_COLUMNS
*
ERROR at line 1:
ORA-01471: cannot create a synonym with same name as object


create or replace synonym DBA_TAB_COMMENTS for SYS.DBA_TAB_COMMENTS
*
ERROR at line 1:
ORA-01471: cannot create a synonym with same name as object


create or replace synonym DBA_TAB_PRIVS for SYS.DBA_TAB_PRIVS
*
ERROR at line 1:
ORA-01471: cannot create a synonym with same name as object


create or replace synonym DBA_ROLLBACK_SEGS for SYS.DBA_ROLLBACK_SEGS
*
ERROR at line 1:
ORA-01471: cannot create a synonym with same name as object


create or replace synonym DBA_SEGMENTS for SYS.DBA_SEGMENTS
*
ERROR at line 1:
ORA-01471: cannot create a synonym with same name as object


create or replace synonym DBA_SYNONYMS for SYS.DBA_SYNONYMS
*
ERROR at line 1:
ORA-01471: cannot create a synonym with same name as object


create or replace synonym DBA_TABLESPACES for SYS.DBA_TABLESPACES
*
ERROR at line 1:
ORA-01471: cannot create a synonym with same name as object


create or replace synonym DBA_TABLES for SYS.DBA_TABLES
*
ERROR at line 1:
ORA-01471: cannot create a synonym with same name as object


create or replace synonym DBA_TS_QUOTAS for SYS.DBA_TS_QUOTAS
*
ERROR at line 1:
ORA-01471: cannot create a synonym with same name as object


create or replace synonym DBA_USERS for SYS.DBA_USERS
*
ERROR at line 1:
ORA-01471: cannot create a synonym with same name as object


create or replace synonym DBA_VIEWS for SYS.DBA_VIEWS
*
ERROR at line 1:
ORA-01471: cannot create a synonym with same name as object


create or replace synonym DBA_COL_PRIVS for SYS.DBA_COL_PRIVS
*
ERROR at line 1:
ORA-01471: cannot create a synonym with same name as object


create or replace synonym DBA_TRIGGERS for SYS.DBA_TRIGGERS
*
ERROR at line 1:
ORA-01471: cannot create a synonym with same name as object


create or replace synonym DBA_ROLE_PRIVS for SYS.DBA_ROLE_PRIVS
*
ERROR at line 1:
ORA-01471: cannot create a synonym with same name as object


create or replace synonym DBA_SYS_PRIVS for SYS.DBA_SYS_PRIVS
*
ERROR at line 1:
ORA-01471: cannot create a synonym with same name as object


create or replace synonym DBA_CONSTRAINTS for SYS.DBA_CONSTRAINTS
*
ERROR at line 1:
ORA-01471: cannot create a synonym with same name as object


create or replace synonym DBA_CONS_COLUMNS for SYS.DBA_CONS_COLUMNS
*
ERROR at line 1:
ORA-01471: cannot create a synonym with same name as object


create or replace synonym DBA_OBJ_AUDIT_OPTS for SYS.DBA_OBJ_AUDIT_OPTS
*
ERROR at line 1:
ORA-01471: cannot create a synonym with same name as object


create or replace synonym DBA_STMT_AUDIT_OPTS for SYS.DBA_STMT_AUDIT_OPTS
*
ERROR at line 1:
ORA-01471: cannot create a synonym with same name as object


create or replace synonym DBA_PRIV_AUDIT_OPTS for SYS.DBA_PRIV_AUDIT_OPTS
*
ERROR at line 1:
ORA-01471: cannot create a synonym with same name as object


create or replace synonym DBA_AUDIT_TRAIL for SYS.DBA_AUDIT_TRAIL
*
ERROR at line 1:
ORA-01471: cannot create a synonym with same name as object


create or replace synonym DBA_AUDIT_SESSION for SYS.DBA_AUDIT_SESSION
*
ERROR at line 1:
ORA-01471: cannot create a synonym with same name as object


create or replace synonym DBA_AUDIT_STATEMENT for SYS.DBA_AUDIT_STATEMENT
*
ERROR at line 1:
ORA-01471: cannot create a synonym with same name as object


create or replace synonym DBA_AUDIT_OBJECT for SYS.DBA_AUDIT_OBJECT
*
ERROR at line 1:
ORA-01471: cannot create a synonym with same name as object


create or replace synonym DBA_AUDIT_EXISTS for SYS.DBA_AUDIT_EXISTS
*
ERROR at line 1:
ORA-01471: cannot create a synonym with same name as object


create or replace synonym DBA_2PC_PENDING for SYS.DBA_2PC_PENDING
*
ERROR at line 1:
ORA-01471: cannot create a synonym with same name as object


create or replace synonym DBA_2PC_NEIGHBORS for SYS.DBA_2PC_NEIGHBORS
*
ERROR at line 1:
ORA-01471: cannot create a synonym with same name as object


create or replace synonym DBA_DEPENDENCIES for SYS.DBA_DEPENDENCIES
*
ERROR at line 1:
ORA-01471: cannot create a synonym with same name as object


create or replace synonym DBA_ERRORS for SYS.DBA_ERRORS
*
ERROR at line 1:
ORA-01471: cannot create a synonym with same name as object


create or replace synonym DBA_OBJECT_SIZE for SYS.DBA_OBJECT_SIZE
*
ERROR at line 1:
ORA-01471: cannot create a synonym with same name as object


create or replace synonym DBA_SOURCE for SYS.DBA_SOURCE
*
ERROR at line 1:
ORA-01471: cannot create a synonym with same name as object


create or replace synonym DBA_PROFILES for SYS.DBA_PROFILES
*
ERROR at line 1:
ORA-01471: cannot create a synonym with same name as object


create or replace synonym DBA_ROLES for SYS.DBA_ROLES
*
ERROR at line 1:
ORA-01471: cannot create a synonym with same name as object


create or replace synonym DBA_SNAPSHOTS for SYS.DBA_SNAPSHOTS
*
ERROR at line 1:
ORA-01471: cannot create a synonym with same name as object


create or replace synonym DBA_SNAPSHOT_LOGS for SYS.DBA_SNAPSHOT_LOGS
*
ERROR at line 1:
ORA-01471: cannot create a synonym with same name as object

After the successful execution of this script, I intend to run

a. ?/rdbms/admin/dbmspool.sql as sysdba
b. ?/rdbms/admin/spcreate.sql as sysdba

Then login as perfstat/perfstat
and do "exec statspack.snap;" and generate the report using
?/rdbms/admin/spreport.sql.


Re: Error while installing Statspack [message #137789 is a reply to message #137782] Fri, 16 September 2005 16:06 Go to previous messageGo to next message
oracledbanewbie
Messages: 6
Registered: August 2005
Junior Member
Sorry guys, I realized that I was running catdbsyn.sql from sys instead of system/manager. But I have got another problem now after generating the spreport. I am attaching the file. Where am I doing wrong? I have only one instance "Test" running on my machine.Thank you.

-Anand

  • Attachment: sp_2_20.lst
    (Size: 3.75KB, Downloaded 1321 times)
Re: Error while installing Statspack [message #137869 is a reply to message #137789] Sun, 18 September 2005 02:52 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member


Why do u need to run catdbsyn.sql for statspack ? Is there any specific reason for that.

And in ur case u need to run

statspack.snap twice to generate two snap-ids which is a minumum requirement to run spreport.sql.

Quote:

ERROR: End Snapshot Id specified does not exist for this database/instance


from oracle docs

Quote:

Statspack users become familiar with the concept of a snapshot, a single collection
of performance data. Each snapshot taken is identified by a snapshot ID, which is a
unique number generated at the time the snapshot is taken. Each time a new
collection is taken, a new SNAP_ID is generated.
The SNAP_ID, along with the database identifier (DBID) and instance number
(INSTANCE_NUMBER), comprise the unique key for a snapshot. Use of this unique
combination allows storage of multiple instances of an Oracle Real Application
Clusters database in the same tables.
After snapshots are taken, you can run the performance report. The report prompts
you for start and end snapshot IDs and then calculates activity on the instance
between the two snapshots,


take another snapshot and then generate report.
regards,
tarun



Re: Error while installing Statspack [message #138055 is a reply to message #137869] Mon, 19 September 2005 11:58 Go to previous message
oracledbanewbie
Messages: 6
Registered: August 2005
Junior Member
Hi Tarun,
Thanks for your suggestions. I was infact running the "exec statspack.snap" twice but was specifying the wrong id's. Your highlighting the error and the note U attached helped my sort out my (stupid) mistake.
Coming to catdbsyn.sql, it says catdbsyn.sql and dbmspool.sql need to be run before statspack can be installed. Even I though I ran it while installing Oracle 9i, just to be sure, I ran them again. Once again, thank you very much for the help.

-Anand
Previous Topic: how to increase search in the database
Next Topic: "slave shutdown wait" - event
Goto Forum:
  


Current Time: Thu Mar 28 10:52:06 CDT 2024