Manual EM configuration in Linux for Oracle 11g

Manual EM configuration in Linux for Oracle 11g

This article permanently updates the link address:
Oracle installed with the OTK tool does not have EM configured by default. The configuration and startup process are recorded below!

First create EM and execute the following command

$ Emca-config dbcontrol db-repos recreate

The following error is reported during my first running:

Mar 31,201 2 4:16:06 PM oracle. sysman. emcp. EMReposConfig createRepository
CONFIG: ORA-00604: error occurred at recursive SQL level 1
ORA-01653: unable to extend table SYS. SOURCE $ by 128 in tablespace SYSTEM
Oracle. sysman. assistants. util. sqlEngine. SQLFatalErrorException: ORA-00604: error occurred at recursive SQL level 1
ORA-01653: unable to extend table SYS. SOURCE $ by 128 in tablespace SYSTEM
At oracle.sysman.assistants.util.sqlEngine.SQLEngine.exe cuteImpl (SQLEngine. java: 1650)
At oracle.sysman.assistants.util.sqlEngine.SQLEngine.exe cuteScript (SQLEngine. java: 1000)
At oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.exe cuteScript (SQLPlusEngine. java: 339)
At oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.exe cuteScript (SQLPlusEngine. java: 380)
At oracle. sysman. emcp. EMReposConfig. createRepository (EMReposConfig. java: 510)
At oracle. sysman. emcp. EMReposConfig. invoke (EMReposConfig. java: 228)
At oracle. sysman. emcp. EMReposConfig. invoke (EMReposConfig. java: 157)
At oracle. sysman. emcp. EMConfig. perform (EMConfig. java: 253)
At oracle. sysman. emcp. EMConfigAssistant. invokeEMCA (EMConfigAssistant. java: 589)
At oracle. sysman. emcp. EMConfigAssistant. Configure mconfiguration (EMConfigAssistant. java: 1448)
At oracle. sysman. emcp. EMConfigAssistant. statusMain (EMConfigAssistant. java: 573)
At oracle. sysman. emcp. EMConfigAssistant. main (EMConfigAssistant. java: 521)
Mar 31,201 2 4:16:06 oracle. sysman. emcp. EMReposConfig invoke
SEVERE: Error creating the repository

Solution

Use the SYS user to log on to sqlplus and then execute the following statement:

SQL> SELECT * FROM DBA_DATA_FILES where TABLESPACE_NAME = 'system ';
FILE_NAME FILE_ID TABLESPACE_NAME
Bytes blocks status RELATIVE_FNO aut maxbytes maxblocks INCREMENT_BY USER_BYTES USER_BLOCKS
ONLINE _/data01/rdbms/wcdb/datafile/wcdb_system_01.dbf 1 SYSTEM 536870912 65536 AVAILABLE
1 NO 0 0 0 535822336 65408
SYSTEM

Then define a new space file wcdb_system_02.dbf. Do not name it again.

Then define a new space file * wcdb_system_02.dbf *. Do not name it again.

SQL> ALTER TABLESPACE SYSTEM ADD DATAFILE '/data01/rdbms/wcdb/datafile/wcdb_system_02.dbf' SIZE 500 M; Tablespace altered.

Then execute EM again to create successfully!

EM access address: https: // localhost: 1158/em

Delete An EM Database

$ Emca-repos drop

Configure Database Control for the Database

$ Emca-config dbcontrol db

Delete Database Control Configuration of a Database

$ Emca-deconfig dbcontrol db

Reconfigure the Database control port. The default port is 1158.

$ Emca-reconfig ports-dbcontrol_http_port 1160 $ emca-reconfig ports-agent_port 3940

Set the ORACLE_SID environment variable and start the EM console service.

$ Emctl start dbconsole

Set the ORACLE_SID environment variable and stop the EM console service.

$ Emctl stop dbconsole

Set the ORACLE_SID environment variable to view the EM console service status.

$ Emctl status dbconsole

 

Install Oracle 11gR2 (x64) in CentOS 6.4)

Steps for installing Oracle 11gR2 in vmwarevm

Install Oracle 11g XE R2 In Debian