Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to find the , oracle 11g installed port number

Tags:

java

oracle11g

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.

like image 475
Dinidu Hewage Avatar asked Feb 08 '13 03:02

Dinidu Hewage


People also ask

How do I find my Oracle 11g 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 .


1 Answers

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)))
like image 188
Evgeniy Dorofeev Avatar answered Nov 07 '22 07:11

Evgeniy Dorofeev