| ORAPWD [message #159676] |
Mon, 20 February 2006 22:08  |
gajini
Messages: 262
Registered: January 2006
|
Senior Member |
|
|
I create a password file for remote login as SYSDBA and i granted SYSDBA privilege to SYSTEM user,the initialization parameter remote_login_passwordfile=EXCLUSIVE is also set,but when i tried to connect from the client with the following command "CONNECT SYSTEM/password AS SYSDBA",it gives TNS-protocol adapter error.
but there is no problem when i tried to connect to the database from the client.
The server is running in Windows XP & the client from which i want to connect as SYSDBA is in Windows 2000.
Can anyone explian me how to troubleshoot this problem?.Do I've to make any changes in TNSNAMES.ORA?
Please anyone answer asap.
[Updated on: Mon, 20 February 2006 22:32] Report message to a moderator |
|
|
|
| Re: ORAPWD [message #159679 is a reply to message #159676] |
Mon, 20 February 2006 22:37  |
milind_sri
Messages: 70
Registered: February 2005
Location: Pune
|
Member |
|
|
Hi,
I would suggest dont mess with the system user. Password file is meant for SYS schema evenif you can provide sysdba privilege to other users.
So, create a password file using:-
orapwd file=filename password=password entries=max_users
The filename is the name of the file that will hold the password information. The file location will default to the current directory unless the full path is specified. The contents are encrypted and are unreadable. The password required is the one for the SYS user of the database.
Confirm that the user is listed in the password file.
SQL> select * from v$pwfile_users;
USERNAME SYSDBA SYSOPER
------------------------------ ------ -------
SYS TRUE TRUE
I think this will resolve your problem.
HTH
Milind.
|
|
|
|
| Re: ORAPWD [message #159686 is a reply to message #159676] |
Mon, 20 February 2006 23:22 |
Brayan
Messages: 315
Registered: June 2002
|
Senior Member |
|
|
Milind,
I have a doubt, once password file is created for SYS, how to add users to it?
Brayan.
|
|
|
|
|
|
| Re: ORAPWD [message #159705 is a reply to message #159693] |
Tue, 21 February 2006 00:09 |
gajini
Messages: 262
Registered: January 2006
|
Senior Member |
|
|
|
My doubt is not in creating password file,please tell me how to avoid the error(which i mentioned in the 1st msg) what i got while trying to connect SYTEM/password as SYSDBA or any user who granted sysdba privilege & added to the password file.
|
|
|
|
| Re: ORAPWD [message #159709 is a reply to message #159676] |
Tue, 21 February 2006 00:21 |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
| gajini wrote on Tue, 21 February 2006 09:38 |
but when i tried to connect from the client with the following command "CONNECT SYSTEM/password AS SYSDBA",
|
As you said you are connecting through a client so you should connect something like this.
CONNECT SYSTEM/password@YOUR_SERVICE_NAME AS SYSDBA
Have you created any network service to connect Oracle from client?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
