I am new to Oracle and I installed the Oracle 10g Express Edition on
my windows machine.

Immediately after installation, it worked great and I was able to look
at the tables etc. But after a few days, I cannot seem to log in to my
database home page.

When I try to connect through TOAD, the error I get is
"ORA-12514:TNS:Listener does not know of service requested in connect
descriptor"

This is what I get when I run the status check using "lsnrctl status"

Starting tnslsnr: please wait...

TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
Message 279 not found; No message file for product=NETWORK,
facility=NL
Message 1073 not found; No message file for product=NETWORK,
facility=TNS
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)
(KEY=EXTPROC_FOR_XE)))
TNS-12541: TNS:no listener
TNS-12560: TNSrotocol adapter error
TNS-00511: No listener
32-bit Windows Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhos t)
(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version
10.2.0.1.0 - Production
Start Date 20-DEC-2007 13:53:19
Uptime 0 days 0 hr. 0 min. 4 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Log File listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=XYZ)(POR T=1521)))
The listener supports no services
The command completed successfully

This is the status after I have started the listener first and then
the database service(OracleServiceXE).

listener.ora looks like :
--------------------------------
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 = localhost)(PORT = 1521))
)
)


DEFAULT_SERVICE_LISTENER = (XE)

sqlnet.ORA has:
------------------------
SQLNET.AUTHENTICATION_SERVICES = (NTS)

tnsname.ora has:
------------------------

XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(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)
)
)

The one thing I changed in the ora files was the HOST=XYZ parameter
and I made it HOST=localhost parameter. And the listener.log file
hasnt been updated since the time I installed it. I tried with and
without the hostname as well as with the IP address with no luck.

I have tried re-installing as well, but that doesnt seem to work
either. Even after re-installation, it seems to work immediately after
installation but not subsequently.

Any help or direction would be realllly appreciated!!!

On Dec 20, 2:47 pm, scout1... (AT) gmail (DOT) com wrote:
I'll ask if you're using dynamic IP assignment.


David Fitzjarrell

Make sure you actually have a localhost entry in your hosts file.

On Dec 20, 10:47 pm, scout1... (AT) gmail (DOT) com wrote:

Are you sure the instance automatically starts up after a server
reboot?
Check out the Oracle services status (Windows administrative tools.)

On Dec 21, 4:00*am, vitalis... (AT) gmail (DOT) com wrote:
Thanks for all your replies, guys!!

To answer your questions - Yes, I am on DHCP. I even tried
disconnecting from the network and rebooted standalone and it still
doesnt work. I tried the 127.0.0.1 as well as the <localhost> setting,
and with no luck.

As for the hosts file, could you direct me where it is, so I can check
it out? Remember that I am on a windows machine.

And the service DOES NOT automatically start after a reboot. The
OracleServiceXE does, but the listener doesnt. and restarting doesnt
help. the only time the same installation has worked was immediately
after installation. And it even worked after a reboot on the same day.

Any ideas?

On Dec 21, 8:14*am, scout1... (AT) gmail (DOT) com wrote:
Which release of Windows are you using?


David Fitzjarrell

On Dec 21, 8:14*am, scout1... (AT) gmail (DOT) com wrote:
Usually the hosts file is found in this directory on Windows machines:

C:\WINNT\system32\drivers\etc

The hosts file should already contain an entry for localhost, so I
doubt that's the issue. Have you set the Oracle-related services to
start automatically? My guess is you haven't; if you have you then
need to go to the command prompt and try to start these processes
manually, noting any errors Oracle or Windows reports.


David Fitzjarrell

Thanks for the location of the hosts file, David.

I have windows XP, and the only entry that I have in the host file is
"127.0.0.1 localhost"
Should I put in the entry for "127.0.0.1 myhostxyz"?

The services are setup to start automatically, but after startup, the
listener is always down. It doesnt work even If I start it (manually
or through command line lsnrctl).

Thanks!!

On Dec 21, 9:30*am, Scout <scout1... (AT) gmail (DOT) com> wrote:
No. 127.0.0.1 is reserved for localhost only.

And why is that? There are error messages you could provide from an
attempt to start the listener. I expect that's due to your DHCP
configuration and the fact that your current dynamic IP address is not
the same as the one you obtained when the software was installed.

XP, in its history, can mean many things, including a version known as
XP Home, upon which nothing Oracle would run reliably. However I
expect this is a usable version of the ...ahem ... 'operating system'
and your problems are directly related to your dynamic IP allocation.
Yes, the database worked at installation and after a reboot that same
day, however your IP address lease probably expired between then and
now and your latest reboot assigned a new IP address to your machine.

I believe you'll need to re-install Oracle yet again, this time using
localhost as your host name.


David Fitzjarrell

On Fri, 21 Dec 2007 11:47:09 -0800 (PST), "fitzjarrell (AT) cox (DOT) net"
<fitzjarrell (AT) cox (DOT) net> wrote:


The problem is very likely something messed up in your listener.ora
file. Any chance you saved a copy before editing it?

It's not terribly difficult to remove the listener and recreate it. I
think I'd give that a try before reinstalling Oracle. The Oracle Net
Configuration Assistant (netca) will create a new listener. First,
delete the service and listener.ora, then reboot.