Oracle service start and stop Method

I haven't used oracle for a long time. I almost forgot to install an oracle9i today. I used svrmgrl to start the service. Then I found out after I checked it online, svrmrl is the startup method of oracle8. It will be different after oracle9i. Alas, I forgot it. I found a description on the Internet: Oracle9I, take

I haven't used oracle for a long time. I almost forgot to install an oracle9i today. I used svrmgrl to start the service. Then I found out after I checked it online, svrmrl is the startup method of oracle8. It will be different after oracle9i. Alas, I forgot it. I found a description on the Internet: Oracle9I, take

I haven't used oracle for a long time. I almost forgot to install an oracle9i today. I used svrmgrl to start the service. Then I found out after I checked it online, svrmrl is the startup method of oracle8. It will be different after oracle9i. Alas, I have forgotten it. I also found a description on the Internet:

At the beginning of Oracle9I, the Server Manager (svrmgl) and internal users are canceled. SQL * plus is used to start and stop the database! Oracle10g can start and stop the database service through a browser! Here we will mainly talk about starting and stopping services under 9I. the following commands can also be used to start or stop services under 8i, and must have sysdba permissions. You can use two methods to connect:

First, connect with the sys user

C: \> sqlplus sys/change_on_install as sysdba;
Enter the SQL * plus environment. (Note that you need to set the password for sys and system when installing ORACLE9I, and you cannot use the default password of the two users before ORACLE9I, this is mainly to ensure the security of the database system. For good memory, I restored the default password immediately after installation)

Second:

C: \> sqlplus/nolog

SQL * Plus: Release 9.2.0.1.0-Production on Monday April 26 09:42:00 2004

Copyright (c) 1982,200 2 [/img] [/img], Oracle Corporation. All rights reserved.

SQL> connect/as sysdba
Connected.
SQL>
After entering, you can perform the following operations!

Close the database first

Shutdown has four parameters. The meanings of the four parameters are as follows:
Normal: wait until all users are disconnected.
Immediate waits for the user to complete the current statement
Transactional waits for the user to complete the current transaction
Abort closes the database without waiting.
Normal requires that you close the database only after all connected users are disconnected. Sometimes it seems that the command is not running! New connections are not allowed after this command is executed.
Immediate disconnects the user after the user executes the statement being executed, and does not allow new users to connect.
Transactional disconnects after the user executes the current transaction and does not allow new users to connect to the database.
Abort forcibly disconnects and closes the database.
The first three methods do not return lost user data. The fourth option is not recommended if it is no longer available!

Database startup

Database startup uses the startup command. There are three cases:

First, start the database instance and open the database without parameters, so that you can use the database. In most cases, this method is used!

Type 2: With the nomount parameter, only the database instance is started, but the database is not opened. It is used when you want to create a new database, or when you need it!

Type 3: Use the mount parameter when renaming a database. In this case, the database is opened and can be used!

When installing the database, the user password of system and sys cannot be the default one, but can be changed after installation. The following command to change the User Password

Log on to oracle using sys,

C: \ sqlplus sys/password as sysdba

Sqlplus> alter user sys identified by change_on_install;

In this way, you can change the password to the default one.