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 ?
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 ?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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\pr
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?
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\pr
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?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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....?
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....?
ASKER
Found a solution - actually several things that made this install difficult (Oracle version, server setup (dns) and several other issues).
ASKER
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