Oracle Database Discussions

HELP !!

My main experience is with M/S SQL Server. I am taking an Oracle class and am having a really weird problem. If I log into SQL Plus with SYSDBA privileges and initiate a SHUTDOWN IMMEDIATE, it shuts down successfully, but I am never able to startup (although I can startup from the Database Control or by re-booting). This is a new install for school and I have never been able to make it work. and Yes, I have waited more than a minute for the LISTENER to try and re-start.
Example:

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Feb 17 19:12:08 2008

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


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> connect sys/ dallas@oraclass AS SYSDBA
Connected.
SQL> SHUTDOWN IMMEDIATE
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> STARTUP
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
SQL>

If I log into SQL Plus with SYSDBA privileges and initiate a SHUTDOWN IMMEDIATE, it shuts down successfully, but I am never able to startup (although I can startup from the Database Control).

I get the error:
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

LSNRCNT STATUS sees the SID ORACLASS prior to the shutdown (and the other two DB’s PPCU and TEST01), but after the shutdown, it does not see ORACLASS.

I checked the LISTENER services after the shutdown, and they are running.

I have tried solutions from this forum and others with no success. The main DB is called ORACLASS, but the other two DB’s have the same problem. My Domain is EricsTablet.ericoracle.com and the SID is oraclass.

My IP is 192.168.1.104 the loopback IP is 10.10.10.10

I have even uninstalled and reinstalled Oracle 10g.

Here are all the relevant files. If you can think of something I haven’t tried, please let me know.

C:\oracle\product\10.2.0\db_1\NETWORK\log\listener.log
http://www.spacecoasthomes.net/listener.log

C:\oracle\product\10.2.0\db_1\database\oradim.log
http://www.spacecoasthomes.net/oradim.log

C:\oracle\product\10.2.0\admin\oraclass\pfile\init.ora.122008192731
http://www.spacecoasthomes.net/init.ora.122008192731

C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora
http://www.spacecoasthomes.net/listener.ora

C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\sqlnet.ora
http://www.spacecoasthomes.net/sqlnet.ora

C:\oracle\product\10.2.0\db_1\NETWORK\trace\listener.trc
http://www.spacecoasthomes.net/listener.trc

LSNRCNT STATUS prior to shutdown
http://www.spacecoasthomes.net/lsnrcnt_post.jpg


LSNRCNT STATUS after shutdown
http://www.spacecoasthomes.net/lsnrcnt_prior.jpg