Trouble trying to monitor Oracle database
I have access to two servers, production server and development server.
This is the error I get when trying to monitor development server
Unable to connect to Oracle Server.
Error Message:
Excepci�n Io: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153093120)(ERR=12505)(ERROR_STACK=(ERROR =(CODE=12505)(EMFI=4))))
I could successfully add the production server (My user doesn't have DBA privileges so I got refused with "table or view does not exist", but the point is, the connection to the server was made successfully)
TNSNAMES.ORA is
ZOOMDESA.EMPLOYER.COM.AR =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = zoomdesa)(PORT = 1533))
)
(CONNECT_DATA =
(SERVICE_NAME = ZOOMDESA)
)
)
I filled the fields as follows:
Host Name / IP Address: zoomdesa
do not resolve DNS name: Unchecked
subnet mask: 255.255.255.0
port: 1533
Polling interval: 5
username/password: user with dba privileges
Instance Name (Service Name): zoomdesa
I can log in with SQL*Plus correctly.
Since the error mesage says ERR=12505 I looked it up:
TNS-12505 TNS:listener could not resolve SID given in connect descriptor
Cause: The SID in CONNECT_DATA was not found in the listener's tables.
Action: Check to make sure that the SID specified is correct. The SIDs that are currently registered with the listener can be obtained by typing "LSNRCTL SERVICES listener_name". These SIDs correspond to SID_NAMEs in TNSNAMES.ORA, or DB_NAMES in the INIT.ORA file.
But I really don't know how to fix that. (my TNSNAMES.ORA doesn't contain SID_NAME entry)
Greetings & Thank you
Cristian
New to ADSelfService Plus?