OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » sqlplus (Oracle 10G O/s windows)

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

sqlplus [message #296767]

Tue, 29 January 2008 00:27

saagar
Messages: 79
Registered: December 2007

Member

dear all
i have manually created database and it is running successfully
the problem i am facing when ever i want to login as sysdba from sqlplusw ....not by command prompt it gives me error of ora-12560 TNS adapter well i checked with that i have create tnsnames and listener and they are running fine
when ever from sqlplusw i login as a sysdba it gets connected then gives me warning and ask to run PUPBLD.sql from system user this pupbld.sql is in /ORACLE_HOME/sqlplus/admin...

i run that and again restarted the database server now it is given same warning ...and i am not able to login from sqlplusw as sysdba
pls help me to resolve this error...

regards
SQL> conn
Enter user-name: sys as sysdba
Enter password: ******
ERROR:
ORA-12560: TNS:protocol adapter error

Report message to a moderator

Re: sqlplus [message #296768 is a reply to message #296767]

Tue, 29 January 2008 00:30

rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India

Senior Member

Quote:

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.

Rajuvan

Report message to a moderator

Re: sqlplus [message #296771 is a reply to message #296767]

Tue, 29 January 2008 00:38

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Set ORACLE_SID in your registry in HKLM\Software\Oracle\<your home> key.

Regards
Michel

Report message to a moderator

Previous Topic:	Contents of database buffer cache
Next Topic:	Metrics "Database Time Spent Waiting (%)" is at 30.09256 for event class "Commit"

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 12 02:04:59 CDT 2026