• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4087
  • Last Modified:

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
0
kimbrould
Asked:
kimbrould
  • 4
  • 4
  • 3
  • +4
2 Solutions
 
dalebettsCommented:
The o/s user that you're logged in as is owner of the oracle install ,correct?
0
 
schwertnerCommented:
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
0
 
Richard OlutolaConsultantCommented:
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.
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
kimbrouldAuthor Commented:
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.
0
 
kimbrouldAuthor Commented:
rolutola:

sqlplus
sys as sysdba
<password>

ERROR:
ORA-01031: insufficient privileges
0
 
KICUSekCommented:
Try to recreate password file.
0
 
Richard OlutolaConsultantCommented:
Yep. recreate the password file.
0
 
Richard OlutolaConsultantCommented:
orapwd FILE=<SID> PASSWORD=<password> ENTRIES=n (where n an integer)

R
0
 
KICUSekCommented:
To be exact file=orapw<sid>
0
 
Richard OlutolaConsultantCommented:
Correct.

orapwd FILE=<orapwsid> PASSWORD=<password> ENTRIES=n (where n an integer)
0
 
kimbrouldAuthor Commented:
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

0
 
KICUSekCommented:
connect to doamin
recreate passfile
try to connect
0
 
DOCJEMCommented:
Hello,

I think that on Windows servers, the domain user you are trying to use to connect as sysdba must be declared in the local ORA_DBA group (on the database machine), group which is normally created at installation

hope it helps
0
 
kimbrouldAuthor Commented:
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.
0
 
DOCJEMCommented:
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...
0
 
ytarkanCommented:
Check That you have "sqlnet.authentication_services=(NTS)" in sqlnet.ora file. If this is set to NONE instead of NTS you can not connect. Correct and try again
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 4
  • 4
  • 3
  • +4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now