Jump to content


Bowers

Member Since 01 Aug 2007
Offline Last Active Aug 08 2007 12:46 PM
-----

Posts I've Made

In Topic: HElp with VMS Oracle database move

02 August 2007 - 05:09 PM

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

In Topic: HElp with VMS Oracle database move

02 August 2007 - 05:05 PM

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