OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » STATPACK REPORT

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

STATPACK REPORT [message #247528]

Tue, 26 June 2007 04:35

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

Report message to a moderator

Re: STATPACK REPORT [message #247644 is a reply to message #247528]

Tue, 26 June 2007 11:29

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

tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi

Senior Member

yes i m able to connect with other user even with same user later

Report message to a moderator

Re: STATPACK REPORT [message #247712 is a reply to message #247528]

Tue, 26 June 2007 23:47

BlackSwan
Messages: 26766
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.

Report message to a moderator