SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORACLE_SID not created with 10 XE install

812492Nov 29 2010 — edited Nov 29 2010

I've got an Oracle 10g XE install on Windows Server 2003. I've been trying to setup a new database following this guide:
http://devtime.blogspot.com/2006/01/creating-oracle-xe-database-manually.html
The ORACLE_SID System variable was not created so I created it manually, but I get:

echo %ORACLE_SID%

ORACLE_SID

instead of the actual value I assigned to the variable. I get an "ORA-12560: TNS:protocol adapter error". When I execute a 'sql>connect / as sysdba'. Both the service and the ORACLE_SID variable have the correct values. I tried before and after restarting the OracleXETNSListener service after creating the ORACLE_SID variable but it made no difference, what am I missing here?

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 27 2010

Added on Nov 29 2010

2 comments

1,630 views