Can't start TNSListener Service - 911!!!

[THoey]

I had two hard disks fail on my DB server. I was given a new server with Win2K. I was told to do my installs on the E: partition. Installed Oracle 8.1.7 there. Created a new DB with the same name as my old test DB. I stopped the services and copied my cold backup files for that DB to the E: drive. Tried starting the services.

Unfortunately, since the old server had the DB's on the D: drive, the DB service started, but starting the DB failed. I next uninstalled Oracle and went through the registry to clean it up. I then reinstalled Oracle to the D: drive.

Now the TNSListener service won't start, it says "Error3: The system could not find the path specified." I am desparate. Any ideas how to remove the service and recreate it or change the path location? Terry
**************************
* General Disclaimor - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...

 

[THoey]

Okay, I tried the Net8 Configuration assistant to delete and then recreate the listener. That completed successfully, but the problem is the same. It has to be a registry entry that is not getting written. Terry
**************************
* General Disclaimor - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...

 

[orclgirl]

THoey,

Do you have the ORACLE_HOME environment variable set? How about the TNS_ADMIN?

If it says that it can't find the path, I think it's related to those environment variables.
;-)

 

[Turkbear]

If you just moved the datafiles, the control files probably point to the wrong place..

Use the 'backup control files to trace' option and look to see what and where your contol file thinks the data files are..

( export and import would have been a better choice for moving to a new OS)

 

[THoey]

We figured it out by comparing the old server's registry to the new. The entry for the TNS Listener path was missing. Added that and was able to start it up.

Thanks for your suggestions... Terry
**************************
* General Disclaimor - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...