Solved

Can't connect to Oracle

Posted on 2010-11-12
7
497 Views
Last Modified: 2012-05-13
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 ?

0
Comment
Question by:omberli
  • 4
  • 2
7 Comments
 
LVL 13

Assisted Solution

by:dsmile
dsmile earned 334 total points
ID: 34121335
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
 

Author Comment

by:omberli
ID: 34121910
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
 
LVL 13

Accepted Solution

by:
dsmile earned 334 total points
ID: 34122086
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:omberli
ID: 34136451
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
 

Assisted Solution

by:syakkanti
syakkanti earned 166 total points
ID: 34142084
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
 

Author Comment

by:omberli
ID: 34145399
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
 

Author Closing Comment

by:omberli
ID: 37962062
Found a solution - actually several things that made this install difficult (Oracle version, server setup (dns) and several other issues).
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now