1 2 3 Previous Next 42 Replies Latest reply: Nov 18, 2012 4:30 AM by only.ashish99 Go to original post RSS
      • 15. Re: Oracle 11g No listener error
        only.ashish99
        yes now connected to idle instance but this error is coming

        C:\Users\Rajiv>sqlplus / as sysdba

        SQL*Plus: Release 11.2.0.1.0 Production on Sun Nov 18 12:30:37 2012

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

        Connected to an idle instance.

        SQL> startup
        ORA-00119: invalid specification for system parameter LOCAL_LISTENER
        ORA-00132: syntax error or unresolved network name 'LISTENER_ORCL'
        SQL>
        • 16. Re: Oracle 11g No listener error
          Osama_Mustafa
          Oh God what you do with your database

          No do the following :

          open cmd
          sqlplus / as sysdba
          create pfile = 'c:\test.ora' from spfile ;

          modify test.ora by open it on notepad.exe and look for LOCAL_LISTENER parameter and remove everything inside '' its must be like this
          LOCAL_LISTENER=''

          Then

          shutdown immediate ;
          startup pfile='c:\test.ora';
          create spfile from pfile
          • 17. Re: Oracle 11g No listener error
            Osama_Mustafa
            Handle:      only.ashish99
            Status Level:      Newbie
            Registered:      Nov 22, 2008
            Total Posts:      74
            Total Questions:      30 (14 unresolved)
            Name      Ashish Sharma
            Location      Dubai
            Occupation      Oracle Apps 11i Functional consultant


            Close your thread please
            • 18. Re: Oracle 11g No listener error
              only.ashish99
              I hope we r nearby now.

              I followed these steps....some are not successful:

              SQL> create pfile='c:\test.ora' from spfile;

              File created.

              SQL> shutdown immediate;
              ORA-01034: ORACLE not available
              ORA-27101: shared memory realm does not exist
              SQL> startup pfile='c:\test.ora';
              ORACLE instance started.

              Total System Global Area 2538741760 bytes
              Fixed Size 2178416 bytes
              Variable Size 1409286800 bytes
              Database Buffers 1107296256 bytes
              Redo Buffers 19980288 bytes
              Database mounted.
              Database opened.
              SQL> create spfile from pfile;
              create spfile from pfile
              *
              ERROR at line 1:
              ORA-01078: failure in processing system parameters
              LRM-00109: could not open parameter file
              'D:\APP\RAJIV\PRODUCT\11.2.0\DBHOME_1\DATABASE\INITORCL.ORA'

              -----------------------------------------------------------------------------------------------------------------
              After doing this strange thing happening

              connecting through CMD by using only username and pwd i.e. Username/password not with this username/password@orcl

              not connecting with Sql*plus
              • 19. Re: Oracle 11g No listener error
                only.ashish99
                No problem, if u r busy. i will close this thread and mark u helpful surely.

                because my problem is not resolved yet. maybe sumone else help me.

                Thanks a lot for all ur help.
                • 20. Re: Oracle 11g No listener error
                  Osama_Mustafa
                  create spfile from pfie='c:\test.ora';
                  shutdown immediate ;
                  Startup ;
                  Alter system register ;
                  • 21. Re: Oracle 11g No listener error
                    Osama_Mustafa
                    only.ashish99 wrote:
                    No problem, if u r busy. i will close this thread and mark u helpful surely.

                    because my problem is not resolved yet. maybe sumone else help me.

                    Thanks a lot for all ur help.
                    I post your thread because you open threads without close them not because i don't want to help you
                    • 22. Re: Oracle 11g No listener error
                      only.ashish99
                      yES, i did this and now file created in my dbhome\database\spfileorcl

                      but problem still same. connecting using uid/pwd but not with "orcl" host string
                      • 23. Re: Oracle 11g No listener error
                        only.ashish99
                        i was new that time and now i know how to mark people helping me. i havent closed old threads that i didn't know, now i am closing.
                        • 24. Re: Oracle 11g No listener error
                          Osama_Mustafa
                          Now recreate your Listener Using netca Delete old one and create new one .

                          Aftre this COPY & PASTE lsnrctl status
                          • 25. Re: Oracle 11g No listener error
                            only.ashish99
                            after creating new:

                            SID_LIST_LISTENER =
                            (SID_LIST =
                            (SID_DESC =
                            (SID_NAME = orcl)
                            (ORACLE_HOME = D:\app\Rajiv\product\11.2.0\dbhome_1)
                            (PROGRAM = extproc)
                            (ENVS = "EXTPROC_DLLS=ONLY:D:\app\Rajiv\product\11.2.0\dbhome_1\bin\oraclr11.dll")
                            )
                            (SID_DESC =
                            (SID_NAME = CLRExtProc)
                            (ORACLE_HOME = D:\app\Rajiv\product\11.2.0\dbhome_1)
                            (PROGRAM = extproc)
                            (ENVS = "EXTPROC_DLLS=ONLY:D:\app\Rajiv\product\11.2.0\dbhome_1\bin\oraclr11.dll")
                            )
                            )

                            LISTENER =
                            (DESCRIPTION_LIST =
                            (DESCRIPTION =
                            (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.207.160)(PORT = 1521))
                            (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
                            )
                            )

                            ADR_BASE_LISTENER = D:\app\Rajiv
                            • 26. Re: Oracle 11g No listener error
                              Osama_Mustafa
                              Post
                              lsnrctl status
                              • 27. Re: Oracle 11g No listener error
                                only.ashish99
                                C:\Users\Rajiv>lsnrctl status

                                LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 18-NOV-2012 13:23
                                :44

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

                                Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.207.160)(PORT=15
                                21)))
                                STATUS of the LISTENER
                                ------------------------
                                Alias LISTENER
                                Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Produ
                                ction
                                Start Date 18-NOV-2012 13:18:48
                                Uptime 0 days 0 hr. 5 min. 0 sec
                                Trace Level off
                                Security ON: Local OS Authentication
                                SNMP OFF
                                Listener Parameter File D:\app\Rajiv\product\11.2.0\dbhome_1\network\admin\lis
                                tener.ora
                                Listener Log File d:\app\rajiv\diag\tnslsnr\Rajiv-PC\listener\alert\log.
                                xml
                                Listening Endpoints Summary...
                                (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.207.160)(PORT=1521)))
                                (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
                                Services Summary...
                                Service "CLRExtProc" has 1 instance(s).
                                Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
                                Service "orcl" has 1 instance(s).
                                Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
                                The command completed successfully
                                • 28. Re: Oracle 11g No listener error
                                  Osama_Mustafa
                                  you database instance is register now with your listener you must be able to connect regarding to your tnsnames.ora
                                  sqlplus username/password@ORCL not orcl.
                                  ORCL =
                                  (DESCRIPTION =
                                  (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.207.160)(PORT = 1521))
                                  (CONNECT_DATA =
                                  (SERVER = DEDICATED)
                                  (SERVICE_NAME = orcl)
                                  )
                                  )
                                  • 29. Re: Oracle 11g No listener error
                                    only.ashish99
                                    you meas upper letter ORCL, i tried this also

                                    Microsoft Windows [Version 6.1.7601]
                                    Copyright (c) 2009 Microsoft Corporation. All rights reserved.

                                    C:\Users\Rajiv>sqlplus costra/costra@ORCL

                                    SQL*Plus: Release 11.2.0.1.0 Production on Sun Nov 18 13:30:17 2012

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

                                    ERROR:
                                    ORA-28547: connection to server failed, probable Oracle Net admin error