<div>
Hi!<br />
<br />
As far as I remember the default SID for Personal Oracle is :2 (or 2:?), i.e. you should use<br />
<br />
sqlplus scott/tiger@2:<br />
<br />
Andrew
</div>


Hi!

As far as I remember the default SID for Personal Oracle is :2 (or 2:?), i.e. you should use

sqlplus scott/tiger@2:

Andrew

<div>
As sbenyo has pointed out, the default sid is ORCL. I use a personal Oracle 8.0.4 on my laptop and for a personal edition, you don't have to set any sid and don't even require the tns alias or service name to connect to the database. Just invoke the corresponding tool and give the username/password and you should be able to connect.
</div>


As sbenyo has pointed out, the default sid is ORCL. I use a personal Oracle 8.0.4 on my laptop and for a personal edition, you don't have to set any sid and don't even require the tns alias or service name to connect to the database. Just invoke the corresponding tool and give the username/password and you should be able to connect.

<div>
On many platforms if you are running SQL*Plus on the same machine that the database is on, you don't need an entry at all for the third line of the login prompt. &nbsp;If you do need an entry on that line it is the TNS alias for the database, not the SID that is required.
</div>


On many platforms if you are running SQL*Plus on the same machine that the database is on, you don't need an entry at all for the third line of the login prompt.  If you do need an entry on that line it is the TNS alias for the database, not the SID that is required.

<div>
Many thanx for the description. Actually I wanted to connect to the personal oracle on my notebook thru java oracle jdbc drivers.<br />
<br />

</div>


Many thanx for the description. Actually I wanted to connect to the personal oracle on my notebook thru java oracle jdbc drivers.



<div>
Hi,<br />
<br />
Reffer to a previous question related to this subject:<br />
<br />
<a href="https://www.experts-exchange.com/jsp/qShow.jsp?ta=oracle&qid=10305154" rel="ugc">https://www.experts-exchange.com/jsp/qShow.jsp?ta=oracle&qid=10305154</a>&nbsp;<br />
<br />

</div>


Hi,

Reffer to a previous question related to this subject:

https://www.experts-exchange.com/jsp/qShow.jsp?ta=oracle&qid=10305154 [https://www.experts-exchange.com/jsp/qShow.jsp?ta=oracle&qid=10305154] 



<div>
<div class="content wysiwyg-content">
I have installed personal oracle on my system running NT. Can someone tell me what is the default SID [I want to connect to my DB as sqlplus scott/tiger@xxxxx, what is xxxxx]<br />
<br />

</div>
</div>


I have installed personal oracle on my system running NT. Can someone tell me what is the default SID [I want to connect to my DB as sqlplus scott/tiger@xxxxx, what is xxxxx]



Default SID

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.