Oracle's environment configuration-Create a separate DB instance

Create a separate DB instance

Database 1 Database 2
ORCL Law------RDBMS (Service)
| |
-----------------------
Installing the Database software (DBMS)


Create a separate Rdbms--law

[Email protected] ~]# Xhost +
Access control disabled, clients can connect from any host-automatically starts the Xmanager passive
[Email protected] ~]# su-oracle
[Email protected] ~]$ export display= "10.1.1.250:0.0"
[Email protected] ~]$ export Lang=en_us
[Email protected] ~]$ DBCA--Note: Choose an OEM that has a character set of UTF8 do not create law

[Email protected] ~]$ Lsnrctl

Lsnrctl for linux:version 10.2.0.1.0-production on 05-jun-2014 14:31:51

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Welcome to Lsnrctl, type ' help ' for information.

lsnrctl> status
Connecting to (Description= (address= (PROTOCOL=IPC) (Key=extproc1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version Tnslsnr for Linux:version 10.2.0.1.0-production
Start Date 05-jun-2014 11:30:50
Uptime 0 Days 3 hr. 1 min. 2 sec
Trace level off
Security on:local OS Authentication
SNMP OFF
Listener Parameter File/u01/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File/u01/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary ...
(Description= (address= (PROTOCOL=IPC) (Key=extproc1)))
(Description= (address= (protocol=tcp) (Host=oracle3) (port=1521)))
Services Summary ...
Service "Law" has 1 instance (s). --The first instance of listening
Instance "Law", status ready, have 1 handler (s) for the This service ...
Service "Lawxdb" has 1 instance (s).
Instance "Law", status ready, have 1 handler (s) for the This service ...
Service "LAW_XPT" has 1 instance (s).
Instance "Law", status ready, have 1 handler (s) for the This service ...
Service "ORCL" has 1 instance (s). --second instance of listening ORCL
Instance "ORCL", status ready, have 1 handler (s) for the This service ...
Service "Orclxdb" has 1 instance (s).
Instance "ORCL", status ready, have 1 handler (s) for the This service ...
Service "ORCL_XPT" has 1 instance (s).
Instance "ORCL", status ready, have 1 handler (s) for the This service ...
Service "Plsextproc" has 1 instance (s).
Instance "Plsextproc", status UNKNOWN, have 1 handler (s) for the This service ...
The command completed successfully


ORCL law (created does not have to exist in memory unless it is started)
| |
---------------
|
listener:1521
|
---------Linux----port:1521---------
|
External connections
----------------------------------------------------------------------------------------
OEM for manual configuration of law

0. Temporarily modify environment variables

[Email protected] ~]$ export Oracle_sid=law

1, first to start law instance

2. Run Configuration Tool Configuration
[Email protected] ~]$ emca-config Dbcontrol Db-repos recreate

EMCA started on 2014-6-5 15:40:12
EM Configuration Assistant 10.2.0.1.0 official version
Copyright (c) 2003, 2005, Oracle. All rights reserved.

Enter the following information:
Database Sid:law
Listener Port number: 1521
SYS User's password:
DBSNMP User's password:
Sysman User's password:
e-mail address of the notification (optional):
Outgoing (SMTP) server for notifications (optional):
-----------------------------------------------------------------

The following settings have been specified

Database Oracle_home .../u01/oracle/product/10.2.0/db_1, ....----

The database hostname ..... ...... oracle3.
Listener port number ...... ....... 1521
Database SID ..... ....... Law
The e-mail address of the notification .....
Notification of the outgoing (SMTP) server ..... .....

-----------------------------------------------------------------
Do you want to continue? [Yes (Y)/no (N)]: Y
2014-6-5 15:40:31 Oracle.sysman.emcp.EMConfig Perform
Info: This operation is being logged to/u01/oracle/product/10.2.0/db_1/cfgtoollogs/emca/law/emca_2014-06-05_03-40-12-pm. Log.
2014-6-5 15:40:32 Oracle.sysman.emcp.EMReposConfig droprepository
Info: Removing the EM Data archive (this may take some time) ...
2014-6-5 15:40:32 Oracle.sysman.emcp.EMReposConfig Invoke
Info: The repository was deleted successfully
2014-6-5 15:40:32 Oracle.sysman.emcp.EMReposConfig createrepository
Info: Creating an EM Data archive (this operation may take a while) ...
2014-6-5 15:41:59 Oracle.sysman.emcp.EMReposConfig Invoke
Info: The repository was created successfully
2014-6-5 15:42:01 Oracle.sysman.emcp.util.DBControlUtil startoms
Info: Starting Database Control (This operation may take some time) ...
2014-6-5 15:43:43 Oracle.sysman.emcp.EMDBPostConfig performconfiguration
Info: The Database Control was successfully started
2014-6-5 15:43:43 Oracle.sysman.emcp.EMDBPostConfig performconfiguration
Info: >>>>>>>>>>> Control URL for Http://oracle3:5500/em <<<<< <<<<<<
Configuration of Enterprise Manager completed successfully
EMCA ended on 2014-6-5 15:43:43

Http://10.1.3.3:5500/em/console/aboutApplication
--------------------------------------------------------------------------------------------------------------- -----
Delete a DB instance

[Email protected] ~]$ export Oracle_sid=law
[Email protected] ~]$ DBCA--delete instance law

Oracle's environment configuration-Create a separate DB instance