23
Aug

Error on libdb Library Starting Oracle EBS Application Services on Linux Platforms

Error :

While starting the application services, Apache services do not start.

Error in the log file:
/dap01/appldev/EBSDEV/apps/tech_st/10.1.3/Apache/Apache/bin/httpd: error while loading shared libraries: libdb-4.3.so: cannot open shared object file: No such file or directory

Cause:

This is caused by having an older Oracle HTTP Server installed on a newer Operating System. For the OPatch issue, Perl is expecting to find the /usr/lib/libdb-3.3.so library, but it is missing.
The following command locates a higher version of the library (for example, /usr/lib/libdb-4.1.so)

/libdb ls -al /usr/lib *.so
 
Note that the error can be a newer library, depending which is found and used from the operating system. (e.g., libdb-4.2.so, libdb-4.3.so, libdb-4.4.so, etc).

The correct libdb filename to use should depend on output of ldd httpd, for example:


cd $ORACLE_HOME/Apache/Apache/bin
ldd httpd | grep libdb
libdb.so.2 => /usr/lib/libdb.so.2 (0x00868000)

•In this case, libdb.so.2 is expected
•In this case, having libdb-3.3.so will not help

Read more...

12
Jan

Database Link

What is a database link?

A database link is a pointer that defines a one-way communication path from one Oracle Database to another database. A database link allows local users to access data on a remote database.

The following link types are supported:
Private database link- belongs to a specific schema of a database. Only the owner of a private database link can use it.
Public database link- all users in the database can use it.
Global database link- defined in an OID or Oracle Names Server. Anyone on the network can use it.

Read more...

Back to Top