On Oracle 11g, Installation, and Errors upon restart. (Windows Only)

I have never touched any installation setup of Oracle Servers. The only thing I did was create queries of it. So when the time finally came and I had to install one on my development machine, here are a little info about installation and that troublesome error I get upon restarting my machine.

The only reason why I was having a lot of trouble installing was QA gave me an installation of an Oracle Client. So I found some helpful installation guides on the web.

like this one: http://www.thegeekstuff.com/2008/10/oracle-11g-step-by-step-installation-guide-with-screenshots/

So install towards your likeness (I just need a basic DB and all, so I followed it step by step, used 32bit installer for now on Windows 7 64bit).

Anyway all works well until you get this error upon accessing Database Control – <db name>.

What the h*ll is this?!

Database Control all systems Down!

No wonder I couldn’t connect anywhere. Listeners Agents and Instance down. After trolling the internet. I got to a very good solution:

1. Checking/Starting up the Listener
   - go onto your command console  and type in ‘lsnrctl status‘
   - if will probably look like this :

   C:\Users\Dude>lsnrctl status
   
   LSNRCTL for 32-bit Windows: Version 11.1.0.7.0 - Production on 12-JUL-2011 17:19:37
   
   Copyright (c) 1991, 2008, Oracle.  All rights reserved.
   
   Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
   TNS-12541: TNS:no listener
    TNS-12560: TNS:protocol adapter error
     TNS-00511: No listener
      32-bit Windows Error: 2: No such file or directory
   Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.5.1.59)(PORT=1521)))
   TNS-12541: TNS:no listener
    TNS-12560: TNS:protocol adapter error
     TNS-00511: No listener
      32-bit Windows Error: 61: Unknown error

   - Don’t panic! Just need to start it up using ‘lsnrctl start‘
   - Now it will show this :

   C:\Users\Dude>lsnrctl start
   LSNRCTL for 32-bit Windows: Version 11.1.0.7.0 - Production on 12-JUL-2011 17:22:03
   
   Copyright (c) 1991, 2008, Oracle. All rights reserved.
   
   Starting tnslsnr: please wait...
   
   TNSLSNR for 32-bit Windows: Version 11.1.0.7.0 - Production
   System parameter file is D:\app\Noemi\product\11.1.0\db_1\network\admin\listener.ora
   Log messages written to d:\app\noemi\diag\tnslsnr\Noemi-Win7\listener\alert\log.xml
   Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
   Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.5.1.59)(PORT=1521)))
   
   Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
   STATUS of the LISTENER
   ------------------------
   Alias LISTENER
   Version TNSLSNR for 32-bit Windows: Version 11.1.0.7.0 - Production
   Start Date 12-JUL-2011 17:22:06
   Uptime 0 days 0 hr. 0 min. 7 sec
   Trace Level off
   Security ON: Local OS Authentication
   SNMP OFF
   Listener Parameter File D:\app\Noemi\product\11.1.0\db_1\network\admin\listener.ora
   Listener Log File d:\app\noemi\diag\tnslsnr\Noemi-Win7\listener\alert\log.xml
   Listening Endpoints Summary...
   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.5.1.59)(PORT=1521)))
   The listener supports no services
   The command completed successfully

   - you would now see your listener up

   

   Listener is now UP

    

2. Starting up OracleService<DB Name>
   - Unfortunately, that’s not all. Now you need to check if your service is running.
   - Under Windows Service (services.msc) you will see OracleService<DB Name> is Automatic. You cannot Start/Stop it. You may check your service via the Command Prompt again  using
   ‘sqlplus <username>/<password>‘

   C:\Users\Dude>sqlplus scott/tiger
   
   SQL*Plus: Release 11.1.0.7.0 - Production on Tue Jul 12 17:30:58 2011
   
   Copyright (c) 1982, 2008, Oracle.  All rights reserved.
   
   ERROR:
   ORA-12560: TNS:protocol adapter error

   - if you see something like this, your service isn’t started up. Start the OracleService using
   ‘net start OracleService<DB Name>‘

   and voila! your OracleService will be started successfully.

   C:\Users\Noemi>net start OracleServiceORCL
   The OracleServiceORCL service is starting...........................
   The OracleServiceORCL service was started successfully.

Now you will be able to go into your Database Control successfully and see all services are up!

Login Desired Username/Pasword

Oracle Services are all UP~!

I have still yet to figure out to do this automatically and not in every start of my PC. So I’ll let you know if there’s any updates.

Enjoy Oracle!

* Many thanks to AskTom for the solution (http://asktom.oracle.com/pls/asktom/f?p=100:11:0::NO::P11_QUESTION_ID:431775600346873836)