Home » RDBMS Server » Server Administration » binding a database instance to a certain port
binding a database instance to a certain port [message #53797] Fri, 11 October 2002 08:26 Go to next message
Mike
Messages: 417
Registered: September 1998
Senior Member
Our environment is Windows 2K running Oracle 8.1.7. We have multiple databases running on this server. Is there a way to bind a given database to a certain tcp/ip port so that the database in question only listens on that port? I am new to Oracle. Is this even a best practice?

Report message to a moderator

Re: binding a database instance to a certain port [message #53798 is a reply to message #53797] Fri, 11 October 2002 08:55 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
 
yeah.
it is common, to have multiple databases in the same machine.so u have multiple listeners for them, listening in different ports.
you can have one listener serving many databases
or one listener per database(securityWise this is good..but COSTLY). port 1521 is default. 
u can use anyhthign...speak to ur system/network administrators

Report message to a moderator

Re: binding a database instance to a certain port [message #53803 is a reply to message #53797] Fri, 11 October 2002 13:07 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
You have to edit your listener.ora file, to create listener for each db instance:

LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = yourhost.yourdomain.com)(PORT = 1521))
)
)

LISTENER_DB2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = yourhost.yourdomain.com)(PORT = 1522))
)
)

LISTENER_DB3 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = yourhost.yourdomain.com)(PORT = 1523))
)
)

Then start your listeners with:

$lsnrctl start [[LISTENER]]
$lsnrctl start LISTENER_DB2
$listenr start LISTENER_DB3

It could be a good idea if you have more than one NIC with IP address on your box, and you assign every hostname = to separate IP address. Then the traffic could go through separate VLANs.

We are using something like that to separate the production from the administrative traffic on some boxes. You can bind OEM Agent to a separate IP address and port even. It is up to you how to set it up. Oracle gives you this ability.

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Report message to a moderator

Previous Topic: Re: ocp
Next Topic: How to get this information ???????
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jan 14 07:38:32 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.