4 replies to this topic

[Bowers]

Can anyone help me - we have a very old installation of Proiv version 4 running on VMS with a local Oracle database. I want to move the database to a Unix server. How do I repoint the database connection to this server?

Thanks in anticipation......

[Chris Mackenzie]

Can anyone help me - we have a very old installation of Proiv version 4 running on VMS with a local Oracle database. I want to move the database to a Unix server. How do I repoint the database connection to this server?

Thanks in anticipation......

Hi Dave!
You've probably read this already but...

First ensure the Oracle client is installed on your p4 server.
and set to support TCP

You need to define the tns connection on your VMS machine.
in $ORACLE_HOME/network/admin (or VMS equiv) create an
entry like:

UNIXserver.company.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = unixserver(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = yourservicename)
)
)

On the Unix server ensure the listener.ora has the correct
service handler defined. Something like:

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = unixservername)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = ac14828))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = yoursid)
(ORACLE_HOME = c:\Oracle\product\9.2.010client)
)
)


In Pro-IV, define sqluser/pass/dbname corrdectly and it should work.

If it doesn't then you may need to define the connection in the p4 ini files
like this:

[DATABASE - SQLDEFAULT]
FILETYPE=ORACLE
CONNECTION=user/pass@servicename


best,
Chris

Edited by Chris Mackenzie, 02 August 2007 - 08:59 AM.

[Bowers]

Can anyone help me - we have a very old installation of Proiv version 4 running on VMS with a local Oracle database. I want to move the database to a Unix server. How do I repoint the database connection to this server?

Thanks in anticipation......

Hi Dave!
You've probably read this already but...

First ensure the Oracle client is installed on your p4 server.
and set to support TCP

You need to define the tns connection on your VMS machine.
in $ORACLE_HOME/network/admin (or VMS equiv) create an
entry like:

UNIXserver.company.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = unixserver(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = yourservicename)
)
)

On the Unix server ensure the listener.ora has the correct
service handler defined. Something like:

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = unixservername)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = ac14828))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = yoursid)
(ORACLE_HOME = c:\Oracle\product\9.2.010client)
)
)


In Pro-IV, define sqluser/pass/dbname corrdectly and it should work.

If it doesn't then you may need to define the connection in the p4 ini files
like this:

[DATABASE - SQLDEFAULT]
FILETYPE=ORACLE
CONNECTION=user/pass@servicename


best,
Chris

[Bowers]

Thanks for the reply. It's a really old app only being used for lookup , so our skills are limited! How do I do the :


"In Pro-IV, define sqluser/pass/dbname corrdectly and it should work."

Also , I found a Pro4.ini but I'm pretty sure it's not the right one. How/when is this activated?

Many Thanks

[Chris Mackenzie]

Thanks for the reply. It's a really old app only being used for lookup , so our skills are limited! How do I do the :


"In Pro-IV, define sqluser/pass/dbname corrdectly and it should work."

Also , I found a Pro4.ini but I'm pretty sure it's not the right one. How/when is this activated?

Many Thanks

SQL_USERNAME
SQL_PASSWORD
SQL_DBNAME

are environment variables. They will be set up in the p4 startup scripts probably
in the same place as PRODATA and PROPATH are set up.

Pr4.ini is read when the p4 kernel starts on VMS - I don't remember where
it's stored in VMS but whoever maintains the P4 system will know as
that's where the licence info etc is. (ask Anders?)

Chris