Home » RDBMS Server » Server Administration » STATPACK REPORT
STATPACK REPORT [message #247528] Tue, 26 June 2007 04:35 Go to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
Hi
using 10 release 2 on windows

While i m creating the statpack report like while running the script spcreate.sql connection failed and getting the error

NOTE:
SPCUSR complete. Please check spcusr.lis for any errors.

SQL>
SQL> --
SQL> -- Build the tables and synonyms
SQL> connect perfstat/&&perfstat_password
ERROR:
ORA-12560: TNS:protocol adapter error


Warning: You are no longer connected to ORACLE.
SQL> @@spctab
Re: STATPACK REPORT [message #247644 is a reply to message #247528] Tue, 26 June 2007 11:29 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
can you connect oracle as your other existing users??


ORA-12560: TNS:protocol adapter error


ORA-12560:	TNS:protocol adapter error
Cause:	A generic protocol adapter error occurred.
Action:	Check addresses used for proper protocol specification. Before reporting this error, look at the error
 stack and check for lower level transport errors. 
For further details, turn on tracing
 and reexecute the operation. Turn off tracing when the operation is complete.

[Updated on: Tue, 26 June 2007 11:29]

Report message to a moderator

Re: STATPACK REPORT [message #247709 is a reply to message #247644] Tue, 26 June 2007 23:37 Go to previous messageGo to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
yes i m able to connect with other user even with same user later
Re: STATPACK REPORT [message #247712 is a reply to message #247528] Tue, 26 June 2007 23:47 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
I can not reconcile two contradictory statemets by OP.
On one hand it appears that OP is working with a local DB.
On the other hand the ORA-12560 screams SQL*NET
OP describes but NEVER shows via CUT & PASTE complete interaction

When thing do not appear to be as they should, they probably are not as they should be.

I suspect we are not being told the truth, the whole truth & nothing but the truth.

I awaits more/complete details.


Re: STATPACK REPORT [message #247749 is a reply to message #247528] Wed, 27 June 2007 02:04 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,

Are you check your alert<sid>.log file.


Regards
Taj
Re: STATPACK REPORT [message #248036 is a reply to message #247749] Wed, 27 June 2007 17:43 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
I had this problem in RAC enviroment ...
still getting the same problem??
try One by one

@@spcusr
@@spctab
@@spcpkg

[Updated on: Wed, 27 June 2007 17:43]

Report message to a moderator

Previous Topic: Tablespace Size Checking Script
Next Topic: Oracle DB and DATA file in different Drive (merged)
Goto Forum:
  


Current Time: Fri Dec 09 13:41:22 CST 2016

Total time taken to generate the page: 0.16807 seconds