Mohamed Azar Shaj

Oracle DBA, azarmohds@gmail.com, Riyadh Kingdom Of Saudi Arabia

Oracle Certification ** Oracle-Base ** Export and Import ** Charater set migration

About Me

My photo
Database Administrator and like to read about hackers and them activities...and completed Oracle 10g Certified associate. Active member of Oracle Forum

Connect sysdba

7:09 PM / Posted by Azar Mohamed Shaj /

There is two method to connect sysdba user :-

with password

without password

sql> conn / as sysdba ------ without password

* Oracle database user must have sysdba privileges.
* Os user must add in dba group.
* In sqlnet.ora file must content "NTS" in below line

sqlnet.authentication_services = (NTS)
****************************************************
with password

sql>conn sys/pwd as sysdba ------- with password

prevent to connect without password.
* remove os user from dba group.
* edit sqlnet.ora file and change "none" to "nts" in below line.
sqlnet.authentication_services =(none)
Default value is nts when sqlnet.ora file created.
***************************** DBA ******************

0 comments:

Post a Comment