No question at this time
DBA Top 10
1 M. Cadot 6600
2 B. Vroman 3400
3 J. Péran 2200
4 A. Kavsek 1400
5 P. Tsongayinwe 900
6 P. Wisse 600
7 T. Boles 400
7 D. Walgude 400
7 D. Johnson 400
10 J. Alcroft 200
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48675
Total active users1328
Act. users last 24h0
Act. users last hour0
Registered user hits last week23
Registered user hits last month452
Go up

login as sysdba
Next thread: Application slowness performance issue
Prev thread: ORA-02019 : connection description for remote database not found

Message Score Author Date
Hi I am having problem with 4 of our databases ...... James Alcroft Apr 28, 2022, 17:12
Hi James, I have some suggestions for you :...... Score: 800 PtsScore: 800 PtsScore: 800 PtsScore: 800 PtsScore: 800 Pts Joël Péran Apr 29, 2022, 08:58
Thanks Joel I wasn't a member of ORA_DBA group....... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts James Alcroft Apr 29, 2022, 10:24
Hi James Well, glad I could help, this is what...... Joël Péran Apr 29, 2022, 11:16

Follow up by mail Click here


Subject: login as sysdba
Author: James Alcroft, United Kingdom
Date: Apr 28, 2022, 17:12, 65 days ago
Os info: Windows 2019
Oracle info: 19.3
Message: Hi

I am having problem with 4 of our databases (all on different servers) out of about 30 databases.

Basically, when i login as:
sqlplus / as sysdba

I get username or password unknow. I can login as sys, using the same password defined when I ran ORAPWD.

If I login using RMAN TARGET / causes rman to crash.

What am I missing on this server to allow me to login using / as sysdba - the database (as with all our other databases) is setup to allow NT Authentication, although this something different.

Many thanks

James


Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: login as sysdba
Author: Joël Péran, France
Date: Apr 29, 2022, 08:58, 65 days ago
Score:   Score: 800 PtsScore: 800 PtsScore: 800 PtsScore: 800 PtsScore: 800 Pts
Message: Hi James,

I have some suggestions for you :
- check if you are member of ORACLE_DBA group for the server where the databases are located on, and then check sqlnet.ora file on the server side, if you have : SQLNET.AUTHENTICATION_SERVICES = (NTS).
- you have a parameter in init.ora file (remote_login_passwordfile=EXCLUSIVE)
Usually, this is far enough to connect / as sysdba. If you can't add any member to oracle_dba group, then put the sqlnet.ora parameter to none, and it should work as well.
Regards,
Joel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: login as sysdba
Author: James Alcroft, United Kingdom
Date: Apr 29, 2022, 10:24, 65 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: Thanks Joel

I wasn't a member of ORA_DBA group.

Well, I was when I built the machine, but then our IT team (who know nothing about Oracle) took over server management and decided i didn't need to RDP to these machines so removed my account. When they recreated it, I wasn't put back into this group.

Thanks again

James
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: login as sysdba
Author: Joël Péran, France
Date: Apr 29, 2022, 11:16, 65 days ago
Message: Hi James

Well, glad I could help, this is what this forum is used for :)
Have a great day and a great weekend

Best regards,
Joel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here