kimbrould
asked on
Unable to connect: sys as sysdba
Unable to connect to the Oracle dB after joining Server to the domain.
Able to connect when the server is a member of a Workgroup.
Steps performed:
Created Oracle's password file
init.ora parameter remote_login_passwordfile set to EXCLUSIVE
Not sure what else to check. Thanks.
Oracle 10.2.0.2.0
Windows Server 2003 STND
Able to connect when the server is a member of a Workgroup.
Steps performed:
Created Oracle's password file
init.ora parameter remote_login_passwordfile set to EXCLUSIVE
Not sure what else to check. Thanks.
Oracle 10.2.0.2.0
Windows Server 2003 STND
dalebetts
The o/s user that you're logged in as is owner of the oracle install ,correct?
In listener.ora you should set the new network address of the server and restart the listener.
Also see if the service is registered by the listener:
% lsnrctl services
Also see if the service is registered by the listener:
% lsnrctl services
Do you get any errors? What is it?
Check that your client machines can resolve the host name specified in the tnsnames.ora. If not, then you need to change it or update your local DNS so that the machine name with and without the domain can be resolved.
R.
Check that your client machines can resolve the host name specified in the tnsnames.ora. If not, then you need to change it or update your local DNS so that the machine name with and without the domain can be resolved.
R.
ASKER
Dale:
The OS User I am logging in with is not the owner of oracle install... it is a local admin and have been added to the dba_users group.
Schwertner:
The listener.ora is correct. The listener is running. I am able to log into the database as 'system' or another created user, just not as 'sys'.
Thanks.
The OS User I am logging in with is not the owner of oracle install... it is a local admin and have been added to the dba_users group.
Schwertner:
The listener.ora is correct. The listener is running. I am able to log into the database as 'system' or another created user, just not as 'sys'.
Thanks.
ASKER
rolutola:
sqlplus
sys as sysdba
<password>
ERROR:
ORA-01031: insufficient privileges
sqlplus
sys as sysdba
<password>
ERROR:
ORA-01031: insufficient privileges
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
Yep. recreate the password file.
orapwd FILE=<SID> PASSWORD=<password> ENTRIES=n (where n an integer)
R
R
To be exact file=orapw<sid>
Correct.
orapwd FILE=<orapwsid> PASSWORD=<password> ENTRIES=n (where n an integer)
orapwd FILE=<orapwsid> PASSWORD=<password> ENTRIES=n (where n an integer)
ASKER
i recreated the password file
i then created a user and grant SYSDBA and SYSOPER privs
select * from v$pwfile_users
and the newly created user (kimbro) is listed along with SYS
as a member of a workgroup... i could connect: sys as sysdba
i then joined the server to the domain... and could NOT connect: sys as sysdba
however, i was able to connect: kimbro as sysdba
Please advise. Thanks
i then created a user and grant SYSDBA and SYSOPER privs
select * from v$pwfile_users
and the newly created user (kimbro) is listed along with SYS
as a member of a workgroup... i could connect: sys as sysdba
i then joined the server to the domain... and could NOT connect: sys as sysdba
however, i was able to connect: kimbro as sysdba
Please advise. Thanks
connect to doamin
recreate passfile
try to connect
recreate passfile
try to connect
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
Thanks and sorry for the delay. I only could create the password file while in a WORKGROUP. Joined server to the domain, added domain account to ora_dba. Good to go. Thanks again. Take care.
thanks,
the intersting thing with os authentication is the ability to map a group ORA_TOTO on windows domain to an Oracle group TOTO...nearly the same as with ORA_DBA and sysdba role...on Unix box, not sure but it might work too....but be aware that this could result in a security hole...
the intersting thing with os authentication is the ability to map a group ORA_TOTO on windows domain to an Oracle group TOTO...nearly the same as with ORA_DBA and sysdba role...on Unix box, not sure but it might work too....but be aware that this could result in a security hole...
Check That you have "sqlnet.authentication_ser