connection to remote server as sysdba [message #198471] |
Tue, 17 October 2006 05:06  |
M.Shakeel Azeem
Messages: 226 Registered: September 2006
|
Senior Member |
|
|
i am trying to connect to remote server
SQL> connect sys/change_on_install@wizerp
Connected.
SQL> connect sys/change_on_install@wizerp as sysdba
ERROR:
ORA-01017: invalid username/password; logon denied
Warning: You are no longer connected to ORACLE.
Can u guide me what could be the reason for not connecting as sysdba but it is connecting successfuly without sysdba
|
|
|
|
|
|
|
|
|
|
|
connection to remote server as sysdba [message #294651 is a reply to message #198471] |
Fri, 18 January 2008 05:54   |
shilpa_g2
Messages: 3 Registered: August 2006
|
Junior Member |
|
|
HI all
pl help
I am using oracle 9i RAC server on windows platform
When I log in database setting environment variable using
c:\set oracle_sid={database_name}
and log in using
c:\>sqlplus /nolog
sql>conn / as sysdba
I my database smoothly shutdowns and stratups by relevent commands
where as when I give this
sql>conn sys/change_on_install@{database_name} as sysdba
at the database server only. database shuts down without any problem but on startup it gives
ORACLE instance started.
ORA-12516: TNS:listener could not find available handler with matching protocol stack
why is so happening
how to resolve this problem.I need this because all the clients uses the second method to connect to server
Thanks in advance
[Updated on: Fri, 18 January 2008 06:50] by Moderator Report message to a moderator
|
|
|
|
|
|
|
|