Hi All,
I am having an issue with connecting to a database and I am getting the error described above. I have done lots of searching on the net and in here but have yet to find a solution.
I have set up my TNSnames.ora file and am able to connect to other databases listed in the file OK but there is one that I am unable to.
My TNSnames entry for the database in question is the following:
CRST108 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.63.125.101)(PORT=1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = CRST108)
)
)
I am getting the error when connecting through sqlplus and SQLDeveloper.
I have added three different connections for various other databases today and the others work OK. I have not changed the listener.ora file to get the other connections working so am a little unsure as to if or why I should change it for CST108.
I am able to run a tnsping CRST108 and it displays the folder location for the tnsnames.ora file so I am out of ideas as to what I need to change.
Others within my development team are able to access the database using the same tnsnames.ora set up as mine and havent needed to change their listener.ora file to get their connection working and we are unable to see anything different in our client setups.
Any advice would be appreciated,
Chris