Summary of Oracle operation practices

1. to speed up sub-startup, after oracle is installed, set oracleservice [Sid] to manual startup (SID is the name of the database instance) under the management tool-service ), in this way, the Oracle service will not be automatically started after the next sub-startup. When you need to use the Oracle service, you can start oracleservice [Sid] under the management tool-service, you can also use the net start oracleserviceorcl command to start it in DOS.
2. In order to release the memory occupied by the Oracle database during running without shutting down the Oracle service, you can only stop the database instance (use the shutdown immediate command in sqlplus ). In this case, you can use the Sys user to log on to sqlplus without shutting down the Oracle service. (First, run the sqlplus/nolog command in DOS, and then connect with Conn/As sysdba ).

Oracledbconsoleorcl
Oracleoradb10g_home1isql * Plus
Oracleoradb10g_home1tnslistener
Oracleserviceorcl
The above is set to manual start. You need to start it in the management tool-service when using Oracle.

Database Password: orcl
This password is used for sys, system, sysman, and Dbsnmp accounts.

Whether the user PW locks the host string
Sysdba orcl sysdba/sysoper
Sys orcl no sysdba/sysoper
System orcl no sysdba/sysoper
Dmsys is
Scott no normal

Start and close the service:
Method 1: Start Control Panel-Administrative Tools-service, find several startup items whose names start with "oracle" in the service, and change the "Startup Type" in its properties to "Manual ". Restart the machine. The Oracle startup items that occupy a lot of resources will not be automatically started. When you need to use ORACLE resources, you can start it manually.
Method 2: in DOS,
Start Service: Net start oracleserviceorcl
Disable service: net stop oracleserviceorcl

Method 2:
1. Start and close the listener
Start listening: LSNRCTL start (run under MS-DOS)
Disable listening: LSNRCTL stop (run under MS-DOS)
2. Start and Stop the database
Start the database:
Enter sqlplus '/As sysdba' on the terminal to enter sqlplus, and enter startup on sqlplus.
Stop database:
Input shutdown or shutdown immediate in sqlplus
3. Start and Stop the dbconsole Service
Start dbconsole service: emctl start dbconsole (run under MS-DOS)
Stop dbconsole service: emctl stop dbconsole (run under MS-DOS)
4. Start and Stop iSQL * Plus
Isqlplusctl START | stop (run in MS-DOS)
5. List Oracle Processes
PS-fu Oracle

There are three ways to start the Oracle service:
1 slave control panel
2 Use MS-DOS commands
3. Use Oracle administration assistant for WindowsNT

Start Oracle service through control panel
1) choose Start> Control Panel> Management Tools> Service
2) locate the Oracle service you want to start and click Start

Start Oracle services with MS-DOS commands
1) Open the DOS window
2) in the window, enter: Net start oracleservicename

Start Oracle services through Oracle administration assistant for WindowsNT

1) Select Start> program> Oracle-home_name> Configuration and migration
Tools> Oracle administration assistant for Windows NT.
2) Find and right-click Oracle SID
3) Select Start

There are also three ways to disable the Oracle service:
1 slave control panel
2 Use MS-DOS commands
3. Use Oracle administration assistant for WindowsNT

Start Oracle service through control panel
1) choose Start> Control Panel> Management Tools> Service
2) locate the Oracle service you want to start and click Stop

Start Oracle services with MS-DOS commands
1) Open the DOS window
2) in the window, enter: net stop oracleservicename

Start Oracle services through Oracle administration assistant for WindowsNT

1) Select Start> program> Oracle-home_name> Configuration and migration
Tools> Oracle administration assistant for Windows NT.
2) Find and right-click Oracle SID
3) Select Stop

Log Files
F:/Oracle/product/10.2.0/db_1/export toollogs/dbca/orcl

Enterprise Manager Database Control URL-(orcl ):

Http: // PC-20090721TZKJ: 1158/em

The database configuration file has been installed in F:/Oracle/product/10.2.0, and other selected installation components have been installed in F:/Oracle/product/10.2.0/db_1.

The iSQL * Plus URL is:

Http:/// PC-20090721TZKJ: 5560/isqlplus

The iSQL * Plus dba url is:

Http:/// PC-20090721TZKJ: 5560/isqlplus/DBA