HTTP-503 ORA-12538

We got "HTTP-503 ORA-12538" error in error_log_pls located in "$APACHE_TOP/Apache/log" folder.

This instance is a clone instance and after completing the adcfgclone we tried to login to the instance with the sysadmin user credentials.

The login page is appearing, after entering the credentials and clicking on login button, we got the following error,

Service Temporarily UnavailableThe server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later.

Searched Aapche access_log and error_log.

error_log has " request failed: URI too long" error message

error_log_pls has "HTTP-503 ORA-12538"
ORA-12538
TNS: no such protocol adapter
Metalink NoteID to be followed : 152580.1
And executed the following commands on the applications tier after sourcing the environment file of Application Tier.

export ORACLE_HOME=$IAS_TOP
cd $ORACLE_HOME/bin
./gennttab
cd $ORACLE_HOME/network/lib
make -f ins_net_client.mk ntcontab.o
cd $ORACLE_HOME/bin
./genclntsh
cd $ORACLE_HOME/network/lib
make -f ins_net_client.mk install
make -f ins_net_server.mk install
cd $ORACLE_HOME/sqlplus/lib
make -f ins_sqlplus.mk install

Before executing the above commands, execute "slibclean" to cleanup the library files held by the AIX kernel. "Slibclean" needs to be run from the "root" account.

Verification

1.

$ adapters ./sqlplus
Net8 Protocol Adapters linked with ./sqlplus are:
BEQ Protocol Adapter
IPC Protocol Adapter
TCP/IP Protocol Adapter
RAW Protocol Adapter

2.

Also verify the size of libclntsh.o located under $IAS_TOP/lib. It should have latest time stamp as well as the size should match with other instances.

3.

Verify the output of the commands executed before. Incase any command fails with TIMEOUT error then re-execute it.

No comments: