ORACLE Monitoring Configuration

After installation, start with the following

# Listener.ora Network Configuration file:d:\oracle\app\administrator\product\11.2.0\dbhome_1\network\admin\listener.ora# Generated by Oracle configuration tools. Sid_list_listener=(Sid_list=(Sid_desc=(Sid_name=Clrextproc) (Oracle_home= D:\oracle\app\Administrator\product\11.2.0\dbhome_1) ( Program=Extproc) (Envs= "Extproc_dlls=only:d:\oracle\app\administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")) LISTENER=(Description_list=(DESCRIPTION=(ADDRESS= (PROTOCOL = IPC) (KEY =EXTPROC1521)) (ADDRESS= (PROTOCOL = TCP) (HOST = win-dg2are7viau) (PORT = 1521))) Adr_base_listener= D:\oracle\app\Administrator

Modify Add

# Listener.ora Network Configuration file:d:\oracle\app\administrator\product\11.2.0\dbhome_1\network\admin\listener.ora# Generated by Oracle configuration tools. Sid_list_listener=(Sid_list=(Sid_desc=(Sid_name=Clrextproc) (Oracle_home= D:\oracle\app\Administrator\product\11.2.0\dbhome_1) ( Program=Extproc) (Envs= "Extproc_dlls=only:d:\oracle\app\administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")) (Sid_desc = (GLOBAL_DBNAME=ORCL) (Oracle_home = D:\oracle\app\Administrator\product\11.2.0\dbhome_1) (sid_name=
     ORCL)) ) LISTENER=(Description_list=(DESCRIPTION=(ADDRESS= (PROTOCOL = TCP) (HOST =123.123.123.123) (PORT = 1521))) Adr_base_listener= D:\oracle\app\Administrator

Local

BEMIS =            = 123.123.123.123) (PORT = 1521)) = =      Dedicated)      (SID=orcl   )))

ORACLE Monitoring Configuration