ORACLE SID NAME IS NOT COMING IN THE DROP DOWN WHILE STARTING

[Nitin]

Hi All

I have a problem. I have got ORACLE 10.0.1 installed on to my system, but when I am trying to login using PL/SQAL Developer, the SID name is not coming into the dropp down, Please help.

Thanks
Nitin

 

[Nitin]

Nitin

 

[Marco Kalter]

The database selection list is populated from the tnsnames.ora file of the Primary Oracle Home (listed first in the PATH environment variable).

 

[tyed2alog]

Is there a limit to the number of dbs displayed in the drop down? Not all of the dbs from the tnsnames.ora are displayed in the drop down and they are not displayed in the same order as the tnsnames.ora file.

 

[Marco Kalter]

No, there is no limit. If there are inconsistencies between the database list and the tnsnames.ora file, then perhaps you have multiple Oracle Homes and therefore multiple tnsnames.ora files? You can check which tnsnames.ora file Direct Oracle Access is using by inspecting the result of the TNSNames function. This function is located in the OracleCI unit, and returns the full path of the tnsnames file.