Knowledge Base : Glossary : Suggest a Question
Search The Knowledge Base
Browse The Knowledge Base
Knowledge Base : HQ : Data Upload (HQD)

Error : Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor The Connection descriptor used by the client was:localhost:1521:XE

ISSUE :

Error : Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor The Connection descriptor used by the client was:localhost:1521:XE

SYMPTOMS :


While sending the complete or period backup this error occurs in upload status

CAUSE :


1. This is due to connection exceeds or database not connected to HQ

SOLUTION :


1. check for number of connection exceeds in HQ
2.check for database was connected
3. if the database was in other machine (connected in LAN) check the LAN connection


step 1. run this query:

sqlplus system/system
ALTER SYSTEM SET statistics_level = TYPICAL Comment='gft' SCOPE=BOTH;
ALTER SYSTEM SET open_cursors=900 Comment='gft' SCOPE=BOTH;
ALTER SYSTEM SET processes=300 COMMENT='gft' SCOPE=SPFILE;
ALTER SYSTEM SET sessions=300 COMMENT='gft' SCOPE=SPFILE;
commit;

step 2: restart the oracle service

* For Windows

net stop oracleservicexe

net start oracleservicexe

* For Linux

sudo /etc/init.d/oracle-xe stop

sudo /etc/init.d/oracle-xe start



Related Articles
There are no related articles


Viewer Comments Add Comment
No viewers have posted comments

Powered By AutoKB