OraFAQ Forum: Networking and Gateways » How can we change the Oracle Port

Home » RDBMS Server » Networking and Gateways » How can we change the Oracle Port

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How can we change the Oracle Port [message #348324]

Tue, 16 September 2008 07:33

nagaraju.ch
Messages: 103
Registered: July 2007
Location: bangalore

Senior Member

Hi experts,

I have installed oracle on my machine. after that i tried to install Business Objects on same machine, i got exception while processing the installation like The port No.is already in Use.

I want to change the port No. of Oracle , where can i change,Please suggest me to change it.....

Report message to a moderator

Re: How can we change the Oracle Port [message #348327 is a reply to message #348324]

Tue, 16 September 2008 07:42

monikabhakuni
Messages: 110
Registered: September 2008
Location: India

Senior Member

once i had also faced the similar issue with oracle10g .
For this you will have to uninstall oracle and install it again and their you will hve to give a different port number.

otherwise once you can try by changing the port numebr in TNS.ora also if it work. but i am not sure about it

Report message to a moderator

Re: How can we change the Oracle Port [message #348329 is a reply to message #348327]

Tue, 16 September 2008 07:45

nagaraju.ch
Messages: 103
Registered: July 2007
Location: bangalore

Senior Member

thanks for your quick reply,

Re-installing is not possible in our situation, since many applications are accessing the database on that machine.

Report message to a moderator

Re: How can we change the Oracle Port [message #348332 is a reply to message #348329]

Tue, 16 September 2008 07:47

monikabhakuni
Messages: 110
Registered: September 2008
Location: India

Senior Member

ok so you can try this also. but i am not sure if it will work or not.

go to oracle
inside it ora92->network->admin->TNS.ora

change the port number and save it

see if it work

Report message to a moderator

Re: How can we change the Oracle Port [message #348338 is a reply to message #348332]

Tue, 16 September 2008 08:03

Olivia
Messages: 519
Registered: June 2008

Senior Member

[Message deleted]

Regards,
Oli

[Updated on: Tue, 16 September 2008 08:09]

Report message to a moderator

Re: How can we change the Oracle Port [message #348340 is a reply to message #348332]

Tue, 16 September 2008 08:06

Frank
Messages: 7901
Registered: March 2000

Senior Member

monikabhakuni wrote on Tue, 16 September 2008 14:47

ok so you can try this also. but i am not sure if it will work or not.

go to oracle
inside it ora92->network->admin->TNS.ora

change the port number and save it

see if it work

Don't guess.
Changing the port in tnsnames.ora (as the file is called) will only result in not being able to connect to the database.
Since the original poster explained that the database is accessed by other apps, changing the portnumber for the database is not an option.
You should choose another portnumber for Business Objects.

Report message to a moderator

Re: How can we change the Oracle Port [message #348571 is a reply to message #348340]

Wed, 17 September 2008 05:23

nagaraju.ch
Messages: 103
Registered: July 2007
Location: bangalore

Senior Member

What will happen when we change the Port Number for Oracle, we will distribute the tns name with new port Number, I think it will fine.

Another one is when we install Oracle, does tomcat also installed.

Report message to a moderator