No question at this time
DBA Top 10
1 M. Cadot 7200
2 B. Vroman 3100
3 J. PĂ©ran 2100
4 A. Kavsek 1400
5 P. Tsongayinwe 1300
6 P. Wisse 600
7 D. Walgude 400
7 J. Schnackenberg 400
9 J. Alcroft 200
10 A. Hudspith 100
10 D. Johnson 100
10 B. B 100
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48684
Total active users1329
Act. users last 24h2
Act. users last hour0
Registered user hits last week44
Registered user hits last month235
Go up

ERROR: ORA-01017: invalid username/password; logon denied
Next thread: opatch error 255 in Azure (Azure is here important)
Prev thread: backup database plus archivelog

Message Score Author Date
Hi, When I try to login as a sys user in window...... Balaji M Jul 16, 2022, 16:46
Hello Balaji, is your OSUSER part of the ORADBA...... Bruno Vroman Jul 18, 2022, 09:13
Hi Bruno, I was able to fix this issue.We need ...... Balaji M Jul 18, 2022, 11:53

Follow up by mail Click here


Subject: ERROR: ORA-01017: invalid username/password; logon denied
Author: Balaji M, India
Date: Jul 16, 2022, 16:46, 32 days ago
Os info: Windows server
Oracle info: 19.0.0.0.0
Message: Hi,

When I try to login as a sys user in windows server, I get the below error.
Could somebody please help me to solve this issue.

C:\Users\egfmm>set ORACLE_HOME=F:\app\oracle\db_home

C:\Users\egfmm>set ORACLE_SID=DEVDB

C:\Users\egfmm>set PATH=F:\app\oracle\db_home\bin

C:\Users\egfmm>sqlplus

SQL*Plus: Release 19.0.0.0.0 - Production on Sat Jul 16 03:17:27 2022
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Enter user-name: / as sysdba
ERROR:
ORA-01017: invalid username/password; logon denied

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

Subject: Re: ERROR: ORA-01017: invalid username/password; logon denied
Author: Bruno Vroman, Belgium
Date: Jul 18, 2022, 09:13, 30 days ago
Message: Hello Balaji,

is your OSUSER part of the ORADBA group? If not, change this. If yes, check if sqlnet.ora contains SQLNET.AUTHENTICATION_SERVICES= (NTS) (if not, add it).

If not OK, find more info by seraching the web with "sqlplus / as sysdba windows"...

Best regards,

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

Subject: Re: ERROR: ORA-01017: invalid username/password; logon denied
Author: Balaji M, India
Date: Jul 18, 2022, 11:53, 30 days ago
Message: Hi Bruno,

I was able to fix this issue.We need to add the user to the group ORA_DBA in computer management.

Thank you for your solutions.

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