Hi,
We installed Infosphere using the default oracle port of 1521 for our repository database. Now we need to change it. I have scoured the internet and can not find any instructions on how to do so. Does anyone have instructions on how to get this done?
We simply tried changing the client tnsnames.ora file after updating the db server with the new port, but it didn't work. There are many many references to 1521 in various files throughout the installation. Do I need to re-install???
Change Oracle port number.
Moderators: chulett, rschirm, roy
I got a good answer from IBM. These changes worked: 1. stop websphere 2. update the port number in \IBM\InformationServer\ASBServer\apps\lib\ojb-conf.jar/repository_database.xml 3. update the port in \IBM\InformationServer\ASBServer\bin\sql\database.properties 4. start websphere 5. update all database ports under JDBC Providers in the WebSphere Application Server administrative console