OraFAQ Forum: Server Administration » How to set password login / as sysdba sqlplus on database oracle 11g

Home » RDBMS Server » Server Administration » How to set password login / as sysdba sqlplus on database oracle 11g (Oracle 11g, Linux 5.10)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to set password login / as sysdba sqlplus on database oracle 11g [message #625996]

Sat, 18 October 2014 01:10

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.

Report message to a moderator

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

Michel Cadot
Messages: 68773
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

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

Report message to a moderator

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

EdStevens
Messages: 1377
Registered: September 2013

Senior Member

What's wrong with the answers you were given at https://community.oracle.com/message/12685073#12685073

Report message to a moderator

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

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.

Report message to a moderator

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

Michel Cadot
Messages: 68773
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

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

Report message to a moderator

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

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.

Report message to a moderator

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

Michel Cadot
Messages: 68773
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

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

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.

Report message to a moderator

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

Michel Cadot
Messages: 68773
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Because the file name is sqlnet.ora.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 24 12:29:15 CST 2025