OraFAQ Forum: Server Administration » connection to remote server as sysdba

Home » RDBMS Server » Server Administration » connection to remote server as sysdba

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

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

Report message to a moderator

Re: connection to remote server as sysdba [message #198483 is a reply to message #198471]

Tue, 17 October 2006 06:07

kimant
Messages: 201
Registered: August 2006
Location: Denmark

Senior Member

Try this

set ORACLE_SID=wizerp
sqlplus sys as sysdba

Br
Kim

Report message to a moderator

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

Report message to a moderator

Re: connection to remote server as sysdba [message #198638 is a reply to message #198614]

Wed, 18 October 2006 01:48

kimant
Messages: 201
Registered: August 2006
Location: Denmark

Senior Member

Have You created a password file?

Report message to a moderator

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

Report message to a moderator

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

Report message to a moderator

Re: connection to remote server as sysdba [message #198672 is a reply to message #198645]

Wed, 18 October 2006 03:53

kimant
Messages: 201
Registered: August 2006
Location: Denmark

Senior Member

Nice to hear that it worked Smile

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

Smile

Kim Anthonisen

Report message to a moderator

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

Report message to a moderator

Re: connection to remote server as sysdba [message #199107 is a reply to message #198827]

Fri, 20 October 2006 03:36

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

Report message to a moderator

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

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

varu123
Messages: 754
Registered: October 2007

Senior Member

Quote:

conn sys/change_on_install@{database_name} as sysdba

database_name or SID

Report message to a moderator

Re: connection to remote server as sysdba [message #294665 is a reply to message #294651]

Fri, 18 January 2008 06:42

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

Smile

Kim

Report message to a moderator

Re: connection to remote server as sysdba [message #294667 is a reply to message #294651]

Fri, 18 January 2008 06:49

Michel Cadot
Messages: 68683
Registered: March 2007
Location: Nanterre, France, http://...

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

Report message to a moderator

Re: connection to remote server as sysdba [message #294783 is a reply to message #294665]

Sat, 19 January 2008 02:22

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

Report message to a moderator

Re: connection to remote server as sysdba [message #294864 is a reply to message #294783]

Sun, 20 January 2008 04:49

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?

Report message to a moderator

Previous Topic:	alter sysdba login
Next Topic:	problem in login the oracle user

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 16 05:47:38 CDT 2024