Listener Configuration(server Side)
#su – oracle
$netca
Listener Configuration –Next
Add –Next
Listener name= LISTENER
Selected protocols =TCP – Next
Use standard port = 1521
Would u like to configure anoter instance =No –Next - Finish
$cd $ORACLE_HOME/network.admin
$vi listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC=
(SID_NAME=prd
(ORACLE_HOME=‘/u01/app/oracle/product/11.2.0/db_1/)
)
)
)
Exit code 0 (check for this)
$lsnrctl stop
$lsnrctl start
TNS Configuration: (client side)
$netca
Local Net Service Name Configuration – Next
Add – Next
Service Name =prd (SID Name)
TCP –Next
Host Name =ecs01 or 192.168.1.1
Service Name=prdservice
No Donot test –next –Next – Finish
$tnsping prdservice
