Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Port No issue

HarshithNov 28 2011 — edited Dec 6 2011
Hi,
We are using Single server machine for DEV,TEST and PROD for OBIEE.
We are done some part of implementation and wanted move DEV to TEST to PROD.
At the time of installation of RCU and OBI we used port no:1571 . Which pointing to DEV,
TEST is pointing to other port:1551 and PROD is pointing to other port:1522
So How to move from DEV to TEST without change the port?
If required to change the port No then how to proceed?
Kindly help on this issue.

Sample tnsnames.ora:
DEV=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 192.1.1.1)
(Port = 1571)
)
)
(CONNECT_DATA = (SID = DEV)
)
)

PROD_CLONE=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 192.1.1.1)
(Port = 1522)
)
)
(CONNECT_DATA = (SID = PROD)
)
)

UAT=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 192.1.1.1)
(Port = 1551)
)
)
(CONNECT_DATA = (SID = UAT)

Edited by: 867932 on Nov 28, 2011 1:08 AM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details