My previous travails in the XE installation are documented in 339664. Having finally got XE to install I now have a database I can't connect to.
Attempting to go in through the HTMLDB front end produces an error dialog "The connection was refused when attempting to contact 127.0.0.1:8081". The odd port number is due to the presence of an existing 9i database. Attempting to go in through SQL*Plus throws the eponymous error. The XE listener is stopped. As before, it stops immediately when I try to re-start it.
The XE.BAT.LOG file contains the following:
Instance created.
but CloneRmanRestore.log has the following:
SQL> startup nomount pfile="C:\oraclexe\app\oracle\product\10.2.0\server\config\scripts\init.ora";
ORA-12557: TNS:protocol adapter not loadable
SQL> @C:\oraclexe\app\oracle\product\10.2.0\server\config\scripts\rmanRestoreDatafiles.sql;
SQL> set echo off;
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
ERROR:
ORA-12557: TNS:protocol adapter not loadable
SQL> spool C:\oraclexe\app\oracle\product\10.2.0\server\config\log\cloneDBCreation.log
...and it all goes down hill from there.
I must admit I am sttarting to get slightly jaded by this whole process. Boy I wish my company gave us Linux laptops.
Cheers, APC
P.S. I also now find it vaguely depressing that I'm in the top ten posters on this list.
Message was edited by:
APC
(Having an Eeyore moment)
Message was edited by:
APC (correcting URL)