OraFAQ Forum: Security » remote db connectvity

Home » RDBMS Server » Security » remote db connectvity

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

remote db connectvity [message #137048]

Tue, 13 September 2005 00:08

balasmg
Messages: 31
Registered: June 2005
Location: bangalore

Member

Hi DBA’s

I want to connect remote machine th’ oracle enterprise manager. (OEM) or sql *plus
While I connect with scott/tiger I am able to connect. Via sql*plus
But when I connect as sys, I am getting an error as
ERROR:
ORA-01031: insufficient privileges

Warning: You are no longer connected to ORACLE.

I was able to connect

What may be the reason. Is there any init parameter need to be set.

Report message to a moderator

Re: remote db connectvity [message #137049 is a reply to message #137048]

Tue, 13 September 2005 00:14

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

1. How u r trying to connect to the remote machine? Are u using Oracle Net service to connect?

--- If u r able to connect through scott then sys should not be a problem. Do u have any other oracle database running on your remote machine ( through which u r trying to connect) ?

Its better if u post the entire scenario. With your OS ( both - client & server) & Oracle version.

regards,
tarun

[Updated on: Tue, 13 September 2005 00:16]

Report message to a moderator

Re: remote db connectvity [message #137058 is a reply to message #137049]

Tue, 13 September 2005 01:24

balasmg
Messages: 31
Registered: June 2005
Location: bangalore

Member

using net8 configuration assistant, i created and i am able to connect to remote database using the connect string.
i am not able to connect as sys user in remote database.
is that any init. parameter need to be set

Report message to a moderator

Re: remote db connectvity [message #137065 is a reply to message #137058]

Tue, 13 September 2005 01:38

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

1. Check whether a password file exist on the server. If it is not there then create a password file using ORAPWD utility .

2. Check the paramter in init file,

REMOTE_LOGIN_PASSWORDFILE and set it to EXCLUSIVE .

regards,
tarun

Report message to a moderator

Re: remote db connectvity [message #137077 is a reply to message #137048]

Tue, 13 September 2005 02:13

balasmg
Messages: 31
Registered: June 2005
Location: bangalore

Member

Hi Tarun,
tks for response.
presently remote_login_passwordfile = none.

how to create a password file in oracle 9i/solaris box and how to set the same.

what it really does. why it has no issue for scott user connecion and gives error on sys user.

regards
-bala

Report message to a moderator

Re: remote db connectvity [message #137081 is a reply to message #137077]

Tue, 13 September 2005 02:26

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

yes, this is the problem .

creating a password file ( if it does not exist) & setting this parameter to EXCLUSIVE should solve the problem.

>> how to create a password file in oracle 9i/solaris

Sol: Method is same for all OSs & it is given in the attached file.

>> how to set the same?

Sol: Open pfile & change

REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE

& then start the database with this pfile .

>> what it really does. why it has no issue for scott user connecion and gives error on sys user?

Sol: This parameter is meant for remote administration so no issue for scott( not a sysdba).

I hav attached a portion of Oracle documentation regarding password file, rest u can read from documentation.

regards,
tarun