Home » RDBMS Server » Networking and Gateways » How can we change the Oracle Port
How can we change the Oracle Port [message #348324] Tue, 16 September 2008 07:33 Go to next message
nagaraju.ch
Messages: 98
Registered: July 2007
Location: bangalore
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.....
Re: How can we change the Oracle Port [message #348327 is a reply to message #348324] Tue, 16 September 2008 07:42 Go to previous messageGo to next message
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
Re: How can we change the Oracle Port [message #348329 is a reply to message #348327] Tue, 16 September 2008 07:45 Go to previous messageGo to next message
nagaraju.ch
Messages: 98
Registered: July 2007
Location: bangalore
Member
thanks for your quick reply,

Re-installing is not possible in our situation, since many applications are accessing the database on that machine.
Re: How can we change the Oracle Port [message #348332 is a reply to message #348329] Tue, 16 September 2008 07:47 Go to previous messageGo to next message
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

Re: How can we change the Oracle Port [message #348338 is a reply to message #348332] Tue, 16 September 2008 08:03 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Frank
Messages: 7880
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.
Re: How can we change the Oracle Port [message #348571 is a reply to message #348340] Wed, 17 September 2008 05:23 Go to previous messageGo to next message
nagaraju.ch
Messages: 98
Registered: July 2007
Location: bangalore
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.
Re: How can we change the Oracle Port [message #362239 is a reply to message #348324] Mon, 01 December 2008 07:23 Go to previous messageGo to next message
platingnum
Messages: 1
Registered: December 2008
Junior Member
search on google for that i am sure some one else might have asked that.
Re: How can we change the Oracle Port [message #362240 is a reply to message #362239] Mon, 01 December 2008 07:27 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
./fa/5263/0/ Your first post is a great one! ./fa/2115/0/

Regards
Michel

[Updated on: Mon, 01 December 2008 07:27]

Report message to a moderator

Previous Topic: dropping database links and materialized views
Next Topic: Oracle Net during data guard swithover
Goto Forum:
  


Current Time: Sat Dec 03 05:50:44 CST 2016

Total time taken to generate the page: 0.20580 seconds