Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

lift and shift oracle

630050Mar 23 2009 — edited Mar 23 2009
Guys recently we have procured a sun server and trying to lift and shift only the Oracle that was installed in the old server to the new one. The directory structures, shell programs in the old server remains intact .
The oracle programs(p/sql) in the new server will be invoked from the old server though shell scripts which will connect remotely.

My shell script in the old server used to call a pl/sql procedure which uses UTL_FILE to read data from the file in the same server.
What I want to know is that since I am moving the oracle to a new server, will there be any impact? I have read that UTL_FILE package will work only if the files are present in the server where oracle is installed; not from where the program is invoked remotely.
So does it mean that I will not be able to invoke the pl/sql procedure which uses UTL_FILE package which will refer data files in the old server.

Please help me...
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 20 2009
Added on Mar 23 2009
4 comments
393 views