Hi Experts,
All these years I have been using TCP protocol to establish database connection. What is the possibility of using IPC protocol?
I tried from my side by not able to establish IPC connectivity to the database. But it seems, Oracle is not liking it. Appreciate if you could validate my approach. Below are the details:
OS: RHEL 5.5
DB: Oracle 10gR2 (yes, we will upgrade :) )
Listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = testdb)
(ORACLE_HOME = C:\u01\app\oracle\product\10.2.0\db_1)
(GLOBAL_DBNAME = testdb)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(HOST = testhost)(PORT = 1521))
)
)
TNSNAMES.ora
testdb =
(DESCRIPTION =
(ADDRESS_LIST=
(ADDRESS = (PROTOCOL = IPC)(HOST = testhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = testdb)
)
)
The Listener refuses to reload as shown below:
[oracle@testhost admin]$ lsnrctl reload
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 13-JUN-2012 13:16:40
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(HOST=testhost.mel.com)(PORT=1521)))TNS-01103: Protocol specific component of the address is incorrectly specified
TNS-12533: TNS:illegal ADDRESS parameters
TNS-12560: TNS:protocol adapter error
TNS-00503: Illegal ADDRESS parameters
[oracle@testhost admin]$
Thanks for your time.
Regards
Prem