- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Relink Oracle ?
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-06-2004 08:35 PM
тАО10-06-2004 08:35 PM
Relink Oracle ?
This is Oracle 9.0.1.4.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-06-2004 08:40 PM
тАО10-06-2004 08:40 PM
Re: Relink Oracle ?
However, relinking an oracle 9i is easy :
connect as oracle unix user
issue the "relink all" command
Note : All DB running this Oracle Home must be stopped during relinking.
Regards,
Fred
"Reality is just a point of view." (P. K. D.)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-06-2004 08:48 PM
тАО10-06-2004 08:48 PM
Re: Relink Oracle ?
You can find the make files (for relink) doing this:
find $ORACLE_HOME -name *.mk|more
RDBMS make files where at $ORACLE_HOME/rdbms/lib on Oracle 8i...
Normally relinking is automatically done when apllying the database patches. From what version have you upgraded?
Best Regards,
Eric Antunes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-06-2004 08:55 PM
тАО10-06-2004 08:55 PM
Re: Relink Oracle ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-06-2004 09:00 PM
тАО10-06-2004 09:00 PM
Re: Relink Oracle ?
upon upgrading OS you need to relink the oracle.
login as oracle
$ cd $ORACLE_HOME/bin
$./relink all
this is needed to link oracle files, since the OS files are relinked after upgrade
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-06-2004 09:31 PM
тАО10-06-2004 09:31 PM
Re: Relink Oracle ?
If you use ldd you will see that a program is linked to libs. For example :
>ldd /bin/ls
/usr/lib/libc.2 => /usr/lib/libc.2
/usr/lib/libdld.2 => /usr/lib/libdld.2
/usr/lib/libc.2 => /usr/lib/libc.2
/usr/lib/libcurses.1 => /usr/lib/libcurses.1
means that ls uses those libs.
When upgrading your OS, many of those libs are changed, so you must relink program to new ones.
Regards,
Fred
"Reality is just a point of view." (P. K. D.)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-07-2004 12:27 PM
тАО10-07-2004 12:27 PM
Re: Relink Oracle ?
When an OS upgrade has occurred, and the Oracle RDBMS is certified for the upgraded version of OS, then relinking Oracle manually has to be done so that the changes in OS binaries will be be updated in Oracle.
Before relinking make sure that:
- /usr/ccs/bin is before /usr/ucb in $PATH
$which ld ....should return '/usr/ccs/bin/ld'
- set LD_LIBRARY_PATH to include $ORACLE_HOME/lib
These are the basic steps in the OS upgrade .
1. Shutdown your Oracle DB and do a full backup of the DB and a full system-
level backup. This allows you to be able to restore in case anything goes wrong during the upgrade.
NOTE: Please make sure to make backup copies of any Oracle-related
files that are not located under $ORACLE_HOME, e.g., oratab,
tnsnames.ora, oraenv.
2. Perform the OS upgrade (see your OS documentation for details).
3. Run "gensyslib" from the "ORACLE_HOME/bin" directory.
4. Relink the Oracle database and any other Oracle Tools and other programs.
When you upgrade the operating system, the version of many OS-level
utilities (such as Motif and the C compiler) may change. Relinking Oracle and your other products makes certain that the database and tools are using the libraries and utilities which are currently on the system.
5. Startup the Oracle database. If all went well, you will NOT need the backup you made before the OS upgrade.
Attached is the document that describes the procedure of "Relink Oracle Database Software on UNIX" on verious versions and releases of RDBMS and OS.
Indira A
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-07-2004 03:03 PM
тАО10-07-2004 03:03 PM
Re: Relink Oracle ?
Nah. Don't bother. It is not worth the hassle/risk.
The critical OS changes are in (dynamic) libraries, and Oracle will pick up those changes automatically (contrary to Fred's earlier reply.)
Only objects from .a libraries are statically linked in and you would need to relink to pick those up but Oracle does not use those. (unfortunately according to some, as it prevent certain link time, and post-link time optimizations).
If anything I would recommend to upgrade Oracle to 9.0.2.x version, as the 9.0.1 was almost like a beta release, notably when using RAC features.
Such upgrade will of course make your relink question a moot point!
Cheers,
Hein.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-12-2004 02:02 AM
тАО10-12-2004 02:02 AM
Re: Relink Oracle ?
You might not have liked my reply (judging by the points :-), but I still believe it to be true and usefull.
- relink is not required.
- 9.0.1.4 is de-supported, relinking will not help that.
The ultimate requirement to relink Oracle or not is of course defined by oracle (typically in a certifiction matrix).
You may want to hit 'metalink' for 'relink'.
You'll find for example Note:131321.1
Subject: "How to Relink Oracle Database Software"
It reads:
"Relinking Oracle manually is suggested under these circumstances:
- An OS upgrade has occurred.
- A change has been made to the OS system libraries. This can occur during the application of an OS patch.
- A new install failed during the relinking phase.
- Individual Oracle executables core dump during initial startup.
The key word for me being 'suggested', not required.
In our labs we just try it. If it works, use it. If it crashes, well there is no choice but to relink.
For better advice, specific OS version and platforms (PA? IPF? Alpha?) would be usefull, but really, only Oracle support can give binding advice.
Cheers,
Hein.