"Connection Refused: connect" 11g r2 x64 on windows 2008 SP2 x64
558970Mar 26 2012 — edited Mar 26 2012Problem:
1) cannt connect to oracle outside of box. Get "TNS Connection timeout occured"
2) em console "Sepecify Host and Target Database Credentials" always says "Connection refused: connect", even though the OS user/pass and DB user/pass are correct.
What does work:
1) I can "select * from dual" using "sqlplus / as sysdba" from the commandline on the box itself.
2) Once, before I got em console half working, I could connect to the DB from outside the box with SYS as SYSDBA using toad. Now I cant.
How I installed it:
1) created a user called "oracle" and put them in the Administrators group.
2) ran the downloaded installer for enterprise version, partition option chosen, AL32UTF8 char set, global db name: orcl, sid: orcl, "Assert all new security settings on" (No idea what this is) etc.
3) at the end of the installer it came up with the following error:
"Set the environment variable ORACLE_UNQNAME to the database unique name"
3.5) opened up the incomming connections in the windows FW for 1158 and 1521 TCP from all.
4) set ORACLE_UNQNAME as a system env var for oracle as "orcl"
5) set ORACLE_HOME to c:\app\oracle\product\11.2.0 (or should this be c:\app\oracle\product\11.2.0\dbhome_1 ??)
6) set ORACLE_SID to orcl
7) set ORACLE_HOST to dilbert (the machine name)
Rebooted.
8) logged into em console on https:\\dilbert:1158 (works from inside or outside the box).
9) Entered the oracle windows user userame & pass, and SYS and pass (with connect as SYSDBA). However, it always says "Connectoin refused: connect"
Im not using a domain. computer name is correctly setup as "dilbert" in the OS.
I cant think of anything to try, and dont know how to start debugging this problem.
If I look at the running services, i see:
OracleDBConsolorcl Stopped
OracleJobSchedulerORCL Stopped
OracleMTSRecoveryService Stopped
OracleOraDb11g_home1CLRAgent stopped
OracleORADb11g_home1TNSListener Stopped
OracleServiceORCL Running
OrclVssWriterORCL Stopped
Any help greatly appreciated.
Edited by: user555967 on 26-Mar-2012 02:48