OracleXE and Designer connection problem

Mik · *nix forums beginner Joined: 28 Apr 2005 Posts: 23

Resolved

There seems it does not accept 127.0.0.1 as HOST. I've put the
fully qualified host names in all the config files and it seems to work well
now.

Thanks!

--
Mik

Mik · *nix forums beginner Joined: 28 Apr 2005 Posts: 23

"HansF" <Fuzzy.Greybeard@gmail.com> escribió en el mensaje
news:pan.2006.05.10.14.52.56.247430@gmail.com...

HansF · *nix forums Guru Joined: 09 Mar 2005 Posts: 1090

On Wed, 10 May 2006 12:07:51 +0200, Mik wrote:

ORA-12514:

Either the XE instance is not registering itself to the listener ...
specifically the listener that is on the port that you are trying to hit;
OR
the service picked up by the @XE alias (which selects the 'XE ='
entry in the TNSNAMES.ORA) does not exactly match the service that has
registered itself to the listener.

Two test, both at command line, are:

1) tnsping XE

Done from the client environment. Should result in an output like

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)
(HOST = fuzzy)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED)
(SERVICE_NAME = XE))) OK (0 msec)

Note the 'SERVICE_NAME' and 'PORT' entries.

If it does not provide an 'OK', you need to get that fixed first.

We are asking the listener on that port to connect to a service named 'XE'.

2) lsnrctl status

Done from the server's environment that listens on the same port as above.
Should include some lines that look like

Service "XE" has 1 instance(s).
Instance "XE", status READY, has 1 handler(s) for this service...

where the Service matches EXACTLY (case, spaces, etc) to the output from
tnsping. This tells us the listener is able to connect to a service named
'XE', which matches the above request.

If these two match and there still is an ORA-12514, there is a high
probablity that the wrong tnsnames.ora

--
/Hans ... mailto: Fuzzy_dot_GreyBreard_at_gmail_dot_com
Top posting in newsgroups is a sure way to stop my replies!

I reserve the right to change my mind on anything. Especially when
confronted with facts that are better than the ones I use right now.

Mik · *nix forums beginner Joined: 28 Apr 2005 Posts: 23

<sybrandb@yahoo.com> escribió en el mensaje
news:1147258145.760883.44440@v46g2000cwv.googlegroups.com...

sybrandb@yahoo.com · *nix forums Guru Joined: 30 May 2005 Posts: 482

You should copy the XE = entry from the first tnsnames.ora in the
second tnsnames.ora
and use XE as connection string.

This question obviously has been asked over and over and over again.
Please search the archives prior to posting.

--
Sybrand Bakker
Senior Oracle DBA

Mik · *nix forums beginner Joined: 28 Apr 2005 Posts: 23

Hi all,

I'm a very newbie in Oracle. I've installed the latest OracleXE server and
created a new user and some simple tables. Next, I installed in the same
machine the Oracle Developer Suite, including Oracle Designer. But when I
launch Designer, I can't pass the login screen as I do not know what to put
in the "Connect string" field. I've tried with "127.0.0.1" which results in
a ORA-12514 error (The SERVICE_NAME in the CONNECT_DATA was not found in the
listener's tables.)

The contents of the relevant server configuration files at
C:\oraclexe\app\oracle\product\10.2.0\server\NETWORK\ADMIN\ are as follows:

*** LISTENER.ORA
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
)

DEFAULT_SERVICE_LISTENER = (XE)

*** SLQNET.ORA
SQLNET.AUTHENTICATION_SERVICES = (NTS)

*** TNSNAMES.ORA
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)

And the content of the file tnsnames.ora where the Developer Suite is
installed (C:\DevSuiteHome_1\NETWORK\ADMIN) is:

*** TNSNAMES.ORA
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PLSExtProc)
)
)

What should I put in the "Connect String" field ???. Of course both the
server and listener are running, and the Oracle web administrator interface
works perfectly.

Thanks in advance,
--
Mik

Google