This discussion is archived
1 2 3 Previous Next 32 Replies Latest reply: Dec 8, 2012 4:04 AM by EdStevens Go to original post RSS
  • 15. Re: Beginners help
    962651 Newbie
    Currently Being Moderated
    Alright, so I gave it a shot and received an error, it's very similar to the other errors I've posted, but permit me to show you the output anyway:
    SQL>Alter database Open Resetlogs;
    Alter database Resetlogs
    *
    Error at line 1:
    ORA-0103: ORACLE not available
    Process ID: 0
    Session ID: 0 Serial number: 0
    So what is my next move now?
  • 16. Re: Beginners help
    962651 Newbie
    Currently Being Moderated
    So what do I do now since I can't execute that line, what else should I try?
  • 17. Re: Beginners help
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    post
    ps -ef | grep pmon
  • 18. Re: Beginners help
    Aman.... Oracle ACE
    Currently Being Moderated
    First, Fedora is not a supported distro for installing Oracle db. So that itself you need to change and switch over to Oracle Linux. You can't run the given command as it seems your db is down . Like Osama mentioned, run the command and it should probably show nothing . If not , try to startup the db by issuing startup mount and post the results.

    Aman....
  • 19. Re: Beginners help
    santosh.. Newbie
    Currently Being Moderated
    Okay firstly, I have no idea what folder to find alert_xe in, but let me show my sqlplus output:
    sql>show parameter dump
    NAME TYPE VALUE
    --------------- --------------- ------------------
    background_dump_dest string /xyz/bdump

    sql>exit
    $cd /xyz/bdump
    $ls -lrt
    $cat alert_xe

    Edited by: st. osh on Nov 27, 2012 10:10 PM
  • 20. Re: Beginners help
    962651 Newbie
    Currently Being Moderated
    Okay, so I have switched which quintessentially is Red Hat incarnate, it seems like the installation went more smoothly
    this time, but now I am getting a new sqlplus error:
    SQL> CONNECT SYS
    Enter password: 
    ERROR:
    ORA-01034: ORACLE not available
    ORA-27101: shared memory realm does not exist
    Linux-x86_64 Error: 2: No such file or directory
    Process ID: 0
    Session ID: 0 Serial number: 0
    
    
    SQL> CONNECT SYSTEM
    Enter password: 
    ERROR:
    ORA-01034: ORACLE not available
    ORA-27101: shared memory realm does not exist
    Linux-x86_64 Error: 2: No such file or directory
    Process ID: 0
    Session ID: 0 Serial number: 0 
    How can this one be solved?
  • 21. Re: Beginners help
    Fran Guru
    Currently Being Moderated
    your database is down.

    sqlplus / as sysdba
    sql> startup
  • 22. Re: Beginners help
    Haafiz Explorer
    Currently Being Moderated
    as yoonus mentioned 11g not certified on fedora.

    here is the installation steps:

    http://www.oracle-base.com/articles/11g/oracle-db-11gr2-installation-on-oracle-linux-6.php

    Edited by: Haafiz on Dec 5, 2012 10:14 PM
  • 23. Re: Beginners help
    jgarry Guru
    Currently Being Moderated
    Be sure your environment has properly set the oracle environment variables. Be sure you are logged in as a non-root user who is part of the dba group. Show us the output of
    env|grep ORA
    This should include at least ORACLE_SID and ORACLE_HOME, and $ORACLE_HOME/bin on the PATH.

    If those are set properly, you should then be able to:
    sqlplus / as sysdba
    startup
  • 24. Re: Beginners help
    962651 Newbie
    Currently Being Moderated
    First of all, thank you for actually giving me some useful advice unlike most who have responded thus far. Okay, so first thing is I've actually switched to CentOS/ Red Hat which I posted but no one payed any attention to my previous post, so when I run sqlplus from terminal I get command not found, I then tried connect / as sysdba, which gave the insufficient privileges error, and the startup command in turn gave me the same thing. Last but not least, here's the output I got from bash:
    [eddie_nygma@localhost ~]$ env ORA
    env: ORA: No such file or directory       
    And whenever I try grep with it, it just buffers for like five minutes straight, so I'm it just froze up, any other keywords I could try besides ORA what do you think?
  • 25. Re: Beginners help
    XBOX Newbie
    Currently Being Moderated
    Hi,

    Your database is Down.

    Post this:-
    $ ps -ef|grep pmon


    $ export ORACLE_HOME
    $ export ORACLE_SID
    $ export PATH= Oracle_Home/bin
    $ sqlplus / as sysdba
    SQL> startup

    Regards,

    Edited by: XBOX on Dec 6, 2012 10:14 AM
  • 26. Re: Beginners help
    EdStevens Guru
    Currently Being Moderated
    959648 wrote:
    First of all, thank you for actually giving me some useful advice unlike most who have responded thus far. Okay, so first thing is I've actually switched to CentOS/ Red Hat which I posted but no one payed any attention to my previous post, so when I run sqlplus from terminal I get command not found, I then tried connect / as sysdba, which gave the insufficient privileges error, and the startup command in turn gave me the same thing. Last but not least, here's the output I got from bash:
    [eddie_nygma@localhost ~]$ env ORA
    env: ORA: No such file or directory       
    And whenever I try grep with it, it just buffers for like five minutes straight, so I'm it just froze up, any other keywords I could try besides ORA what do you think?
    The command is
    env | grep ORA
    That is
    env <pipe symbol> grep ORA
  • 27. Re: Beginners help
    EdStevens Guru
    Currently Being Moderated
    XBOX wrote:
    Hi,

    Your database is Down.

    Post this:-
    $ ps -ef|grep pmon


    $ export ORACLE_HOME
    $ export ORACLE_SID
    Of course, you have to actually set those variables before exporting them, or provide the value with the export ... like this:

    export ORACLE_PATH=/u01/app/oracle/11.2.0/db_1
    export ORACLE_SID=orcl
    $ export PATH= Oracle_Home/bin
    That would be "export PATH=$ORACLE_HOME/bin"

    case matters. Also, either you left off the "$" or jive is stripping it. I'm already seeing a few other 'oddities' on the board this morning.

    $ sqlplus / as sysdba
    SQL> startup

    Regards,

    Edited by: XBOX on Dec 6, 2012 10:14 AM
  • 28. Re: Beginners help
    962651 Newbie
    Currently Being Moderated
    So, it would like seem as though EdStevens has given the most accurate enivronment variable command line syntax so far, but here is the output of every bashsuggestion at this point, succeeded by my sqlplus command output:
    [eddie_nygma@localhost ~]$ su
    Password: 
    su: incorrect password
    [eddie_nygma@localhost ~]$ su
    Password: 
    [root@localhost eddie_nygma]# export ORACLE_HOME
    [root@localhost eddie_nygma]# export ORACLE_SID
    [root@localhost eddie_nygma]# export PATH= Oracle_Home/bin
    bash: export: `Oracle_Home/bin': not a valid identifier
    [root@localhost eddie_nygma]# sqlplus
    bash: sqlplus: No such file or directory
    [root@localhost eddie_nygma]# ps -ef | grep pmon
    bash: ps: No such file or directory
    bash: grep: No such file or directory
    [root@localhost eddie_nygma]# ps -ef|grep pmon
    bash: ps: No such file or directory
    bash: grep: No such file or directory
    [root@localhost eddie_nygma]# export ORACLE_PATH=/u01/app/oracle/11.2.0/db_1
    [root@localhost eddie_nygma]# export ORACLE_SID=orcl
    [root@localhost eddie_nygma]# export PATH=$ORACLE_HOME/bin
    
    SQL*Plus: Release 11.2.0.2.0 Production on Thu Dec 6 23:30:04 2012
    
    Copyright (c) 1982, 2011, Oracle.  All rights reserved.
    
    Use "connect username/password@XE" to connect to the database.
    SQL> startup
    ORA-01031: insufficient privileges
    SQL> connect / as sysdba
    ERROR:
    ORA-01031: insufficient privileges 
    So, I guess in spite of every piece of advice I've been given, I still can't connect or run anything as the SYS or SYSTEM user, so what else could I try.... And please don't tell me to upgrade to Oracle linux, because reason 1, the first time during installation complaints saying that I didn't have disk 2even though I've got no idea what else to download and I do by the way intend to purchase a Red Hat disc very soon, so until then can everyone cut me some slack, tell me it's not unfixable cause I have read success stories with CentOS on these forums, so I really would like to just persist on solving this particular issue, so tell me, in my case what should be my next course of action?
  • 29. Re: Beginners help
    EdStevens Guru
    Currently Being Moderated
    959648 wrote:
    So, it would like seem as though EdStevens has given the most accurate enivronment variable command line syntax so far, but here is the output of every bashsuggestion at this point, succeeded by my sqlplus command output:
    [eddie_nygma@localhost ~]$ su
    Password: 
    su: incorrect password
    [eddie_nygma@localhost ~]$ su
    Password: 
    NO! Do NOT do this as root! Connect to the OS as the owner of the Oracle software installation! That is probably 'oracle'. Burn this into your brain: Never use the 'root' account for anything that does not require root level access. Which is almost nothing.
    [root@localhost eddie_nygma]# export ORACLE_HOME
    [root@localhost eddie_nygma]# export ORACLE_SID
    [root@localhost eddie_nygma]# export PATH= Oracle_Home/bin
    bash: export: `Oracle_Home/bin': not a valid identifier
    Is jive stripping characters from your posting? that space between the equal sign and the word Oracle should be a dollar sign - $. And case matters, it's not Oracle_Home, it's ORACLE_HOME. I pointed that up already. But since you are incorrectly doing this as root ....
    [root@localhost eddie_nygma]# sqlplus
    bash: sqlplus: No such file or directory
    The shell processor cannot find an executable file named 'sqlplus'. Mostly because the directory it is in ($ORACLE_HOME/bin) never got added to the PATH. But since you are incorrectly doing this as root ....
    [root@localhost eddie_nygma]# ps -ef | grep pmon
    bash: ps: No such file or directory
    bash: grep: No such file or directory
    [root@localhost eddie_nygma]# ps -ef|grep pmon
    bash: ps: No such file or directory
    bash: grep: No such file or directory
    [root@localhost eddie_nygma]# export ORACLE_PATH=/u01/app/oracle/11.2.0/db_1
    [root@localhost eddie_nygma]# export ORACLE_SID=orcl
    [root@localhost eddie_nygma]# export PATH=$ORACLE_HOME/bin

    SQL*Plus: Release 11.2.0.2.0 Production on Thu Dec 6 23:30:04 2012

    Copyright (c) 1982, 2011, Oracle. All rights reserved.

    Use "connect username/password@XE" to connect to the database.
    SQL> startup
    Ok, you obviously are not just copying and pasting your terminal session. SQLPlus didn't launch itself without some command. 'Use "connect username/password@XE" to connect to the database.' is not a command to either the shell processor or sqlplus, so if that were part of your terminal session, we would see big time errors.
    ORA-01031: insufficient privileges
    We don't know for sure how you are connected. We know you seem to be asserting with your line "Use "connect username/password@XE" to connect to the database.", but since you chose to strip out the actual start of sqlplus (and possibly other stuff -- how can we know, now that you have demonstrated that you are NOT giving us the full actual output) we cannot know anything about this particular connection beyond the fact that you are NOT connected with sysdba or sysoper privileges.
    SQL> connect / as sysdba
    ERROR:
    ORA-01031: insufficient privileges
    To connect as sysdba, your OS account needs to be a member of the dba group, which root probably is not and certainly should not be.
    So, I guess in spite of every piece of advice I've been given, I still can't connect or run anything as the SYS or SYSTEM user, so what else could I try.... And please don't tell me to upgrade to Oracle linux, because reason 1, the first time during installation complaints saying that I didn't have disk 2even though I've got no idea what else to download
    So why didn't you stop right there and try to solve that problem. I've installed scores of Oracle Linux and never been prompted for a second disk, so there is something suspicious 'from the git-go'.
    and I do by the way intend to purchase a Red Hat disc very soon, so until then can everyone cut me some slack, tell me it's not unfixable cause I have read success stories with CentOS on these forums,
    yes, some people have gotten it to work, but it is still uncertified and unsupported. But your errors are much more fundamental.
    so I really would like to just persist on solving this particular issue, so tell me, in my case what should be my next course of action?
    Be just as persistent about getting the certified OS to install as you seem to be about getting Oracle to work on an UNcertified platform.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points