ORACLE 11g manually configure EM on Linux

Oracle installed by using the OTK tool does not configure EM by default, and the configuration and startup process is documented below!

First create EM, and execute the following command

$ emca-config Dbcontrol Db-repos recreate

I ran the following error for the first time:

 Mar 4:16:06 PM oracle.sysman.emcp.EMReposConfig createrepository config:ora-00604:error occurred at recurs Ive 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 into Tablespace SYSTEM at Oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl (sqlengine.jav a:1650) at Oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeScript (sqlengine.java:1000) at Oracle. Sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript (sqlplusengine.java:339) at oracle.sysman.assistants . Util.sqlEngine.SQLPlusEngine.executeScript (sqlplusengine.java:380) at Oracle.sysman.emcp.EMReposConfig.createRe Pository (emreposconfig.java:510) at Oracle.sysman.emcp.EMReposConfig.invoke (emreposconfig.java:228) at Ora Cle.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.performConfiguration (emconfigassistant.java:1448) at Oracle.sysman.emcp.EMC Onfigassistant.statusmain (emconfigassistant.java:573) at Oracle.sysman.emcp.EMConfigAssistant.main ( emconfigassistant.java:521) 4:16:06 PM oracle.sysman.emcp.EMReposConfig invoke Severe:error creating the rep Ository 

Solutions

Log on to Sqlplus using the SYS user, 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 the new definition of a space file wcdb_system_02.dbf, note that no duplicate

Then the new definition of a space file *wcdb_system_02.dbf*, note that no duplicate

sql> ALTER tablespace SYSTEM ADD datafile '/data01/rdbms/wcdb/datafile/wcdb_system_02.dbf ' SIZE 500M; Tablespace altered.

Then perform EM create success again!

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

Delete an EM repository

$ emca-repos Drop

Metabase control for the configuration database

$ emca-config Dbcontrol db

Delete database control configuration for databases

$ emca-deconfig Dbcontrol db

To reconfigure the port for DB control, the default port is 1158

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

Start the EM console service after setting the ORACLE_SID environment variable

$ emctl Start Dbconsole

Stop the EM console service after setting the ORACLE_SID environment variable

$ emctl Stop Dbconsole

View the status of the EM console service after setting the ORACLE_SID environment variable first

$ EMCTL Status Dbconsole