1 Reply Latest reply: May 1, 2007 5:24 AM by Colin'tHart RSS

    ORA-01034: ORACLE not available

    572976
      Hi everybody,
      iam facing a strange poblem post installation.I am using a linux laptop with OS as ferodra core6 and AMD processor.i installed oracle 10G XE server successfully.i even configured the oracle succesfully, but post, iam not able to log on to sql prompt using sqlplus nor wth the browser i.e http://localhost:8080/apex.
      my tnsnames.ora looks like this.
      ----------------------------------------------
      # tnsnames.ora Network Configuration File:

      XE =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.45.24.196)(PORT = 1811))
      (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = XE)
      )
      )

      EXTPROC_CONNECTION_DATA =
      (DESCRIPTION =
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
      )
      (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
      )
      )

      my sqlnet.ora loks like this
      ----------------------
      #This file is actually enerated by netca. But if customers choose to
      #install " Software Only", this file wont exist and without the native
      #authentication, they will not be able to connect to the databse on NT.

      SQLNET.AUTHENTICATION_SERVICES = (NONE)

      my listener.ora looks like this
      -----------------------------

      # listener.ora Network Configuration File:

      SID_LIST_LISTENER =
      (SID_LIST =
      (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /usr/lib/oracle/xe/app/oracle/product/10.2.0/server)
      (PROGRAM = extproc)
      )
      (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = /usr/lib/oracle/xe/app/oracle/product/10.2.0/server)
      (PROGRAM = extproc)
      )
      )

      LISTENER =
      (DESCRIPTION_LIST =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.45.24.196)(PORT = 1811))
      )
      )

      DEFAULT_SERVICE_LISTENER = (XE)


      iam installing using so my .bash_profile looks like this
      --------------------------------------------------------------------------
      # .bash_profile

      # Get the aliases and functions
      if [ -f ~/.bashrc ]; then
      . ~/.bashrc
      fi

      # User specific environment and startup programs

      PATH=$PATH:$HOME/bin

      . /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh
      export PATH
      unset USERNAME
      export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
      export ORACLE_BASE = /usr/lib/oracle
      export ORACLE_SID=XE
      export PATH=$PATH:ORACLE_HOME/bin
      export PATH
      export LD_LIBRARY_PATH=$ORACLE_HOME/lib


      iam able to do tnsping and everthing, but when i am doing an sqlplus to my local i.e sqlplus system/system @XE..i get the follwing error.
      [root@localhost ~]# cat .bash_profile
      # .bash_profile

      # Get the aliases and functions
      if [ -f ~/.bashrc ]; then
      . ~/.bashrc
      fi

      # User specific environment and startup programs

      PATH=$PATH:$HOME/bin

      . /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh
      export PATH
      unset USERNAME
      export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
      export ORACLE_BASE = /usr/lib/oracle
      export ORACLE_SID=XE
      export PATH=$PATH:ORACLE_HOME/bin
      export PATH
      export LD_LIBRARY_PATH=$ORACLE_HOME/lib




      pleaase help ..me iam going sick out of this error.

      Than in advance...waiting for an early positive reply