Jump to content


Photo
- - - - -

HElp with VMS Oracle database move


4 replies to this topic

#1 Bowers

Bowers

    Newbie

  • Members
  • Pip
  • 3 posts

Posted 01 August 2007 - 05:59 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......

#2 Chris Mackenzie

Chris Mackenzie

    ProIV Guru

  • Members
  • PipPipPipPipPip
  • 368 posts
  • Gender:Male
  • Location:Bristol, United Kingdom

Posted 02 August 2007 - 08:58 AM

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.

The content and views expressed in this message are those
of the poster and do not represent those of any organisation.

#3 Bowers

Bowers

    Newbie

  • Members
  • Pip
  • 3 posts

Posted 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



#4 Bowers

Bowers

    Newbie

  • Members
  • Pip
  • 3 posts

Posted 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

#5 Chris Mackenzie

Chris Mackenzie

    ProIV Guru

  • Members
  • PipPipPipPipPip
  • 368 posts
  • Gender:Male
  • Location:Bristol, United Kingdom

Posted 03 August 2007 - 11:01 AM

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
The content and views expressed in this message are those
of the poster and do not represent those of any organisation.



Reply to this topic



  


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users