Oracle reconstruction Enterprise Manager
1. First create a listener
[Root @ primary ~] # Xhost +
Access control disabled, clients can connect from any host
[Root @ primary ~] # Su-Oracle
[Oracle @ primary ~] $ Netca
Annotation: The LISTENER name LISTENER created here, database_ID = orcl
To view the directory of the Enterprise Manager's Webpage Browsing method, refer:
[Root @ primary ~] # Su-oracle
[Oracle @ primary ~] $ Cd $ ORACLE_HOME
[Oracle @ primary db_1] $ cd install
[Oracle @ primary install] $ more readme.txt
The following J2EE Applications have been deployed and are accessible at the URL
S listed below.
ISQL * Plus URL:
Http: // primary: 5560/isqlplus
ISQL * Plus dba url:
Http: // primary: 5560/isqlplus/dba
Http: // primary: 1158/em
Http: // primary: 1158/em
2. Open the database
[Oracle @ primary install] $ sqlplus/as sysdba
SQL * Plus: Release 10.2.0.1.0-Production on Tue Jun 17 08:33:17 2014
Copyright (c) 1982,200 5, Oracle. All rights reserved.
Connected:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Production
With the Partitioning, OLAP and Data Mining options
SQL> select instance_name, status from V $ instance;
INSTANCE_NAME STATUS
----------------------------
Orcl OPEN
3. Check the listening status. The status must be running.
[Oracle @ primary install] $ lsnrctl status
LSNRCTL for Linux: Version 10.2.0.1.0-Production on 17-JUN-2014 08:35:40
Copyright (c) 1991,200 5, Oracle. All rights reserved.
Connecting to (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = primary) (PORT = 1521 )))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0-Production
Start Date 17-JUN-2014 08:29:31
Uptime 0 days 0 hr. 6 min. 8 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File/u01/oracle/db_1/network/admin/listener. ora
Listener Log File/u01/oracle/db_1/network/log/listener. log
Listening Endpoints Summary...
(DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = primary) (PORT = 1521 )))
(DESCRIPTION = (ADDRESS = (PROTOCOL = ipc) (KEY = EXTPROC0 )))
Services Summary...
Service "PLSExtProc" has 1 instance (s ).
Instance "PLSExtProc", status UNKNOWN, has 1 handler (s) for this service...
Service "orcl" has 1 instance (s ).
Instance "orcl", status READY, has 1 handler (s) for this service...
Service "orclXDB" has 1 instance (s ).
Instance "orcl", status READY, has 1 handler (s) for this service...
Service "orcl_XPT" has 1 instance (s ).
Instance "orcl", status READY, has 1 handler (s) for this service...
The command completed successfully
View the listening port number as follows:
[Oracle @ primary install] $ cd $ ORACLE_HOME/network/admin/
[Oracle @ primary admin] $ ls
Listener. ora samples shrept. lst tnsnames. ora
[Oracle @ primary admin] $ more listener. ora
# Listener. ora Network Configuration File:/u01/oracle/db_1/network/admin/listen
Er. ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME =/u01/oracle/db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = primary) (PORT = 1521 ))
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC0 ))
)
)
4. Check that the IP address and host name in/etc/hosts must be consistent with the actual one.
[Root @ primary ~] # Hostname
Primary
[Root @ primary ~] # Ifconfig eth0
Eth0 Link encap: Ethernet HWaddr 00: 0C: 29: DA: 7E: F0
Inet addr: 192.168.10.10 Bcast: 192.168.10.255 Mask: 255.255.255.0
Inet6 addr: fe80: 20c: 29ff: feda: 7ef0/64 Scope: Link
Up broadcast running multicast mtu: 1500 Metric: 1
RX packets: 6392 errors: 0 dropped: 0 overruns: 0 frame: 0
TX packets: 10621 errors: 0 dropped: 0 overruns: 0 carrier: 0
Collisions: 0 FIG: 1000
RX bytes: 458467 (447.7 KiB) TX bytes: 1665793 (1.5 MiB)
Interrupt: 59 Base address: 0x2024
[Root @ primary ~] # Cat/etc/hosts
# Do not remove the following line, or various programs
# That require network functionality will fail.
127.0.0.1 localhost
192.168.10.10 primary
#: 1 localhost6.localdomain6 localhost6
5. disable Enterprise Manager emctl stop dbconsole
[Oracle @ primary ~] $ Emctl stop dbconsole
TZ set to PRC
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996,200 5 Oracle Corporation. All rights reserved.
Http: // primary: 1158/em/console/aboutApplication
Stopping Oracle Enterprise Manager 10g Database Control...
... Stopped.
6. Delete the em database emca-repos drop
[Oracle @ primary ~] $ Emca-repos drop
Started emca at Jun 17,201 4 8:44:08 AM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003,200 5, Oracle. All rights reserved.
Enter the following information:
Database SID: orcl
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:
Do you wish to continue? [Yes (Y)/no (N)]: y
Jun 17,201 4 8:44:19 AM oracle. sysman. emcp. EMConfig perform
INFO: This operation is being logged at/u01/oracle/db_1/runtime toollogs/emca/orcl/emca_2014-06-17_08-44-08-AM.log.
Jun 17,201 4 8:44:20 AM oracle. sysman. emcp. EMReposConfig dropRepository
INFO: Dropping the EM repository (this may take a while )...
Jun 17,201 4 8:46:27 AM oracle. sysman. emcp. EMReposConfig invoke
INFO: Repository successfully dropped
Enterprise Manager configuration completed successfully
Finished emca at Jun 17,201 4 8:46:28 AM
7. create an em database emca-repos create
[Oracle @ primary ~] $ Emca-repos create
Started emca at Jun 17,201 4 8:47:23 AM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003,200 5, Oracle. All rights reserved.
Enter the following information:
Database SID: orcl
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:
Do you wish to continue? [Yes (Y)/no (N)]: y
Jun 17,201 4 8:47:34 AM oracle. sysman. emcp. EMConfig perform
INFO: This operation is being logged at/u01/oracle/db_1/runtime toollogs/emca/orcl/emca_2014-06-17_08-47-23-AM.log.
Jun 17,201 4 8:47:34 AM oracle. sysman. emcp. EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while )...
Jun 17,201 4 8:50:33 AM oracle. sysman. emcp. EMReposConfig invoke
INFO: Repository successfully created
Enterprise Manager configuration completed successfully
Finished emca at Jun 17,201 4 8:50:33 AM
Install Oracle 11gR2 (x64) in CentOS 6.4)
Steps for installing Oracle 11gR2 in vmwarevm
Install Oracle 11g XE R2 In Debian
Oracle 11g from entry to proficient in PDF + CD source code
Installing Oracle 11g R2 using RHEL6 ASM
8. Configure em: emca-config dbcontrol db
First, add a NIC to the physical machine:
For more details, please continue to read the highlights on the next page:
