07-03-2014 10:31 AM
I am going to implement hpsm 9.30. My client is currently using Oracle DB. Could you pls guide How can I go ahead with Oracle?
Please give your valuable input for the same.
Pls help as it's very urgent for me.
07-03-2014 12:01 PM
Complete instructions for preparation of an Oracle database for SM are included in the interactive installation guide.
That guide is embedded with the SM Help included with the SM ISO download for the SM install.
07-06-2014 03:20 AM
As John suggested you should follow the SM installation guide, it has all the stuff you will need.
Important point is you have to use the 32 bit library of oracle client as SM only supports these. Although you might need to install oracle 64 bit on server (as now days all machines are 64 bit)
To link and change the library you will get all steps in guide.
If use the remote db serevr then have to change the tnsnames.ora on sm server to accommodate the port and service name of oracle db.
On db server you have to open the port to listen from outside client using sqlnet.ora and tnsnames.ora
This will be completed by DBA and easy.
Assign Kudo, if found post useful and mark it accepted if solves the issue.