updating oracle user/pass

[mamurao]

Hi experts,

I have a dilema here as this NA i'm supporting was installed by another admin that left the company. I need to update the oracle user/pass in my DB server. My application is on an APP server. I wanted to know if i need to change anything on the app server if i go ahead and update the oracle user/pass .

appreciate the response.

thanks

mark

[mherculea]

Hi,

You can use tc_tools script to configure/update DB connection informations.

Find the script in NA_install_dir/client

Execute the script.

Follow option 1.

--

Example:

root@na910hs3 client]# ./tc_tools.sh

Choose an operation to perform:
        1 - Change database connection information
        2 - Save device passwords to file
        3 - Reset update in progress information
        4 - Exit

tc_tools> 1
Database Server [16.999.17.999]:
Database Port [1521]:
Database Name [na910hs]:
Database User [na]:
Database Password [********]:
Database connection information changed.

Best regards,

[mamurao · Accepted solution]

thanks marius, i'll try your procedure ,

thanks very much

[mamurao]

Hi marius, this work for me. i have a followup question i have buidl a new DR server that replaces the existing DR. can i just run thi scommand to point the new DR server to the same database as the existing DR server?

[mherculea]

Hi,

Just to clarify, you are talking about Horizontal Scalability and not HS + Disaster recovery.

So per my understanding

- you have core A=core id 1 and Core B=core id 2 in HS architecture.

- want to replace core B with core C.

- you already installed core C which acts as standalone..

- you are not using a gateway mesh for your HS system

Is core C using an oracle dB?

if yes then

1. Stop Core B

2. Edit your HS DB RN_CORE table, and update CoreHostname with the Core C server IP or DNS hostname. commit.

3.  Stop Core C.

a add the discributed.rcx file to /opt/NA/jre folder updated as per HS user guide

b. use tc_tools to point the core C  NA to the HS DB.

4. If you have devices configured to send syslog to core B, run a syslog configure task for them to use Core C.

if core C was installed and mysql db, then you`ll have to re-install na on core C and point it at install time to the already existing Oracle NA HS DB( still items 1, 2, 3a and 4 need to be taken care of)

Let me know if this helps.

Cheers,

[mamurao]

Hi Marius,

thanks for the response and yes that is my current setup today.

Yes i'm using Oracle today. just to clarify on step 2. Edit your HS DB RN_CORE table. do you mean this command?

1. locate the old backup coreid : select * from RN_CORE

2. update RN_CORE set CoreHostname='newhost.com' where coreid=<the cord id from from point 1>

thanks for the response

i'll wait for your confirmation

thanks

mark

[mherculea]

Hi,

Yes. That`s correct.

Best regards,

[mamurao]

Perfect, great thanks Marius :),

One last thing the distributed.rcx that i extracted from the HS dvd. which server to i put this one? the new server /opt/NA/jre?

thanks a lot , you guys are a life saver !

more power to all

[mherculea]

Hi,

All servers participating in the HS mesh need to have the distributed rcx file uploaded in jre folder.

Please review the HS documentation on procedures for initial setup, add core to mesh, topology and detailed hs setup

http://support.openview.hp.com/selfsolve/document/KM00445959

Kind regards,

[mamurao]

Hi Marius,

thanks, step 2: Edit your HS DB RN_CORE table, and udpate the CoreHostname with the Core C server IP or DNS hostname, commkt.

this would be my primary database RN_CORE table where A and B are connected today. ?

thanks

mark