Home » RDBMS Server » Server Administration » How to set password login / as sysdba sqlplus on database oracle 11g (Oracle 11g, Linux 5.10)
icon5.gif  How to set password login / as sysdba sqlplus on database oracle 11g [message #625996] Sat, 18 October 2014 01:10 Go to next message
trybestpro
Messages: 17
Registered: September 2014
Location: HCM
Junior Member
Hi, all

I want oracle ask password when I login sqlplus / as sysdba.

I was guided: open sqlnet.ora and change SQLNET.AUTHENTICATION_SERVICES= (NTS) to: SQLNET.AUTHENTICATION_SERVICES= (NONE)

But, it not working for me.
Now, I want oracle ask me to enter password if I login / as sysdba in sqlplus. Help me, please!
Thanks.

--- Best regards.
Re: How to set password login / as sysdba sqlplus on database oracle 11g [message #625997 is a reply to message #625996] Sat, 18 October 2014 02:37 Go to previous messageGo to next message
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

What does "But, it not working for me." mean?

Re: How to set password login / as sysdba sqlplus on database oracle 11g [message #626001 is a reply to message #625997] Sat, 18 October 2014 07:14 Go to previous messageGo to next message
EdStevens
Messages: 887
Registered: September 2013
Senior Member
What's wrong with the answers you were given at https://community.oracle.com/message/12685073#12685073
Re: How to set password login / as sysdba sqlplus on database oracle 11g [message #626019 is a reply to message #625997] Sun, 19 October 2014 06:50 Go to previous messageGo to next message
trybestpro
Messages: 17
Registered: September 2014
Location: HCM
Junior Member
Michel Cadot wrote on Sat, 18 October 2014 09:37

What does "But, it not working for me." mean?



Hi,
It mean: I open sqlnet.ora and change SQLNET.AUTHENTICATION_SERVICES= (NTS) to: SQLNET.AUTHENTICATION_SERVICES= (NONE).
However, then I can still login /as sysdba in sqlplus success.
Thanks.
Re: How to set password login / as sysdba sqlplus on database oracle 11g [message #626021 is a reply to message #626019] Sun, 19 October 2014 08:17 Go to previous messageGo to next message
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Are you sure this is the sqlnet.ora you use?

Re: How to set password login / as sysdba sqlplus on database oracle 11g [message #626094 is a reply to message #626021] Mon, 20 October 2014 12:27 Go to previous messageGo to next message
trybestpro
Messages: 17
Registered: September 2014
Location: HCM
Junior Member
Michel Cadot wrote on Sun, 19 October 2014 15:17

Are you sure this is the sqlnet.ora you use?



Hi,
This is the sql.ora file on Oracle_home/network/admin/simple.
I not found the sql.ora file on Oracle_home/network/admin.

Thanks.
Re: How to set password login / as sysdba sqlplus on database oracle 11g [message #626095 is a reply to message #626094] Mon, 20 October 2014 12:30 Go to previous messageGo to next message
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
I not found the sql.ora file on Oracle_home/network/admin.


You have to create one (sqlnet.ora) from, for instance the one in the sample directory.
sqlnet.ora is NOT mandatory to work with Oracle, this is why there may be none by default.

Re: How to set password login / as sysdba sqlplus on database oracle 11g [message #626158 is a reply to message #626095] Tue, 21 October 2014 14:17 Go to previous messageGo to next message
trybestpro
Messages: 17
Registered: September 2014
Location: HCM
Junior Member
Michel Cadot wrote on Mon, 20 October 2014 19:30

Quote:
I not found the sql.ora file on Oracle_home/network/admin.


You have to create one (sqlnet.ora) from, for instance the one in the sample directory.
sqlnet.ora is NOT mandatory to work with Oracle, this is why there may be none by default.



Hi,
Yes, I do.
I created a sql.ora file copy from Oracle_home/network/admin/simple to Oracle_home/network/admin.
Following, I change SQLNET.AUTHENTICATION_SERVICES= (NTS) to: SQLNET.AUTHENTICATION_SERVICES= (NONE).
However, Then I can still login sqlplus /as sysdba without password.

Thanks,
Best regards.
Re: How to set password login / as sysdba sqlplus on database oracle 11g [message #626161 is a reply to message #626158] Tue, 21 October 2014 14:22 Go to previous message
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Because the file name is sqlnet.ora.

Previous Topic: ORA-00308: cannot open archived log
Next Topic: FRA space cross thresold limit
Goto Forum:
  


Current Time: Tue Jan 16 20:11:19 CST 2018

Total time taken to generate the page: 0.04332 seconds