10g startup problem on W2k Pro

From: Alex NSB <alexnsb_at_tin.it>
Date: Wed, 1 Dec 2004 17:40:42 +0100
Message-ID: <coks8q$n1a$1@newsread.albacom.net>

Hi.

I'm running Oracle Enterprise Edition Release 10.1.0.2.0 on Windows2000 Professional SP4 and I have the following problem: when I startup the PC (after regular shutdown) I can't access the db.

For example, if I try to connect from SQL-Plus I get the following error:

---

ERROR:
ORA-01033: ORACLE initialization or shutdown in progress

---

All Oracle services marked as "Autostart" are running, namely:

OracleCompanion10g_home1ProcessManager
OracleCSService
OracleDBConsoleorcl

OracleOraDb10g_home1iSQL*Plus
OracleOraDb10g_home1TNSListener
OracleOraEM10g_home1Agent

OracleServiceORCL

To quickly fix the issue it is sufficient restarting the OracleServiceORCL (which implies restarting the OracleDBConsoleorcl as well).

What can be causing this?

I tried checking the log files and the only thing I have found so far is a certain number of errors, in sqlnet.log, like:

---

Fatal NI connect error 12528, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=myhost.mydomain.it)(Port=1521))(CO NNECT_DATA=(SID=orcl)(CID=(PROGRAM=E:\oracle\product\10.1.0\Db_1\perl\5.6.1\ bin\MSWin32-x86\perl.exe)(HOST=MYHOST)(USER=SYSTEM))))

---

Not sure if they are related to my problem, though.

TIA for your assistance.

Alessandro Received on Wed Dec 01 2004 - 10:40:42 CST