Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> ORA-01017: invalid username/password; logon denied, Unable to login
Basant Gupta
post Apr 11 2017, 05:23 AM
Post #1


Newbie
*

Group: Members
Posts: 1
Joined: 11-April 17
Member No.: 51,902



Hi Dba's

I have created another os user on my oracle server and assigned oinstall greoup to this.
I am unable to login through sqlplus "/as sysdba", but all binary owner is oracle(super DBA) user and my new user are in same group i.e oinstall
please help me.
Go to the top of the page
 
+Quote Post
burleson
post Apr 11 2017, 10:28 AM
Post #2


Advanced Member
***

Group: Members
Posts: 13,380
Joined: 26-January 04
Member No.: 13



Hi Basant and welcome to the forum!

>> ORA-01017

Try adding a user named oracle in /etc/users in the dba group.

See here:

http://www.dba-oracle.com/t_ora_01017.htm

If using external OS user authentication (ops$ or remote_os_authent) you need to verify that the user ID is valid. You can tell if you are using external authentication because you connect without providing a user/password combination, and only provide a forward slash to the connect string, (e.g. connect / as sysdba;).




--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 28th April 2017 - 08:43 PM