Oracle Database Discussions

I know this has been answered many times but I can just not make it work. I installed Oracle and all ran fine, very small DB, until the server was rebooted. I had to uninstall and reinstall to get it working again. When the server was rebooted I received the error again.

Any help would be greatly appreciated...ed


Here's the details.

I'm running Oracle 10.2 on Win2003 Server

I have oracle installed in c:\ora102

I have not changed any init files.

I have 2 environment variables set:
ORACLE_HOME=C:\ora102
ORACLE_SID=ORACLE

I tried upper and lower case for the oracle_sid value

--------------------------

Listener.ora:

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = ORACLE)
(ORACLE_HOME = C:\ora102)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = Win2003Server)(PORT = 1521))
)
)



----------------------------

c:\>tnsping local
TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 29-APR-2009 10:34:47

Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:

C:\ora102\network\admin\sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = Win2003Server)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = oracle)))
OK (20 msec)

-------------------------

c:\>sqlplus system/foobar@local

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Apr 29 10:37:26 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.

ERROR:
ORA-28547: connection to server failed, probable Oracle Net admin error

------------------------------

c:\>sqlplus sys/foobar as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Apr 29 10:33:18 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to an idle instance.

SQL> show parameter local listener
ORA-01034: ORACLE not available