Q
Problem solve Get help with specific problems with your technologies, process and projects.

Problems installing Oracle 9i on Windows 2000 server

I was installing Oracle 9i database on Windows 2000 server. During installation, I got one error while loading ORACLE DATABASE CONFIGURATION ASSISTANT. The error was "problem in loading OracleBase_queries," so I had to skip the installation of this component.

Afterwards the installation went fine, but in the end it gave this message "installation was unsuccessful." Then I saw that the service called OracleServiceSID was not created during the installation (I selected a different home for Oracle 9i), but the other services such as HTTP, LISTENER, OLAP, SNMP etc. are there. I also have Oracle 8i on the same machine, and right now there are two listeners -- one for 8i (on port 1521) and one for 9i (on port 1522).

After reconfiguruing the listener for 9i to port 1522, I tried to individually install the DB CONFIG ASSISTANT, but it again gave the same error. When I sign in using the following, it gives error:

 G:sqlplus /nolog
 SQL>connect /as sysdba
 error: service not initialized
Now I terribly need help because I did the installation after reading the documentation.


You'll have to create your Windows service to get the database up and running. The ORADIM command can be used to create the service. The format is as follows:

ORADIMxx  -NEW  -SID 
 
   -INTPWD  
  
    
-STARTMODE 
   
     -PFILE  
    

    
   
  
 
is your database SID.
is the password for the INTERNAL user.
is MANUAL or AUTO and indicates how the service will start on server reboot.
is you init.ora file (complete with directory name).

Once the service has been created, start it. At that time, you database will be up and running.

For More Information

  • What do you think about this answer? E-mail the editors at editor@searchDatabase.com with your feedback.
  • The Best Oracle Web Links: tips, tutorials, scripts, and more.
  • Have an Oracle or SQL tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
  • Ask your technical Oracle and SQL questions -- or help out your peers by answering them -- in our live discussion forums.
  • Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close