Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2002
    Posts
    1

    Unanswered: Oracle Installation on Unix

    I have installed Oracle8.1.7 on Solaris 8.

    I ran the runInstaller and created a database with oradb as SID.

    I am unable to connect to this database that i have created.I am trying to connect through SQL PLUS on the server and i get the following error

    ORA-07217: sltln: environment variable cannot be evaluated.

    I have also tried to connect through svrmgrl
    SVRMGR> startup pfile=/usr/oracle/OraHome1/dbs/initORADB.ora
    ORA-07217: sltln: environment variable cannot be evaluated.
    ORA-07217: sltln: environment variable cannot be evaluated.

    Can someone help me with this ASAP

    Regards,
    Archana

  2. #2
    Join Date
    Oct 2002
    Location
    greenwich.ct.us
    Posts
    279
    Your environment variables are messed up. Source either oraenv or coraenv depending on your shell.

  3. #3
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482

    Thumbs up

    It does say clear what is wrong. You have syntax error in some of the Oracle environment variables. Here are the minimum variables to be setup and their spelling. Add your values and try again:

    ORACLE_SID=
    ORACLE_BASE=
    ORACLE_ADMIN=${ORACLE_BASE}/admin/${ORACLE_SID}
    ORACLE_HOME=${ORACLE_BASE}/product/.....
    ORACLE_TERM=
    TNS_ADMIN=
    PATH=${PATH}:${ORACLE_HOME}/bin
    LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:${ORACLE_HOME}/lib

    export ORACLE_BASE ORACLE_SID ORACLE_ADMIN ORACLE_HOME ORACLE_TERM TNS_ADMIN PATH LD_LIBRARY_PATH


    Hope that helps,

    clio_usa
    OCP - DBA

  4. #4
    Join Date
    Oct 2002
    Location
    greenwich.ct.us
    Posts
    279
    Originally posted by clio_usa

    ORACLE_BASE=
    ORACLE_ADMIN=${ORACLE_BASE}/admin/${ORACLE_SID}
    ORACLE_TERM=
    TNS_ADMIN=
    These EVs are not required...

  5. #5
    Join Date
    Jul 2002
    Posts
    11
    Originally posted by marist89
    Your environment variables are messed up. Source either oraenv or coraenv depending on your shell.
    Go to your $ORACLE_HOME/network/admin directory and type
    lsnrctl start

    check if the listener has started by using ps -ef

    Then. type (exactly as below):

    sqlplus /nolog << !
    connect / as sysdba
    startup
    !

    This should open and start the database.
    Make sure that your $ORACLE_SID is the same as the Database that you created.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •