Oracle Monitoring Configuration

D:\dev\product\11.2.0\dbhome_1\NETWORK\ADMIN

Connect to other machines:

PL Preferences Configuration:

Oradb11g_home1

D:\dev\product\11.2.0\dbhome_1\bin\oci.dll

Pl:192.168.0.153/oanet

Listener.ora no changes required

# Listener.ora Network Configuration File:d:\dev\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

Listenersinosoft =
(Description_list =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.110) (PORT = 1522))
)
)

Adr_base_listenersinosoft = D:\dev

Sid_list_listener =
(Sid_list =
(Sid_desc =
(Sid_name = Clrextproc)
(Oracle_home = D:\dev\product\11.2.0\dbhome_1)
(program = Extproc)
(Envs = "Extproc_dlls=only:d:\dev\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)

LISTENER =
(Description_list =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521))
)
)

Adr_base_listener = D:\dev

Tnsnames.ora can be changed when connecting

# Tnsnames.ora Network Configuration File:d:\dev\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

Oanet =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.0.146) (PORT = 1521))
(Connect_data =
(SERVER = dedicated)
(service_name = oanet)
)
)

SIN =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.110) (PORT = 1522))
(Connect_data =
(SERVER = dedicated)
(service_name = sin)
)
)

Oraclr_connection_data =
(DESCRIPTION =
(Address_list =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521))
)
(Connect_data =
(SID = Clrextproc)
(PRESENTATION = RO)
)
)

LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521))

Listener_sin =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.110) (PORT = 1522)) New Listen auto Append

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521))
(Connect_data =
(SERVER = dedicated)
(service_name = ORCL) You can manually add a remote connection
)
)

Configuration monitoring: NET Configuration Assistant new, one listener (can specify port)

Database Configuration Assistant to establish a DB instance (you can specify listening)

Oracle Monitoring Configuration