When I try to access my oracle instance using basic connection type. It gives me an error telling "The network adopter could not be able to establish the connection", But I can connect to the same user using TNS connection. What is wrong? As I guess it is not my oracle instance in the default 1521 port number.
Viewing Port Numbers and Access URLS In most cases, the Oracle Database component's port number is listed in the tool used to configure the port. In addition, ports for some Oracle Database applications are listed in the portlist. ini file. This file is located in ORACLE_BASE \ ORACLE_HOME \install .
If you know SID run TNSPing util
tnsping sid
and it will show you this info
(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = Windows7)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE)))
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With