| oracle on another port [message #61681] |
Mon, 17 May 2004 06:12  |
amit dalvi
Messages: 1
Registered: May 2004
|
Junior Member |
|
|
In java code I am using OracleConnectionCacheImpl for getting connections from oracle pool. I set database, server, port and username-password attributes on it. The port number I set is always 1521. My questions is - is there a possibility that oracle isn't running on port 1521 but some other port(for some oracle installation) and my application would fail to connect ???
Also, the 1521 default port is for oracle database server to run or is it used for running TNS service and can we change it to some other port and how ???
Can anyone please explain these things to me in simple words ?
Thanks in advance,
-amit
|
|
|
|
| Re: oracle on another port [message #61682 is a reply to message #61681] |
Mon, 17 May 2004 07:06  |
Anatol Ciolac
Messages: 113
Registered: December 2003
|
Senior Member |
|
|
1)Edit a file $ORACLE_HOME/network/admin/listener.ora - add a strings:
LISTENER_on_other_port =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = your_hostname)(PORT = your_port_name))
)
(ADDRESS_LIST =
(ADDRESS= (PROTOCOL= IPC)(KEY= your_db_name))
)
)
)
2)In operating system start command lsnrctl and execute a command reload:
lsnrctl>reload LISTENER_on_other_port
To verify if you listener is cofigured good execute
lsnrctl>status LISTENER_on_other_port
You must to see that all right.
3)Edit your $ORACLE_HOME/network/admin/tnsmanes.ora. Add this strings:
your_db_name =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = your_hostname)(PORT = your_port_number))
(CONNECT_DATA = (SID = your_db_name))
)
4)Execute a command
tnsping your_db_name
If all configured good - you will see a output about a time to connect to database. Else you will give a error an must to resolve them.
P.S. This opreration is applicable in Unix OS. In Windows try to use a Net8 Configuration Assistant.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
