Skip to Main Content

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Oracle 11g XE and SQL Developer

SDCraigSep 1 2014 — edited Sep 9 2014

Hello:

Very new here.  I'm not sure where to post anything.  Apologies, but I'm all over the board.

I've installed 11g and downloaded SQL Developer (not even sure if this needs to be "installed" as it's just a zip file).

Anyway, at the SQL command line I enter CONNECT SYSTEM and then my password.  I get the following error:

ORA 12154:  TNS could not resolve the connect identifier specified.

Also, the "get started" link does not work either.  Not sure what's going on or if it's specific to my laptop.  I've been trying to connect for two days to no avail.

thank for any help.

This post has been answered by Paul M. on Sep 8 2014
Jump to Answer

Comments

Paul M.

What's your Operating System ?

SDCraig

Windows 7 Enterprise

Paul M.

Didn't you have any problems with the installation ? The situation you  describe is quite strange...

Please execute following commands, and post results :

C:\>lsnrctl stat

C:\>set ORACLE_SID=XE

C:\>sqlplus / as sysdba

Of course you downloaded and installed the correct version (32/64 bit)...

SDCraig

c\> isnrctl stat

"isnrctl" is not recognized as an internal or external command, operable program or batch file".

c\> set oracle_sid = xe

"c\>"

c\> sqlplus / as sysdba

"SQL*Plus:  Release 11.2.0.2.0 Projection on Mon Sep 8 10:26:17 2014

Copyright <c> 1982, 2014, Oracle.  All rights researved

Connected to:

Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production

SQL>"

Paul M.

c\> isnrctl stat

It's lsnrctl, not isnrctl.

SDCraig

c\> lsnrctl stat

LSNRCTL for 64-bit Windows: Version 11.2.0.2.0 - Production on 08-SEP-2014 12:28:18

Copyright (c) 1991, 2014, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   64-bit Windows Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=CFXXXXXXX.xxxxxxxxxxxx.com)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   64-bit Windows Error: 61: Unknown error

Paul M.
Answer

Your listener is not running : is OracleXETNSListener service started ?

Marked as Answer by SDCraig · Sep 27 2020
SDCraig

Ok, that worked.  Thanks.

Quick question:  To get started (importing data and utilizing the oracle text functions - ie, contains, fuzzy, etc.), is the next step to access "get started" from the start button and do all of this through the web GUI?  Can all of this be done through SQL developer?

Or should I create another help ticket for this question?

Paul M.

should I create another help ticket for this question?

Please do.

1 - 9
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 7 2014
Added on Sep 1 2014
9 comments
2,861 views