Hello,
I'm using LOCALHOST to connect to my dev database and have no problems connecting using JDBC in Pentaho. When I try to connect to my prod database, it throws "Listener refused the connection with the following error: ORA - 12505, TNS:listener does not currently know of SID given in connect descriptor". Both are 11G databases and I can TNSPING both of these and I can connect to both using SQL Developer.
Here are my TNSNAMES and LISTENER entries:
DEV (working properly):
FTSDEV=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=localhost)
(PORT=1531)
)
(CONNECT_DATA=
(SERVER=dedicated)
(SERVICE_NAME=FTSDEV)
)
)
PROD (not working):
FTSPRD=
(DESCRIPTION=
(ADDRESS_LIST=
(LOAD_BALANCE=on)
(FAILOVER=off)
(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1528))
)
(CONNECT_DATA=(SERVICE_NAME=FTSPRD_ETL))
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\Oracle\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\Oracle\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))
)
)
C:\Users\>lsnrctl services
LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 06-MAY-2015 10:39
:35
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
The command completed successfully
Thank you in advance for your help