EM(Enterprise Manager) management, iSQP*PLus management

 

1. EM(Enterprise Manager) management
1)EM 시작과 종료

os] export ORACLE_SID=인스턴스이름
os] emctl start dbconsole
os] emctl status dbconsole
os] emctl stop dbconsole

 

 

Note: You may need to navigate to your $ORACLE_HOME/bin directory

         if this directory is not in your operating system(OS) path.
         Database Control uses a server-side agent process.

         This agent process automatically starts and stops
         when the dbconsole process is started or stopped.

 

2)EM 접속하기
http://ip_address:1158/em
or
http://host_name:1158/em

 

3)로그인 후 사용

 

4) EM 재설정

OS] emca -config dbcontrol db -repos drop

OS] sqlplus / as sysdba

SQL> drop user sysman cascade;
SQL> drop role MGMT_USER;
SQL> drop user MGMT_VIEW cascade;
SQL> drop public synonym MGMT_TARGET_BLACKOUTS;
SQL> drop public synonym SETEMVIEWUSERCONTEXT;

OS] emca -config dbcontrol db -repos create

2. iSQP*PLus management

1)iSQP*PLus 시작과 종료

os]isqlplusctl start

2)EM 접속하기
http://ip_address:5560/isqlplus
or
http://host_name:5560/isqlplus

3)로그인 후 사용

Note: The port number that is used by iSQL*Plus is usually 5560

        unless Oracle Universal Installer(OUI) detects that
        something is already using that port.
        Check $ORACLE_HOME/install/portlist.ini to find the port used by iSQL*Plus

 

os] more $ORACLE_HOME/install/portlist.ini