Results 1 to 10 of 10

Thread: Ora-01034

  1. #1
    Join Date
    Feb 2012
    Posts
    16

    Unanswered: Ora-01034

    Hi folks, I just installed a oracle 11g on a linux enterprise server, everything looks fine but i can't run any SQL command. i get this error:

    SQL> select * from v$instance
    2 ;
    select * from v$instance
    *
    ERROR at line 1:
    ORA-01034: ORACLE not available
    Process ID: 0
    Session ID: 0 Serial number: 0

    but i can login to sql using $ sqlplus as /sysdba

    what can be the problem?

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >what can be the problem?
    Problem Exists Between Keyboard And Chair

    >but i can login to sql using $ sqlplus as /sysdba
    COPY & PASTE whole session like below EXACTLY

    Code:
    bcm@bcm-laptop:~$ id
    uid=1000(bcm) gid=1001(dba) groups=4(adm),20(dialout),24(cdrom),46(plugdev),105(lpadmin),112(netdev),115(admin),122(sambashare),1001(dba)
    bcm@bcm-laptop:~$ sqlplus
    
    SQL*Plus: Release 11.2.0.1.0 Production on Fri Feb 10 11:15:32 2012
    
    Copyright (c) 1982, 2009, Oracle.  All rights reserved.
    
    Enter user-name: / as sysdba
    
    Connected to:
    Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options
    
    SQL> select * from v$version;
    
    BANNER
    --------------------------------------------------------------------------------
    Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
    PL/SQL Release 11.2.0.1.0 - Production
    CORE	11.2.0.1.0	Production
    TNS for Linux: Version 11.2.0.1.0 - Production
    NLSRTL Version 11.2.0.1.0 - Production
    
    SQL> exit
    Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options
    bcm@bcm-laptop:~$
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Feb 2012
    Posts
    16
    Code:
    [oracle@ponta ~]$ id
    uid=501(oracle) gid=501(oinstall) groups=501(oinstall),502(dba),503(oper),504(asmadmin) context=root:system_r:unconfined_t:SystemLow-SystemHigh
    [oracle@ponta ~]$ sqlplus 
    
    SQL*Plus: Release 11.2.0.1.0 Production on Fri Feb 10 21:20:31 2012
    
    Copyright (c) 1982, 2009, Oracle.  All rights reserved.
    
    Enter user-name: / as sysdba
    Connected to an idle instance.
    
    SQL> select * from v$version
      2  ;
    select * from v$version
    *
    ERROR at line 1:
    ORA-01034: ORACLE not available
    Process ID: 0
    Session ID: 0 Serial number: 0
    
    
    SQL>

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    do as below EXACTLY

    env | sort
    sqlplus
    / as sysdba
    startup
    exit

    COPY commands & results then PASTE all back here
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Feb 2012
    Posts
    16
    Code:
    [oracle@ponta ~]$ env | sort
    _=/bin/env
    G_BROKEN_FILENAMES=1
    HISTSIZE=1000
    HOME=/home/oracle
    HOSTNAME=ponta.insitec.co.mz
    INPUTRC=/etc/inputrc
    LANG=en_US.UTF-8
    LESSOPEN=|/usr/bin/lesspipe.sh %s
    LOGNAME=oracle
    LS_COLORS=no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=01;32:*.cmd=01;32:*.exe=01;32:*.com=01;32:*.btm=01;32:*.bat=01;32:*.sh=01;32:*.csh=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.gz=01;31:*.bz2=01;31:*.bz=01;31:*.tz=01;31:*.rpm=01;31:*.cpio=01;31:*.jpg=01;35:*.gif=01;35:*.bmp=01;35:*.xbm=01;35:*.xpm=01;35:*.png=01;35:*.tif=01;35:
    MAIL=/var/spool/mail/oracle
    ORACLE_BASE=/opt/app/oracle
    ORACLE_HOME=/opt/app/oracle/product/11.2.0/dbhome_1/
    ORACLE_SID=/orcl
    PATH=/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/oracle/bin:/opt/app/oracle/product/11.2.0/dbhome_1//bin
    PWD=/home/oracle
    SHELL=/bin/bash
    SHLVL=1
    SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
    TERM=vt100
    USER=oracle
    [oracle@ponta ~]$ sqlplus / as sysdba
    
    SQL*Plus: Release 11.2.0.1.0 Production on Fri Feb 10 21:35:16 2012
    
    Copyright (c) 1982, 2009, Oracle.  All rights reserved.
    
    Connected to an idle instance.
    
    SQL> startup
    ORA-01078: failure in processing system parameters
    LRM-00109: could not open parameter file '/opt/app/oracle/product/11.2.0/dbhome_1/dbs/init/orcl.ora'
    SQL> exit
    Disconnected
    [oracle@ponta ~]$

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >ORACLE_HOME=/opt/app/oracle/product/11.2.0/dbhome_1/
    >ORACLE_SID=/orcl

    not as above, but as below

    ORACLE_HOME=/opt/app/oracle/product/11.2.0/dbhome_1
    ORACLE_SID=orcl
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  7. #7
    Join Date
    Feb 2012
    Posts
    16
    correction done, do i need to restart the server? because is giving me the same error after that correction. Is connecting to an IDLE INSTANCE.

    Code:
    [oracle@ponta ~]$ env | sort
    _=/bin/env
    G_BROKEN_FILENAMES=1
    HISTSIZE=1000
    HOME=/home/oracle
    HOSTNAME=ponta.insitec.co.mz
    INPUTRC=/etc/inputrc
    LANG=en_US.UTF-8
    LESSOPEN=|/usr/bin/lesspipe.sh %s
    LOGNAME=oracle
    LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=             01;05;37;41:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00             ;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.gz             =00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00;3             5:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:
    MAIL=/var/spool/mail/oracle
    ORACLE_BASE=/opt/app/oracle
    ORACLE_HOME=/opt/app/oracle/product/11.2.0/dbhome_1
    ORACLE_SID=/orcl
    PATH=/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/oracle/bin:/opt/app/oracle/product/11.2.0/             dbhome_1//bin:/home/oracle/bin:/opt/app/oracle/product/11.2.0/dbhome_1/bin
    PWD=/home/oracle
    SHELL=/bin/bash
    SHLVL=1
    SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
    TERM=xterm
    USER=oracle
    [oracle@ponta ~]$
    [oracle@ponta ~]$ sqlplus / as sysdba
    
    SQL*Plus: Release 11.2.0.1.0 Production on Sun Feb 12 05:29:56 2012
    
    Copyright (c) 1982, 2009, Oracle.  All rights reserved.
    
    Connected to an idle instance.
    
    SQL> startup
    ORA-01078: failure in processing system parameters
    LRM-00109: could not open parameter file '/opt/app/oracle/product/11.2.0/dbhome_1/dbs/init/orcl.ora'
    SQL>

  8. #8
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >ORACLE_SID=/orcl

    not as above, but as below

    ORACLE_SID=orcl
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  9. #9
    Join Date
    Feb 2012
    Posts
    16
    YYEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEESS SSSSSSSSSsss it's working

    Code:
    [oracle@ponta ~]$ sqlplus / as sysdba
    
    SQL*Plus: Release 11.2.0.1.0 Production on Sun Feb 12 05:57:29 2012
    
    Copyright (c) 1982, 2009, Oracle.  All rights reserved.
    
    
    Connected to:
    Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options
    many thanks Anacedent, U R ************

  10. #10
    Join Date
    Feb 2012
    Posts
    16
    now i can run SQL commands like this

    Code:
    [oracle@ponta ~]$ sqlplus / as sysdba
    
    SQL*Plus: Release 11.2.0.1.0 Production on Sun Feb 12 06:08:08 2012
    
    Copyright (c) 1982, 2009, Oracle.  All rights reserved.
    
    
    Connected to:
    Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options
    
    SQL> select * from v$instance
      2  ;
    
    INSTANCE_NUMBER INSTANCE_NAME
    --------------- ----------------
    HOST_NAME
    ----------------------------------------------------------------
    VERSION           STARTUP_T STATUS       PAR    THREAD# ARCHIVE LOG_SWITCH_WAIT
    ----------------- --------- ------------ --- ---------- ------- ---------------
    LOGINS     SHU DATABASE_STATUS   INSTANCE_ROLE      ACTIVE_ST BLO
    ---------- --- ----------------- ------------------ --------- ---
                  1 orcl
    ponta.insitec.co.mz
    11.2.0.1.0        12-FEB-12 OPEN         NO           1 STOPPED
    ALLOWED    NO  ACTIVE            PRIMARY_INSTANCE   NORMAL    NO
    
    
    SQL>
    Thanks man

Posting Permissions

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