Cadet 1st Class Cadet 1st Class
Cadet 1st Class
1293 views

updating oracle user/pass

Jump to solution

 

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

Tags (1)
0 Likes
1 Solution

Accepted Solutions
Cadet 1st Class Cadet 1st Class
Cadet 1st Class

thanks marius, i'll try your procedure ,

 

thanks very much

View solution in original post

0 Likes
9 Replies
Cadet 2nd Class Cadet 2nd Class
Cadet 2nd Class

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,

Marius Herculea
HP SW Technical Consultant

Cloud and Automation Professional Services

Cadet 1st Class Cadet 1st Class
Cadet 1st Class

thanks marius, i'll try your procedure ,

 

thanks very much

View solution in original post

0 Likes
Cadet 1st Class Cadet 1st Class
Cadet 1st Class
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?
0 Likes
Cadet 2nd Class Cadet 2nd Class
Cadet 2nd Class

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,

 

 

Marius Herculea
HP SW Technical Consultant

Cloud and Automation Professional Services

0 Likes
Cadet 1st Class Cadet 1st Class
Cadet 1st Class

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

0 Likes
Cadet 2nd Class Cadet 2nd Class
Cadet 2nd Class

Hi,

 

Yes. That`s correct.

 

Best regards,

Marius Herculea
HP SW Technical Consultant

Cloud and Automation Professional Services

0 Likes
Cadet 1st Class Cadet 1st Class
Cadet 1st Class

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

0 Likes
Cadet 2nd Class Cadet 2nd Class
Cadet 2nd Class

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,

Marius Herculea
HP SW Technical Consultant

Cloud and Automation Professional Services

0 Likes
Cadet 1st Class Cadet 1st Class
Cadet 1st Class

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

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.