Can't connect to Oracle

I'm installing an application that is using Oracle 10g Express as its database. Oracle is installed separately. Install seems to go well, and a password is given for SYSTEM.

At the end of install, the 'home page' fails to load in IE.
Tried to run lsnrctl status. It shows the listener port 1521, but not port 8080. Have attached the entire output.

Have checked with netstat -a and it doesn't show any 8080 in use.
It is ok to ping 127.0.0.1 as well as localhost and machine name.

Done several un-installs and re-installs. OS is Windows server 2008 R2 - 64-bit

Any ideas what could be done to fix this ?

Olaf BerliAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
dsmileConnect With a Mentor Commented:
Go to services screen of windows (Window + R > services.msc) and check whether oracle services started or not. Start them all manually if they haven't.
If all go well, use sqlplus to check connection. And that's all you need for any application to connect to your OracleDB.

Oracle local homepage just gives you a webbased tool for you to manage.
0
 
Olaf BerliAuthor Commented:
Not on site now, so I don't have access to the server until monday.

Right after installing, I tried to connect from sqlplus. Got an error saying something like TPA Protocol error (don't have the exact words)

Tried to start the service from the Start Menu. Didn't give any error messages.

I then ran sqlplus again. Got the user / password. Entered SYSTEM as user name and the password I defined during install. Got error message:

ORA: 01034: ORACLE not available

0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
Olaf BerliAuthor Commented:
Checked out the suggestions in the mentioned article, but didn't find any solutuion there. The two Oracle services are started, and there are no error messages in the application log.

Tried to run the sqlplus
Logged on as sysdba
Got the SQL> prompt
Connected to an idle instance

Executed the command: startup
Error message:
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file: 'C:\oraclexe\app\oracle\product\10.2.0\server\dbs\spfileXE.ora'
ORA-27041: unable to open file
ORA-04002: unable to open file
The system cannot find the file specified

Got some tips regarding possible pfile or spfile missing. Searched the entire server for pfile or spfile, but nothing found.

Seems like something is missing in the install?


0
 
syakkantiConnect With a Mentor Commented:
I think you need to create a pfile first. check if there is any file with the name 'init*.ora'.  Then you can use this file to startup the Oracle database.
SQL> startup pfile=<path to init file>
 If not then you can create one. Give some basic pfile parameters and try to start the database.

And regarding the port 1521 and 8080 - generally your database's default listener port is 1521and applications use 8080 as default port.  You have to set the connect string in the application to connect to database. It differs by the type of application you are using.  Check while installing your application if it is asking for a database connection details. If so then give port 1521 and name of the database listener.  The web port will remain 8080 if you want to use the default for you application.  Also check if any restriction is there on the port.

I can provide more info if you can check the above and port the results.
0
 
Olaf BerliAuthor Commented:
Thanks for the suggestions.
Visited the customer today and tried the startup pfile=<path to init file>
Error message changed, but still unable to log in as SYSTEM with the given password.

Also did some testing on another machine:
Installed Oracle on a virtual server 2008 (32 bit). Started well and SYSTEM and password worked well. Also accessing the home page on port 8080.

To check even more - I uninstalled Oracle Express again, added the role Domain Controller (Active Directory + DNS server) to the test server and installed Oracle again. Then the errors showed up. Seems like the install procedure doesn't like to run on a domain controller....?

0
 
Olaf BerliAuthor Commented:
Found a solution - actually several things that made this install difficult (Oracle version, server setup (dns) and several other issues).
0
All Courses

From novice to tech pro — start learning today.