No question at this time
DBA Top 10
1 M. Cadot 6300
2 B. Vroman 2700
3 P. Tsongayinwe 1500
4 P. Wisse 1300
4 J. PĂ©ran 1300
6 A. Kavsek 900
7 D. Walgude 400
7 J. Schnackenberg 400
9 J. Alcroft 200
10 A. Hudspith 100
10 L. Ywema 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 users48709
Total active users1322
Act. users last 24h2
Act. users last hour0
Registered user hits last week33
Registered user hits last month217
Go up

ORA-01017: invalid username/password; logon denied
Next thread: High swap utilization
Prev thread: sqlserver sql removes script execution plan/stats immediately after completion

Message Score Author Date
Hi oracle experts, As part of OS patch, I have ...... Balaji M Jun 12, 2022, 11:21
Crossref: http://www.orafaq.com/forum/mv/msg/20...... Michel Cadot Jun 12, 2022, 11:29
Michel, So what now? Regards, Balaji... Balaji M Jun 12, 2022, 11:35
Hi Balaji M, You won't need a password if you c...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Philip Wisse Jun 12, 2022, 14:59
Hi Philip, Could you please let me know the cau...... Balaji M Jun 13, 2022, 12:32
Hi Balaji, It could be a problem in your enviro...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Philip Wisse Jun 14, 2022, 13:56
Hi Philip, Thank you. Regards, Balaji... Balaji M Jun 15, 2022, 11:56
Hi Philip, "Typically your user account must be...... Balaji M Jun 17, 2022, 12:20
Hi Balaji, Yes you're in the dba group. Now ...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Philip Wisse Jun 17, 2022, 17:30
Thank you... Balaji M Nov 26, 2022, 12:18

Follow up by mail Click here


Subject: ORA-01017: invalid username/password; logon denied
Author: Balaji M, India
Date: Jun 12, 2022, 11:21, 169 days ago
Os info: Red hat Linux 7.9
Oracle info: Oracle 12.2.1.0
Message: Hi oracle experts,

As part of OS patch, I have shutdown the database and when I try to bring the database up,
I am not able to login to the database using sys user with sqlplus.
I get the below error when I login to the database.
ORA-01017: invalid username/password; logon denied

Could someone please let me know the cause of the issue.

Quote:
FYI- OS patch will install only latest version of the package and it will also update kernel parameters.

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

Subject: Re: ORA-01017: invalid username/password; logon denied
Author: Michel Cadot, France
Date: Jun 12, 2022, 11:29, 169 days ago
Message:
Crossref:
http://www.orafaq.com/forum/mv/msg/208027/686087/

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

Subject: Re: ORA-01017: invalid username/password; logon denied
Author: Balaji M, India
Date: Jun 12, 2022, 11:35, 169 days ago
Message: Michel,

So what now?

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

Subject: Re: ORA-01017: invalid username/password; logon denied
Author: Philip Wisse, Netherlands
Date: Jun 12, 2022, 14:59, 169 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: Hi Balaji M,

You won't need a password if you connect '/ as sysdba'.
Typically your user account must be a member of 'dba' os group.
https://docs.oracle.com/database/121/ADMQS/GUID-DE8A79BD-FAE4-4364-98FF-D2BD992A06E7.htm#ADMQS0361

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

Subject: Re: ORA-01017: invalid username/password; logon denied
Author: Balaji M, India
Date: Jun 13, 2022, 12:32, 168 days ago
Message: Hi Philip,

Could you please let me know the cause of the issue.
I was able to login to the database using sqlplus before the os patch and not able to login
to the database after the os patch.

FYI - os patch didn't succeed after server reboot.

Regards,
Balaji

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

Subject: Re: ORA-01017: invalid username/password; logon denied
Author: Philip Wisse, Netherlands
Date: Jun 14, 2022, 13:56, 167 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: Hi Balaji,

It could be a problem in your environment.
Use the 'set' or 'export' commando to show the environment.
For instance all settings starting with 'ORACLE' are important, especially ORACLE_SID. And also TWO_TASK.
This is case sensitive on Linux.
https://docs.oracle.com/database/121/ADMQS/GUID-EC18C4A6-3BA5-4C14-9D76-B0DD62FEFFF2.htm#ADMQS12369

After a reboot the file /etc/oraenv is important.
https://www.orafaq.com/wiki/Oraenv

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

Subject: Re: ORA-01017: invalid username/password; logon denied
Author: Balaji M, India
Date: Jun 15, 2022, 11:56, 166 days ago
Message: Hi Philip,

Thank you.

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

Subject: Re: ORA-01017: invalid username/password; logon denied
Author: Balaji M, India
Date: Jun 17, 2022, 12:20, 164 days ago
Message: Hi Philip,

"Typically your user account must be a member of 'dba' os group."
[oracle@server11 ~]$ id

uid=1011(oracle)gid=1011(oinstall)groups=1011(oinstall),200(dba)
Could you please check this and suggest.

Regards,
Balaji

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

Subject: Re: ORA-01017: invalid username/password; logon denied
Author: Philip Wisse, Netherlands
Date: Jun 17, 2022, 17:30, 164 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: Hi Balaji,

Yes you're in the dba group.

Now the database needs to be up : check tnsping
Now the listener needs to be up : check lsnrctl
Important files in the dbs folder: pfile (or init.ora)
Also in this folder will be a password file (generally *.pw).
Important setting: REMOTE_LOGIN_PASSWORDFILE
https://satya-dba.blogspot.com/2009/11/password-file-in-oracle.html
Besides tnsnames.ora there's a file sqlnet.ora, is it recently changed?

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

Subject: Re: ORA-01017: invalid username/password; logon denied
Author: Balaji M, India
Date: Nov 26, 2022, 12:18, 2 days ago
Message: Thank you
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here