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\ADMIN2) Find Statement : SQLNET.AUTHENTICATION_SERVICES= (NTS)3) Remove NTS parameter from above statement4) Thats It! Now try to login as "/ as sysdba" or "username/password as sysdba"5) NONE WILL WORK OUT ! Thats what you wann!Thank yOuI 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.htmhttp://www.dbapool.com/articles/090706.htmlhttp://www.techonthenet.com/oracle/cursors/declare.phphttp://www.plsql-tutorial.com/http://www.exforsys.com/tutorials/oracle-9i/oracle-cursors.htmlhttp://asktom.oracle.com/pls/asktom/f?p=100:11:4412488757401673::::P11_QUESTION_ID:7986513233505track errorhttp://ora-00920.ora-code.com/http://download.oracle.com/docs/cd/B10501_01/appdev.920/a96624/07_errs.htmhttp://www.orafaq.com/wiki/Exceptionoracle...

Oracle 10g Very Basic article

1) install oracle 10g2) start SQL*PLUS from start menu3) 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 then5) 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...

Oracle Scott accot LOCKED!

Oracle 10g . . . .--------------------1) go to command prompt2) sql / as sysdba3) alter user scott accountname ACCOUNT UNLOCK;4) E...