Re: Connect to Oracle 11g using PL-SQL developer and SQL PLus

On Tuesday, October 15, 2013 10:18:12 AM UTC-6, Amir Diwan wrote:
> _at_David: Probably, you are right. I havent set my SID which is why this is occuring.
>
>
>
> How do i know the Oracle_SID for my PC? How do I create an SID in Oracle 11g?
>
>
>
> Its not in tnsnames.ora file. The three .ora files tnsnames.ora, sqlnet.ora and listener.ora are in the folder \db_2\network\admin\sample\ . But, they are present in the generalized format. And, if I try to modify them, Windows denies access to that, despite, they are not even READ-ONLY files.

Since this is probably Windows you should check Services for an OracleServicexxxxx entry; the xxxxx part is the SID you should be using. On a UNIX/Linux platform a ps -ef | grep pmon command, from the shell prompt, will give you output similar to this:

$ ps -ef | grep pmon
oracle 18346 1 0 Oct06 ? 00:03:57 ora_pmon_dbm1

The text after the second underscore is the SID.

You would then need to set the ORACLE_SID on Windows as follows:

set ORACLE_SID=xxxxx

where xxxxx is replaced with your actual SID. On UNIX/Linux it's a bit different:

$export ORACLE_SID=xxxxx

again where xxxxx is replaced with the actual SID.

David Fitzjarrell Received on Wed Oct 16 2013 - 17:36:03 CEST