ZestSync

ORA-12547: TNS Lost Contact when running DBCA on Oracle 11g installation on Ubuntu Linux 12.04 64 bi

I'm trying to create a database using DBCA on Oracle 11g installation on Ubuntu Linux 12.04 64 bit.

I followed the instructions here, but I get

ORA-12547: TNS Lost Contact when running DBCA.

Below are the details. Can someone assist with the solution?

  • Instead of using /opt/oracle as the "oracle" user home, I used /home/oracle

  • I did not install the libstdc++5 in 32 bit version

  • I did everything else the same as the posting

  • Installation resulted in "missing packages". I tried to do an apt-get install for these packages from ubuntu, but ubuntu says that they don't exist. Then I saw in the instructions:

    Once you will reach the "pre-reqs" screen, check "Ignore all" to continue the installation.

  • When running ./dbca from $ORACLE_HOME/bin, it fails with ORA-12547.

  • I checked $ORACLE_HOME/network/admin and listener.ora , sqlnet.ora , and tnsnames.ora all look OK.

  • However, I think that tnsnames.ora is not being read properly, because ./tnsping fails and the error message states that "EZ Connect" was used. But in my sqlnet.ora , I have

    names.directory_lookup = (TNSNAMES,EZCONNECT) 

    It should use EZ Connect only after tnsnames is tried.

  • Also, I sometimes get ORA-12541: No listener. I tried running ./netca. Everything is OK until I perform a test on the listener, and it fails.

  • I can't run ./lsnrctl. Absolutely nothing happens for this, as well as lsnrctl start, stop, status.

  • I can't go through sqlplus. If I run ./sqlplus , it asks me for username/password directly.

  • If I do ./sqlplus / as sysdba, then this results in "ORA-12547: TNS lost contact".

  • All environment variables are set correctly in .bashrc.

  • I tried re-running root.sh , but the problem is not fixed.

  • /etc/oratab is OK

  • /etc/hosts is OK, but I can't always ping the "localhost" or "127.0.0.1", or "ubuntu" or "127.0.1.1"

    The same TNS or Listener errors display.

  • 2

    2 Answers

  • When I login in oracle (sqlplus system/pass as sysdba), I got this:

    ERROR:

    ORA-12547: TNS :lost contact when try to connect to Oracle.

  • First, I think the server is down, but I check it, it is OK. And so many body say 'chmod 6751 oracle', I did it, but I got another error:

    ERROR:

    ORA-01031: insufficient privileges

    Enter user-name:

  • finally, I switch the system user from root to oracle. And I login success.

  • Ensure the DB is up and running and you can connect locally AS SYSDBA to the database using Oracle binaries owner (usually oracle:oinstall Unix / Linux user). If it does not work, probably you encounter a different problem. 1. Check privileges of an Oracle file on Unix / Linux host where database is running: cd $ORACLE_HOME/bin ls -ltr oracle 2. Change permissions as below: chmod 6751 oracle ls -ltr oracle This code may help you lot.

    ncG1vNJzZmirpJawrLvVnqmfpJ%2Bse6S7zGiorp2jqbawutJoaG9oZGh%2Ben%2BOqKmaZWFngnWDjK2lrGWcpMC1ecKopa2Zk6l6uLTEp2SrrZ6jtq%2BzjJ2ZnJldpLtuu9GamqWdXWZ%2BqHnIp6qtmZyhrrW1zqdkqKZdqq%2B2ug%3D%3D

    Arica Deslauriers

    Update: 2024-05-21