-
How to connect as sysdba remotely
Hi all,
I need to connect as sys to a database XYZ on server-A from server-B. On Server-B, I have TNS entry for XYZ.
I am trying following command on server-B but it is not working.
sqlplus "/ as sysdba"@XYZ
Please note I do not want to use sys password here.
Please help.
Thanks in Advance,
Sam
Last edited by samdba; 12-04-2010 at 01:06 PM.
Sam
------------------------
To handle yourself, use your head. To handle others, use your heart
-
It is the connection as sysdba, not sysdba at SID.
Conn un/pwd@sid as sysdba, not conn un/pwd as sysdba @sid.
You will have to use the password since you are not on the server. You won't get the benefit of OS authentication.
If you are on the server, you can do things like conn fake_un/fake_pwd as sysdba and still connect. If over the network, you have to use real username and password.
Can you use/try conn username@sid as sysdba and get a prompt for the password?
-
Thanks for your reply.
Yes, I can do sqlplus sys@XYZ as sysdba and then it prompts for password and let me connect after I give the password.
I want to connect as sys from the unix shell script and therefore, I cannot have it prompt for password.
Is there any other alternate?
Thanks,
Sam
Sam
------------------------
To handle yourself, use your head. To handle others, use your heart
-
file name = secret_data.txt
#contents of the file:
sys_pass=whatever
Your script:
#! /bin/ksh (or whatever shell)
#source the password file
. ./path_to/secret_data.txt
sqlplus -s username/$sys_pass@wherever as sysdba << END
...
END
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|