| ORA-12560: TNS:protocol adapter error [message #149969] |
Mon, 05 December 2005 19:29  |
juicyapple
Messages: 92
Registered: October 2005
|
Member |
|
|
When I connect to sqlplus with one of the user account, it is ok. But when I connect as sysdba:
conn sys/manager as sysdba
it shows ORA-12560: TNS:protocol adapter error
Does anyone knows what's wrong with this?
Thanks.
|
|
|
|
| Re: ORA-12560: TNS:protocol adapter error [message #149976 is a reply to message #149969] |
Mon, 05 December 2005 20:47  |
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
|
Senior Member |
|
|
Your are trying to connect using 'manager' as the password for sys. Manager is sometimes the default password for the system user. I believe you can only use the / as sysdba on the sys user.
Try:
1) sqlplus
username>sys / as sysdba
password> anything
Then change sys's password (alter user sys identified by newpassword;)
OR
2) sqlplus
username>system (do not use the /as sysdba part on anything but sys)
password> enter whatever the password is. On some versions 'manager' was the default.
Once you get in on either account change the passwords to ones you know. Use good password skills (i.e. must have at least 8 characters, must have digit and alpha, can not be the username, can not be too simple, ...)
See $ORACLE_HOME/rdbms/admin/utlpwmt.sql (I think) or maybe it is utlpgmt.sql? for clues here. Anyway, it describes a password complexity scheme that can be enforced via Oracle's profiles.
|
|
|
|
|
|
| Re: ORA-12560: TNS:protocol adapter error [message #149982 is a reply to message #149969] |
Mon, 05 December 2005 21:08 |
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
|
Senior Member |
|
|
I am sorry I do not really understand what you are asking.
I think using the '@XXXXX' part is like doing a 'loopback' test.
What O/S are you using?
What database version are you on?
Don't post any passwords.
|
|
|
|
| Re: ORA-12560: TNS:protocol adapter error [message #149984 is a reply to message #149969] |
Mon, 05 December 2005 21:18 |
juicyapple
Messages: 92
Registered: October 2005
|
Member |
|
|
I am using winxp sp 2, oracle 9i release 2
What I mean is if I connect like this:
SQL> conn sys/manager@mmt as sysdba
SQL> connected
but if
SQL> conn system/manager as sysdba
ERROR:
ORA-12560: TNS:protocol adapter error
in oracle/ora92/network/admin/tnsnames.ora, the configuration is like this:
mmt =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Server1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = mmt)
)
)
in listener.ora,
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Server1)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = mmt)
(ORACLE_HOME = C:\oracle\ora92)
(PROGRAM = extproc)
)
)
|
|
|
|
| Re: ORA-12560: TNS:protocol adapter error [message #149988 is a reply to message #149984] |
Mon, 05 December 2005 22:40 |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
Do you have more than one database on your system?
If it is so then set the environment variable to the SID of this database and then try to connect.
c:\> set ORACLE_SID=your_sid
and then try to connect.
And please dont post the same question twice.
|
|
|
|
|
|
| Re: ORA-12560: TNS:protocol adapter error [message #150884 is a reply to message #150009] |
Sun, 11 December 2005 14:52 |
vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad
|
Senior Member |
|
|
not sure what exactly are u asking for ....considering the statement below .. Your db seems to be present in a remote machine and you using tns to connect to it ..
First one is working since you used @mmt ..second one is failing since u dint used it ..
SQL> conn sys/manager@mmt as sysdba
SQL> connected
but if
SQL> conn system/manager as sysdba
ERROR:
ORA-12560: TNS:protocol adapter error
-Sai Jeedigunta
|
|
|
|
) 1 Vote
] 
Blog
Search
Help
Members
Register
Login
Home
