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
|
|
|
|
Re: connection to remote server as sysdba [message #198614 is a reply to message #198483] |
Wed, 18 October 2006 00:22 |
M.Shakeel Azeem
Messages: 226 Registered: September 2006
|
Senior Member |
|
|
Dear Sir,
I also have tried this
But my query was 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.
SQL> conn sys/change_on_install@wizerp
Connected.
Why connection sys as sysdba is not possible?
this is query i put on forum
Can u guide me in this regard?
i hope u won't mind it and help me
|
|
|
|
Re: connection to remote server as sysdba [message #198640 is a reply to message #198638] |
Wed, 18 October 2006 01:53 |
kimant
Messages: 201 Registered: August 2006 Location: Denmark
|
Senior Member |
|
|
You should have a password file, and SYS should have the same password as is in that file.
If You have no idea what I am talking about, just try to alter SYS' password (no change, but it will put the correct password in the password file)
> alter user sys identified by change_on_install;
Then try to connect again.
Br
Kim
|
|
|
Re: connection to remote server as sysdba [message #198645 is a reply to message #198640] |
Wed, 18 October 2006 02:09 |
M.Shakeel Azeem
Messages: 226 Registered: September 2006
|
Senior Member |
|
|
thanx for ur prompt response
i got it right
At my local machine the password for sysdba was gateway
but at remote server the password used for sysdba was change_on_install
so my perception is when we are trying to connect as sysdba either at remote side or local the password file of local client is used
so when we are trying to connect as sysdba to remote server,the password conflicts (at local and remote side )occurs causing invalid username/password
but when i changed the password for sysdba at remote side
alter user sys identified by gateway(the same password at local)
as you suggested Now the problem has been resolved
Am i right Sir?
Will you plzzz add some comments?
anyhow thanks a lot
|
|
|
|
Re: connection to remote server as sysdba [message #198827 is a reply to message #198672] |
Wed, 18 October 2006 13:15 |
M.Shakeel Azeem
Messages: 226 Registered: September 2006
|
Senior Member |
|
|
Dear Sir
I know the password for sysdba is stored in password file whic exists at server side
and when we are about to connect as sysdba from a client then
sys as sysdba will be authenticated from password file at remote server
am i right Sir?
But Now the confusion is
i have 8.1.7 at client and password for sysdba is set as "gateway"
and the password for sysdba at remote server is set as change_on_install (By Default)
Although when i issue
SQL>connect sys/change_on_install@remotedb as sysdba
sys should be authenticated from password file at remote server
am i right Sir?
But it was unable to connect and when i tried
SQL>connect sys/change_on_install@remotedb
it was successfully connected
May be i am wrong 100%
but when i set the same password as "gateway" at remote server by
SQL>alter user sys identified by gateway;
This will the change the password in database as well as in password file
and when i tried
SQL>connect sys/gateway@remotedb as sysdba
connected
Now i am not clear rather i am confused what is happening behind this?
Can u guide me in this regard Sir?
thanx in advance
|
|
|
|
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
|
|
|
|
|
|
|
|