Fresh 11.3.6 SP8 install, cannot connect to database (data tablespace name cannot be found error)

book

Article ID: 225239

calendar_today

Updated On:

Products

CA Workload Automation AE

Issue/Introduction

11.3.6 SP8 installer on a new server was giving an error:

 

the data tablespace name cannot be found in the Oracle database.

Either specific another data tablespace name or click Back to the

Event SErver Properties panel, and then select Create the 

Tablespace, Database Users, and Roles to continue.

 

 

Cause

Oracle environment was not setup properly before running the install.

 

To arrive at this, we ran the installer in strace mode:

 

1) cd  /the_folder_where_you_have_11.3.6SP8_install

### note, this folder should have the autosys installer script in it now.

2) strace -o /tmp/install_output.txt -f  ./wa_setup.sh

3) Follow the prompts like you were doing earlier,  go until the point where you get the error (do NOT cancel the install yet).  

4) At that point,  from another terminal copy the file /tmp/install_output.txt.  Reviewing this file, showed an error like this:

885  writev(2, [{iov_base="/opt/oraClient/current_version/b"..., iov_len=42}, {iov_base=": ", iov_len=2}, {iov_base="error while loading shared libra"..., iov_len=36}, {iov_base=": ", iov_len=2}, {iov_base="libsqlplus.so", iov_len=13}, {iov_base=": ", iov_len=2}, {iov_base="cannot open shared object file", iov_len=30}, {iov_base=": ", iov_len=2}, {iov_base="No such file or directory", iov_len=25}, {iov_base="\n", iov_len=1}], 10) = 155

1885  exit_group(127)                   = ?

1885  +++ exited with 127 +++

1884  <... wait4 resumed>[{WIFEXITED(s) && WEXITSTATUS(s) == 127}], 0, NULL) = 1885

1884  rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0

1884  --- SIGCHLD {si_signo=SIGCHLD, si_code=CLD_EXITED, si_pid=1885, si_uid=0, si_status=127, si_utime=0, si_stime=0} ---

1884  wait4(-1, 0x7ffd4d96de90, WNOHANG, NULL) = -1 ECHILD (No child processes)

1884  rt_sigreturn({mask=[]})           = 0

1884  rt_sigaction(SIGINT, {sa_handler=0x456da0, sa_mask=[], sa_flags=SA_RESTORER, sa_restorer=0x7fe151e01400}, {sa_handler=0x43e910, sa_mask=[], sa_flags=SA_RESTORER, sa_restorer=0x7fe151e01400}, 8) = 0

1884  exit_group(127)                   = ?

1884  +++ exited with 127 +++

1832  <... read resumed>"", 128)        = 0

1832  --- SIGCHLD {si_signo=SIGCHLD, si_code=CLD_EXITED, si_pid=1884, si_uid=0, si_status=127, si_utime=0, si_stime=0} ---

1832  wait4(-1, [{WIFEXITED(s) && WEXITSTATUS(s) == 127}], WNOHANG, NULL) = 1884

1832  wait4(-1, 0x7ffd4d96e110, WNOHANG, NULL) = -1 ECHILD (No child processes)

1832  rt_sigreturn({mask=[]})           = 0

1832  close(5)                          = 0

1832  rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0

 

 

It appears that the installer was not able to load the libsqlplus.so file and that's why the error

Environment

Release : 11.3.6

Component :

Resolution

Make sure Oracle environment is setup properly before running the installer.

 

To resolve this we did 

ORACLE_HOME=/opt/OraClient/current_version;  export ORACLE_HOME

PATH=$ORACLE_HOME:$ORACLE_HOME/bin:$PATH  ; export PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME:$LD_LIBRARY_PATH; export LD_LIBRARY_PATH

 

then run the installer and connect to the database, did not receive the previous error anymore

Attachments