[oracle] oracle 11g 的安装后怎么使用

For fresh man, if you didn't know oracle before, maybe confused after oracle installed, ok, here is one way as your reference

 

1. Open Start > Oracle - OraDb11g_home1 > Configuration and Migration Tools > Database Configuration Assistant, then follow the guide to create a global database. Here I create a database named TestSample

(at the end of db creation you can unlock system account, like: SCOTT, and set a password for it. Then u can use it to login Test Sample)

2. If you forgot to unlock account to login in this db, here is what u can do:

2.1 Open Start > Oracle - OraDb11g_home1 > Application Development > SQL Plus

2.2 Enter following command to login global db:

sql plus / as sysdba

2.3 Then chose one account that you want to login in db (take SCOTT as an example here)

2.4 Enter following command to unlock SCOTT account

alter user SCOTT account unlock;

2.5 Enter following command to set password for SCOTT

alter user SCOTT identified by 123456;

 

Now you can connect into oracle "TestSample" db with SQL Developer tool and SCOTT account (password is 123456)