Highlighted
Regular Contributor.. Regular Contributor..
Regular Contributor..
145 views

oracle database connection by sql

We don't know what different between case of success and case of fail.

We get error message(ORA-12505, TNS listener does not currently know of SID given in connect descriptor).

There are using same Generic DB Protocol context.

Why case of fail can't get sid and others information?

Oracle login id need more authority? or something?

fail_reason_ORA-12505.JPGfail.JPGsuccess.JPG

 

 

 

0 Likes
2 Replies
Highlighted
Micro Focus Expert
Micro Focus Expert

Re: oracle database connection by sql

I presume some dependencies are missing. 

Can you use shell discovery also?

What's the CP version?

Kind regards,
Bogdan Mureșan
EMEA CMS Technical Success
0 Likes
Highlighted
Acclaimed Contributor.
Acclaimed Contributor.

Re: oracle database connection by sql

Hi Jungwoo,

In order to connect to Oracle, you need to know the SID as well as the IP and port. This information is taken from different discovery jobs - Host Resources by Shell, TCP Port Scan. 

It is normal however not all DB ports to be accessible. That's why ofter several connection attempts fail until you find the one which connects successfully. 

If everything fails and the scan is unsuccessful, then either you haven't found the proper SIDs, or you don't have rights to connect to the DB.

 

Cheers,

Petko

Likes are appreciated!
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.