Oracle Database Express Edition (XE)

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!

Problems connecting from sqlplus, Toad

528081Aug 16 2006 — edited Aug 16 2006

So I've got XE up and running. I can go through the HTML interface, view tables, execute scripts, etc. If I select "Run SQL Command Line" from the start menu (I'm on Windows 2000) I get a sqlplus prompt. If I try to run

sqlplus "/ as sysdba"

I get "Username retrieval failed" which is the same error I get when I try to connect with Toad (using the XE client and XE as the database. I've made sure that the host entries in listener.ora and tnsnames.ora matches the network name of my machine.

I have the Oracle 10g client installed in C:\oracle and XE in C:\oraclexe which I suspect may have something to do with my problems.

Any idea how to go about getting things sorted? Ideally, I'd like to be able to continue connecting to the central Oracle servers in addition to being able to access my XE through Toad.

Thanks

Colin

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 13 2006

Added on Aug 16 2006

4 comments

392 views