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 initializedNow 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
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.