Oracle instance creation process (dbca)

Creating an instance in Oracle is one of our most common operations. The following describes the entire process of creating an instance in Oracle. We hope this will help you.

1. Oracle instance creation process:

1. Install the Oracle server.

2. Create an instance in Oracle, use the "Database Configuration assistant" tool under "configuration and migration tools" in the orahome directory.

3. Step 2: Select "create database ".

4. Step 3: select a database template.

5. Step 4: Select "dedicated server mode ".

6. Step 5: Set initialization parameters.

7. By default, click "finish ".

Create a database instance and add a service named: "oracleserver" + SID of the created database instance, which needs to be started.

2. Configure the listener file. If not, "add database to count" in the OEM. open the file and enter system/password. A message indicating no listener is displayed.

Path of the listener file: orahome/ora92/Network/admin/listener. ora

In addition, the listener log file path is orahome/ora92/Network/log/listener. log.

Open the listener. ora file in the editor and modify the settings. For example (The following is a completed file content ):

  

# Listener. ora network configuration file: D: \ oracle \ ora92 \ Network \ admin \ listener. ora
# Generated by Oracle configuration tools.

Listener =
(Description_list =
(Description =
(Address_list =
(Address = (Protocol = IPC) (Key = extproc0 ))
)
(Address_list =
(Address = (Protocol = TCP) (host = 86.16.24.88) (Port = 1521 ))
)
)
)

Sid_list_listener =
(Sid_list =
(Sid_desc =
(Sid_name = plsextproc)
(ORACLE_HOME = D: \ oracle \ ora92)
(Program = EXTPROC)
)
(Sid_desc =
(Global_dbname = Name. domain)
(ORACLE_HOME = D: \ oracle \ ora92)
(Sid_name = Name)
)
(Sid_desc =
(Global_dbname = oemrep)
(ORACLE_HOME = D: \ oracle \ ora92)
(Sid_name = oemrep)
)
(Sid_desc =
(Global_dbname = demo)
(ORACLE_HOME = D: \ oracle \ ora92)
(Sid_name = demo)
)
(Sid_desc =
(Global_dbname = demo_dw)
(ORACLE_HOME = D: \ oracle \ ora92)
(Sid_name = demodw)
)
)

3. Run the listener:

1. In "start" -- "run", enter LSNRCTL to go to listener management.

2. You can use the help command to view the command.

3. LSNRCTL> Start

After running the listener, you can open the created database instance in the OEM.

If you want to use PL/SQL Dev to log on to the database instance, you must configure the tnsnames. ora file in the path orahome \ oracle \ ora92 \ Network \ admin \ tnsnames. ora.

An example of tnsnames. ora is as follows:

Demo =
(Description =
(Address_list =
(Address = (Protocol = TCP) (host = 86.16.24.88) (Port = 1521 ))
)
(CONNECT_DATA =
(Server = dedicated)
(SERVICE_NAME = demo)
)
)

 Tip:

in some cases, listener. ora and tnsnames. ora configuration files may contain garbled characters, so you cannot use OEM or PL/SQL Dev to log on to the database. Therefore, set the garbled characters.

the paths of the two files are:

orahome \ ora92 \ Network \ admin \ listener. ora

orahome \ ora92 \ Network \ admin \ tnsnames. ora