Home » RDBMS Server » Server Administration » connection to remote server as sysdba
connection to remote server as sysdba [message #198471] Tue, 17 October 2006 05:06 Go to next message
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 #198483 is a reply to message #198471] Tue, 17 October 2006 06:07 Go to previous messageGo to next message
kimant
Messages: 201
Registered: August 2006
Location: Denmark
Senior Member
Try this

set ORACLE_SID=wizerp
sqlplus sys as sysdba

Br
Kim
Re: connection to remote server as sysdba [message #198614 is a reply to message #198483] Wed, 18 October 2006 00:22 Go to previous messageGo to next message
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 #198638 is a reply to message #198614] Wed, 18 October 2006 01:48 Go to previous messageGo to next message
kimant
Messages: 201
Registered: August 2006
Location: Denmark
Senior Member
Have You created a password file?
Re: connection to remote server as sysdba [message #198640 is a reply to message #198638] Wed, 18 October 2006 01:53 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 #198672 is a reply to message #198645] Wed, 18 October 2006 03:53 Go to previous messageGo to next message
kimant
Messages: 201
Registered: August 2006
Location: Denmark
Senior Member
Nice to hear that it worked Smile

It is not a local password You used.
"gateway" is the password stored in the password file on the server.

When You alteret SYS's password, You effectively change the password for SYS in the database as well as in the password file. So now they are the same.....

Look up "password file" in the docs.

Smile
Kim Anthonisen
Re: connection to remote server as sysdba [message #198827 is a reply to message #198672] Wed, 18 October 2006 13:15 Go to previous messageGo to next message
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
Re: connection to remote server as sysdba [message #199107 is a reply to message #198827] Fri, 20 October 2006 03:36 Go to previous messageGo to next message
kimant
Messages: 201
Registered: August 2006
Location: Denmark
Senior Member
Hi

As I wrote, You should really read about it in the docs.
It is not very hard to use, and You will come to love it.

http://www.oracle.com/pls/tahiti/tahiti.drilldown?remark=&word=password+file&book=&preference=

Fx.

Concepts + Authentication of Database Administrators:
http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76965/c25acces.htm#6126

and

Administrator's Guide + Using an Authentication Password File
http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76956/dba.htm#1167

In this, You find

Quote:

PASSWORD
This parameter sets the password for SYSOPER and SYSDBA. If you issue the ALTER USER statement to change the password after connecting to the database, both the password stored in the data dictionary and the password stored in the password file are updated. The INTERNAL user is supported for backwards compatibility only. This parameter is mandatory.




Br
Kim Anthonisen
connection to remote server as sysdba [message #294651 is a reply to message #198471] Fri, 18 January 2008 05:54 Go to previous messageGo to next message
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

Re: problem with "conn sys/change_on_install@{database_name} as sysdba" [message #294655 is a reply to message #198471] Fri, 18 January 2008 06:04 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Quote:
conn sys/change_on_install@{database_name} as sysdba


database_name or SID
Re: connection to remote server as sysdba [message #294665 is a reply to message #294651] Fri, 18 January 2008 06:42 Go to previous messageGo to next message
kimant
Messages: 201
Registered: August 2006
Location: Denmark
Senior Member
Hi

I think You are hiding some rather important details.

Your clients do not log on as SYS - do they?

Your database does not shutdown and startup all by it self, when You log on as SYS - right?

Smile
Kim
Re: connection to remote server as sysdba [message #294667 is a reply to message #294651] Fri, 18 January 2008 06:49 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Copy and paste your screen and not just describe your actions.

please read and follow OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format. Use the "Preview Message" button to verify.
Always post your Oracle version (4 decimals).

In addtion,
ORA-12516: TNS:listener could not find available handler with matching protocol stack
 *Cause: None of the known and available service handlers for the given
 SERVICE_NAME support the client's protocol stack: transport, session,
 and presentation protocols.
 *Action: Check to make sure that the service handlers (e.g. dispatchers)
 for the given SERVICE_NAME are registered with the listener, are accepting
 connections, and that they are properly configured to support the desired
 protocols.


Regards
Michel
Re: connection to remote server as sysdba [message #294783 is a reply to message #294665] Sat, 19 January 2008 02:22 Go to previous messageGo to next message
shilpa_g2
Messages: 3
Registered: August 2006
Junior Member
yes true Client is not loging as sys. but i use client machine to loging in case of any urgency as it is not possible to go to server room when required, because of the distance
Re: connection to remote server as sysdba [message #294864 is a reply to message #294783] Sun, 20 January 2008 04:49 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

shilpa_g2 wrote on Sat, 19 January 2008 14:22
yes true Client is not loging as sys. but i use client machine to loging in case of any urgency as it is not possible to go to server room when required, because of the distance


Is it a joke of the day! You want to access another computer and you will go there by plane or by bus?
Previous Topic: alter sysdba login
Next Topic: problem in login the oracle user
Goto Forum:
  


Current Time: Mon Dec 02 05:57:43 CST 2024