Oracle database Server 9.2 fails to start when Windoes 2000 Pro machine rebooted

Home -> Community -> Usenet -> c.d.o.server -> Oracle database Server 9.2 fails to start when Windoes 2000 Pro machine rebooted

From: Gopal Sharma <bunty_gopal_reference_at_yahoo.com>
Date: 2 Jun 2004 07:39:08 -0700
Message-ID: <7c5e6b53.0406020639.2658b88@posting.google.com>

Hi,

I installed the Personal Edition of Oracle 9.2 server on my Windows 2000 Professional machine. Immediately after installation, the DB worked fine, responding to client connections and SQL queries. But after I restarted my machine, the server is not responding to client connections - giving TNS:no listener error in the net8 configuration assistant.

Can any one help and point out what might eb the reason, and how to fix it?

I tried creating new DBs but was unable to connect, even though there was no hiccup during installation.

However, the log files seem to show the server starting when i reboot the machine. following is the contents of log trace file:

Dump file c:\ora9ias\admin\mntest1\udump\mntest1_ora_1340.trc Tue Jun 01 21:54:52 2004
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586 Personal Oracle9i Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production
Windows 2000 Version 5.0 Service Pack 4, CPU type 586 Instance name: mntest1

Redo thread mounted by this instance: 0 <none>

Oracle process number: 12

Windows thread id: 1340, image: ORACLE.EXE

2004-06-01 21:54:52.000
SESSION ID:(9.1) 2004-06-01 21:54:51.000 (blkno = 0xe3, size = 276, max = 1, in-use = 1, last-recid= 0) (blkno = 0xe4, size = 56, max = 72, in-use = 1, last-recid= 1) Thread checkpoint rba:0x000007.00000002.0010 scn:0x0000.0010aaf4 On-disk rba:0x000007.00003e29.0000 scn:0x0000.0010fe1b Use incremental checkpoint cache-low RBA Thread 1 recovery from rba:0x000007.00003060.0000 scn:0x0000.00000000 ----- Redo read statistics for thread 1 ----- Read rate (ASYNC) = 882Kb/sec => 3529 blocks in 2s Read buffer = 8192Kb (16384 blocks) Longest record = 0Kb Record moves = 0/7908 (0%)
2004-06-01 21:55:07.000 KCRA: start recovery claims for 126 data blocks
2004-06-01 21:55:07.000 KCRA: buffers claimed = 126/126, eliminated = 0

Any help would be highly appreciated.

Thanks,
GS Received on Wed Jun 02 2004 - 09:39:08 CDT