Oracle 10g basic configuration (enter the database under DOS and connect to the database through PLSQL)

Transferred from:Http://blog.csdn.net/sting0218/article/details/5915308 thanks to the author

1: You must first open the listener. You can use either of the two methods. One is to manually open the listener in the control panel-> Administrative Tools-> service; the second is to run lsnrctr start in DOS to enable it.

2: log on to the database: to log on to the database, you must first log on to the database using an account, which is usually a user. When no database instance is created, there are several default users, such as sys, scott and so on. We can use them to log on to the database. Taking sys users as an example, input sqlplu/nolog in DOS (note that there is no space between '/' and 'nolog ), enter conn sys as sysdba (user permission, sys can only log in as sysdba and sysoper) after 'SQL> ). Then, you will be asked to enter the password of this user, that is, the password set when oracle is installed. after entering the password, you will successfully log on to the database. At this time, you can use show
User Statement to check whether the System user is logged on.

It is easier to log on to the database using PLSQL. Opening PLSQL will allow you to enter the login name and password. This is the same as that in DOS. The idea of orcl or self-built database instance is a database rather than a user, to separate their names from user names, do not confuse the concepts of users and instances.

3: connect to the database: After logging on to PLSQL, you must first create a data source, then find the connection option in the database, and set the connection between PLSQL and the database. Note: Make sure that the services of the database to be connected (such as listeners and services of the corresponding database) are opened (also set in the control panel ).

1: You must first open the listener. You can use either of the two methods. One is to manually open the listener in the control panel-> Administrative Tools-> service; the second is to run lsnrctr start in DOS to enable it.

2: log on to the database: to log on to the database, you must first log on to the database using an account, which is usually a user. When no database instance is created, there are several default users, such as sys, scott and so on. We can use them to log on to the database. Taking sys users as an example, input sqlplu/nolog in DOS (note that there is no space between '/' and 'nolog ), enter conn sys as sysdba (user permission, sys can only log in as sysdba and sysoper) after 'SQL> ). Then, you will be asked to enter the password of this user, that is, the password set when oracle is installed. after entering the password, you will successfully log on to the database. At this time, you can use show
User Statement to check whether the System user is logged on.

It is easier to log on to the database using PLSQL. Opening PLSQL will allow you to enter the login name and password. This is the same as that in DOS. The idea of orcl or self-built database instance is a database rather than a user, to separate their names from user names, do not confuse the concepts of users and instances.

3: connect to the database: After logging on to PLSQL, you must first create a data source, then find the connection option in the database, and set the connection between PLSQL and the database. Note: Make sure that the services of the database to be connected (such as listeners and services of the corresponding database) are opened (also set in the control panel ).