1 2 3 Previous Next 32 Replies Latest reply: Dec 8, 2012 6:04 AM by EdStevens Go to original post RSS
      • 15. Re: Beginners help
        962651
        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
          So what do I do now since I can't execute that line, what else should I try?
          • 17. Re: Beginners help
            Osama_Mustafa
            post
            ps -ef | grep pmon
            • 18. Re: Beginners help
              Aman....
              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..
                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
                  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
                    your database is down.

                    sqlplus / as sysdba
                    sql> startup
                    • 22. Re: Beginners help
                      Haafiz
                      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
                        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
                          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
                            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
                              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
                                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
                                  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
                                    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.