Hi Dear Experts/Gurus
I try to connect to an Oracle DB on Amazon AMI.
And I got the following errors.
I open the port 1521 on my Amazon AMI already.
Is there something that I am still missing??
-Thanks for all your help
I can ping the host on my dos prompt
C:\Documents and Settings\laun1>ping ec2-174-129-98-73.compute-1.amazonaws.com
Pinging ec2-174-129-98-73.compute-1.amazonaws.com [174.129.98.73] with 32 bytes
of data:
Reply from 174.129.98.73: bytes=32 time=164ms TTL=46
Reply from 174.129.98.73: bytes=32 time=74ms TTL=46
Reply from 174.129.98.73: bytes=32 time=73ms TTL=46
Reply from 174.129.98.73: bytes=32 time=72ms TTL=46
Ping statistics for 174.129.98.73:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 72ms, Maximum = 164ms, Average = 95ms
When I do a tnsping I got the error below:
C:\oracle\product\10.2.0\client_2\NETWORK\trace>tnsping hpp3m
TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 11-MAY-2
011 13:14:36
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
C:\oracle\product\10.2.0\client_2\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=ec2-174-129-9
8-73.compute-1.amazonaws.com) (PORT=1521)) (CONNECT_DATA= (SERVER=dedicated) (SI
D=hpp3m)))
TNS-12535: TNS:operation timed out
Heres the tnsping trace file:
TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 11-MAY-2011 13:14:36
Copyright (c) 1997, 2005, Oracle. All rights reserved.
--- TRACE CONFIGURATION INFORMATION FOLLOWS ---
New trace stream is C:\oracle\product\10.2.0\client_2\NETWORK\trace\tnsping.trc
New trace level is 4
--- TRACE CONFIGURATION INFORMATION ENDS ---
--- PARAMETER SOURCE INFORMATION FOLLOWS ---
Attempted load of system pfile source C:\oracle\product\10.2.0\client_2\network\admin\sqlnet.ora
Parameter source loaded successfully
-> PARAMETER TABLE LOAD RESULTS FOLLOW <-
Successful parameter table load
-> PARAMETER TABLE HAS THE FOLLOWING CONTENTS <-
TNSPING.TRACE_LEVEL = 4
trace_level_client = 10
NAMES.DIRECTORY_PATH = (TNSNAMES, EZCONNECT)
TNSPING.TRACE_DIRECTORY = C:\oracle\product\10.2.0\client_2\NETWORK\trace
trace_file_client = sqlnet.trc
SQLNET.AUTHENTICATION_SERVICES = (NTS)
SQLNET.INBOUND_CONNECT_TIMEOUT = 0
trace_unique_client = on
trace_directory_client = C:\oracle\product\10.2.0\client_2\NETWORK\trace
--- PARAMETER SOURCE INFORMATION ENDS ---
--- LOG CONFIGURATION INFORMATION FOLLOWS ---
Log stream will be "standard output"
Log stream validation not requested
--- LOG CONFIGURATION INFORMATION ENDS ---
nnftmlf_make_local_addrfile: construction of local names file failed
nnftmlf_make_system_addrfile: system names file is C:\oracle\product\10.2.0\client_2\network\admin\tnsnames.ora
nscall: connecting...
nsc2addr: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ec2-174-129-98-73.compute-1.amazonaws.com)(PORT=1521))(CONNECT_DATA=(SERVER=dedicated)(SID=hpp3m)))
snlinGetAddrInfo: Invalid IP address string ec2-174-129-98-73.compute-1.amazonaws.com
nttbnd2addr: looking up IP addr for host: ec2-174-129-98-73.compute-1.amazonaws.com
nsopen: opening transport...
nttcni: trying to connect to socket 1884.
ntt2err: soc 1884 error - operation=1, ntresnt[0]=505, ntresnt[1]=60, ntresnt[2]=0
nserror: nsres: id=0, op=65, ns=12535, ns2=12560; nt[0]=505, nt[1]=60, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
nsopen: unable to open transport
nscall: connecting...