Monday, May 17, 2010

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 !

No comments:

Post a Comment