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

This are very useful links i found while studying oracle it wil definatly help you in learning oracle basics :

• http://www.fast-track.cc/t_easyoracle_pl_sql_cursor_for_loop.htm
• http://www.dbapool.com/articles/090706.html
• http://www.techonthenet.com/oracle/cursors/declare.php
• http://www.plsql-tutorial.com/
• http://www.exforsys.com/tutorials/oracle-9i/oracle-cursors.html
• http://asktom.oracle.com/pls/asktom/f?
• p=100:11:4412488757401673::::P11_QUESTION_ID:7986513233505
• track error
  http://ora-00920.ora-code.com/
  http://download.oracle.com/docs/cd/B10501_01/appdev.920/a96624/07_errs.htm
  http://www.orafaq.com/wiki/Exception
• oracle exception :
  http://psoug.org/reference/exception_handling.html
  
• security and hacking oracle
  http://www.red-database-security.com/software/checkpwd.html tools
  http://www.exforsys.com/tutorials/oracle-9i/oracle-pl-sql-collections.html - nested tables
• http://thinkoracle.blogspot.com/2006/07/finding-information.html
• http://www.dbspecialists.com/files/presentations/load_faster.html  (ora load fast)

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