Connection to the database (learning Note)

After the Oracle installation is complete, several services are added to the service

Because Oracle consumes system resources, it is recommended that you change the service type to manual, and then manually open when needed, and shut down the service when not in use.

You can also use the following batch to complete.

start: @echo off Echo Are you sure you want to start the Oracle 11g service? Pausenet start oracleoradb11g_home1tnslistenernet start oracleserviceorclnet start ORACLEDBCONSOLEORCLEcho  when the Oracle 11g service is started, verify that there are no errors. Pause

stop @echo off Echo Are you sure you want to stop the Oracle 11g service? Pausenet Stop oracledbconsoleorclnet Stop oracleserviceorclnet stop Oracleoradb11g_home1tnslistenerEcho  to stop the Oracle 11g service from completing, verify that there are no errors. Pause

Oracle Service Description:

Oraclejobschedulesid Task Scheduling Service

ORACLESERVICESID Database Services

Oraclehome_nameisql*plus isql*plus Service

ORACLEDBCONSOLESID Database Console Service

Oraclehome_nametnslistener Monitoring Server

To connect to an Oracle database:

Sqlplus command to connect to the database: to open the oracleservicesid database service

In the Command line window:

C:/>sqlplus

Enter user name

Enter password

Appear

Sql> Description Login Successful

Connect the specified database command to open the oraclehome_nametnslistener Listener Server

C:/>sqlplus username/password @ database name

Start sqlplus do not log on to the database and connect to the database

C:/>sqlplus/nologconn  user name /password @ database name

Three ways to connect to a database using Plsql developer

Normal : Normal User, general programmer use

sysoper: system operators, rarely used, usually do backups, log operations

SYSDBA: system administrators, professional database managers use

Connection to the database (learning Note)