HOW to prevent login as a "SYSDBA" oracle

1) First step is to find file : "SQLNET.ora" and you can find this here :
[ORACLE_HOME]\NETWORK\ADMIN

2) Find Statement : SQLNET.AUTHENTICATION_SERVICES= (NTS)

3) Remove NTS parameter from above statement

4) Thats It! Now try to login as "/ as sysdba" or "username/password as sysdba"

5) NONE WILL WORK OUT ! Thats what you wann!

Thank yOu

I love Oracle !

Oracle My Links collection

Oracle 10g Very Basic article

1) install oracle 10g
2) start SQL*PLUS from start menu
3) Enter username : SCOTT
Enter password : TIGER
(USERNAME AND PASSWORD ARE NOT CASE SENSITIVE IN ORACLE)

4) If this password dosn't work and ur gettin message : ACCOUNT IS LOCKED then
5) type "/ as sysdba" without doublequotes in USERNAME box and press enter without entering password;
6) You will get SQL prompt as SQL>
7) Now fire up the query : ALTER USER SCOTT ACCOUNT UNLOCK;
8) Now u will get message ACCOUNT UNLOCKED!
9) Now simple fire up command DISC ( DISSCONNECT)
10) CONN SCOTT/TIGER : connectin using uid : scott and password : tiger
11) Now ur IN !
12) FIREUP the Queries you wannt !

Oracle Scott accot LOCKED!

Oracle 10g . . . .
--------------------
1) go to command prompt
2) sql / as sysdba
3) alter user scott accountname ACCOUNT UNLOCK;
4) Exit