1 2 Previous Next 25 Replies Latest reply: Jul 8, 2012 3:17 AM by Osama_Mustafa Go to original post RSS
      • 15. Re: ORA-01035
        947152
        C:\Users\ASHISH>sqlplus / as sysdba

        SQL*Plus: Release 11.2.0.1.0 Production on Tue Jul 3 23:12:57 2012

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

        Connected to an idle instance.

        SQL> shutdown
        ORA-01034: ORACLE not available
        ORA-27101: shared memory realm does not exist
        • 16. Re: ORA-01035
          sb92075
          944149 wrote:
          C:\Users\ASHISH>sqlplus / as sysdba

          SQL*Plus: Release 11.2.0.1.0 Production on Tue Jul 3 23:12:57 2012

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

          Connected to an idle instance.

          SQL> shutdown
          ORA-01034: ORACLE not available
          ORA-27101: shared memory realm does not exist
          post tail end (last 200 or so lines) of the alert log file for this instance
          • 17. Re: ORA-01035
            AdamMartin
            Do it again, but instead of typing "shutdown" type "startup".
            • 18. Re: ORA-01035
              947152
              sqlnet log:

              Fatal NI connect error 12505, connecting to:
              (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SID=ashish)(CID=(PROGRAM=C:\app\ASHISH\product\11.2.0\dbhome_2\bin\emagent.exe)(HOST=ASHISH-VAIO)(USER=SYSTEM))))

              VERSION INFORMATION:
                   TNS for 32-bit Windows: Version 11.2.0.1.0 - Production
                   Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 11.2.0.1.0 - Production
              Time: 03-JUL-2012 20:33:25
              Tracing not turned on.
              Tns error struct:
              ns main err code: 12564
              TNS-12564: TNS:connection refused
              ns secondary err code: 0
              nt main err code: 0
              nt secondary err code: 0
              nt OS err code: 0
              • 19. Re: ORA-01035
                jgarry
                This usually means ORACLE_HOME or ORACLE_SID are not set correctly. Since you appear to be on windows, these can be defined in the registry, in your system environment variables, or explicitly in your command window. So look in the registry for all occurences of those, look in your system environment, and display what your command window thinks they are with the set command, in addition to your alert log that sb asked for, and let us know if there are complaints in the event viewer. Also, what windows services with ora in their name are defined? Are you familiar with the utility [url http://psoug.org/reference/oradim.html]oradim?
                • 20. Re: ORA-01035
                  jgarry
                  Sunny kichloo wrote:
                  Login into sqlplus as SYS user and startup the database
                  sqlplus sys/<password> as sysdba
                  
                  SQL>startup
                  C:\>sqlplus sys/thisissurelynotmypassword as sysdba
                  
                  SQL*Plus: Release 11.2.0.2.0 Production on Tue Jul 3 11:03:12 2012
                  
                  Copyright (c) 1982, 2010, Oracle.  All rights reserved.
                  
                  
                  Connected to:
                  Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production
                  
                  
                  SQL>
                  If you don't understand why that worked, you probably should not be giving advice.
                  • 21. Re: ORA-01035
                    Osama_Mustafa
                    If your issue has been solved , please mark it as Answered or update us


                    Br
                    Osama
                    • 22. Re: ORA-01035
                      Sunny kichloo
                      With all respect i knew what i was writing and also as you can see in my next post i told him to use O.S authentication..
                      • 23. Re: ORA-01035
                        947152
                        SQL> STARTUP
                        ORACLE instance started.

                        Total System Global Area 1071333376 bytes
                        Fixed Size 1375792 bytes
                        Variable Size 612368848 bytes
                        Database Buffers 452984832 bytes
                        Redo Buffers 4603904 bytes
                        ORA-03113: end-of-file on communication channel
                        Process ID: 5148
                        Session ID: 191 Serial number: 3

                        here path :C:\app\ASHISH\product\11.2.0\dbhome_2\bin
                        can you tell me how to set variable.
                        • 24. Re: ORA-01035
                          sb92075
                          944149 wrote:
                          SQL> STARTUP
                          ORACLE instance started.

                          Total System Global Area 1071333376 bytes
                          Fixed Size 1375792 bytes
                          Variable Size 612368848 bytes
                          Database Buffers 452984832 bytes
                          Redo Buffers 4603904 bytes
                          ORA-03113: end-of-file on communication channel
                          Process ID: 5148
                          Session ID: 191 Serial number: 3

                          here path :C:\app\ASHISH\product\11.2.0\dbhome_2\bin
                          can you tell me how to set variable.
                          >
                          SQL> STARTUP
                          ORACLE instance started.

                          Total System Global Area 1071333376 bytes
                          Fixed Size 1375792 bytes
                          Variable Size 612368848 bytes
                          Database Buffers 452984832 bytes
                          Redo Buffers 4603904 bytes
                          ORA-03113: end-of-file on communication channel
                          Process ID: 5148
                          Session ID: 191 Serial number: 3

                          here path :C:\app\ASHISH\product\11.2.0\dbhome_2\bin
                          can you tell me how to set variable.
                          additional clues will exist within alert_<SID>.log file
                          • 25. Re: ORA-01035
                            Osama_Mustafa
                            Adding to sb check this doc

                            ORA-03113: End-of-file on Communication Channel Upon Startup of Database [ID 422646.1]
                            DIAGNOSING ORA-3113 ERRORS [ID 1020463.6]


                            Osama ...
                            1 2 Previous Next