Database Connection (study notes) and Database Study Notes

Database Connection (study notes) and Database Study Notes

After Oracle is installed, several additional services will be added to the service.

Since Oracle consumes system resources, we recommend that you change the service type to manual. You can enable the Service manually when necessary.

It can also be processed in the next batch.

Start: @ echo offecho are you sure you want to start the Oracle 11G service? Pausenet start OracleOraDb11g_home1TNSListenernet start OracleServiceORCLnet start OracleDBConsoleorclecho to start the Oracle 11g service. Make sure there is any error. Pause

Stop @ echo offecho are you sure you want to stop the Oracle 11g service? Pausenet stop OracleDBConsoleorclnet stop OracleServiceORCLnet stop OracleOraDb11g_home1TNSListenerecho stop Oracle 11g service complete. Please confirm whether there is any error. Pause

Oracle service Introduction:

OraclejobScheduleSID Task Scheduling Service

OracleServiceSID Database Service

OracleHOME_NAMEiSQL * PLUSISQL * PLUS service

OracleDBConsoleSID Database Console Service

OracleHOME_NAMETNSListener listener server

 

Connect to the Oracle database:

Sqlplus database connection command: to openOracleServiceSID Database Service

In the command line window:

c:/>sqlplus

Enter User Name

Enter Password

Appears

SQL> indicates that the logon is successful.

To open a database connection commandOracleHOME_NAMETNSListener listener server

C:/> sqlplus user name/password @ Database Name

 

Start sqlplus without logging on to the database or connecting to the database

C:/> sqlplus/nologconn username/password @ Database Name

Use PLSQL Developer to connect to a database

Normal:Common users and programmers

SYSOPER:System Operator, rarely used, generally used for backup and log operations

SYSDBA:System Administrators and professional Database Administrators