Re: oracle 8.1.7 and windows 2000 server

Choung wrote:

> Hi,
>
> I've been having problems installing Oracle 8.1.7 on Windows 2000 server.
> Once I actually get Oracle installed and I created the instance, everytime I
> shut the computer down and try to log into the database I can't. It seems
> like it can't see the database any more. Any suggestions.
>
> thanks,

Follow Sybrand and Frank's advice. If you are still stuck do this:

Open a DOS window and go to the Oracle BIN directory.

Try this:

lsnrctl status

If the listener is started it will report back the amount of time it has been running. If not started try:

lsnrctl start

If you get any error messages write them down (completely don't just guess at what they say or mean).

If the listener is started then:

svrmgrl

if you get the server manager prompt:

connect internal

then:

startup

then after it has started try:

SELECT COUNT(*) FROM tab$;

If you get a value everything is fine. If not record the error message(s) and post them at comp.databases.oracle.sever along with complete information on Oracle version, edition, platform, and operating system.

Daniel Morgan Received on Mon Feb 10 2003 - 17:07:53 CST