1 2 Previous Next 20 Replies Latest reply: Jan 31, 2013 6:53 AM by EdStevens Go to original post RSS
      • 15. Re: how can i start the listener if it is not working
        Aman....
        Prakash T Soundaapan wrote:
        (ORACLE_HOME = /u01/app/oracle/ora10g)
        i have given the installation path as e:\oracle11g\administrator\product11.2.0\dataaudit\database\spfileoracl.ora is this the home for me
        can u explain this one please
        For you, this would be the home e:\oracle11g\administrator\product11.2.0\dataaudit . But I am not really sure that how would this help?

        Aman....
        • 16. Re: how can i start the listener if it is not working
          Prakash T Soundappan
          not working padma
          can u suggest me any other
          it is saying me that
          Status          
          Failed
          Details          ORA-12528: TNS:listener: all appropriate instances are blocking new connections (DBD ERROR: OCIServerAttach)
          plese help;
          • 17. Re: how can i start the listener if it is not working
            Chanchal Wankhade
            Hi,
            ORA-12528: TNS: listener: all appropriate instances are blocking new connections 
             
            Cause: All instances supporting the service requested by the client reported that they were blocking the new connections. This condition may be temporary, such as at instance startup.
            
            Action: Attempt the connection again. If error persists, then contact the administrator to check the status of the instances.
            The ORA-12528 is a new error which has begun with Oracle 10g.  Restarting the Oracle instance can solve transient ORA-12528 errors.
            • 18. Re: how can i start the listener if it is not working
              Aman....
              Prakash T Soundaapan wrote:
              not working padma
              can u suggest me any other
              it is saying me that
              Status          
              Failed
              Details          ORA-12528: TNS:listener: all appropriate instances are blocking new connections (DBD ERROR: OCIServerAttach)
              plese help;
              Make documentation your friend, it would
              http://docs.oracle.com/cd/E11882_01/server.112/e17766/net12500.htm#sthref3588

              Try to restart the db and the listener.

              Aman....
              • 19. Re: listener not working
                Prakash T Soundappan
                Girish Sharma wrote:
                Please post the output of below commands (just copy and paste here)
                C:\>set oracle_sid=<your_sid_name>
                
                C:\>set oracle_home=<complete path of oracle home>
                
                like when I says :
                
                C:\>echo %oracle_sid%
                orcl
                
                C:\>echo %oracle_home%
                E:\app\serverroom\product\11.2.0\dbhome_1
                
                C:\>lsnrctl status
                C:\>
                Also post sqlnet.ora, tnsnames.ora and listener.ora which found in $oracle_home\network\admin folder (in mine case these are in E:\app\serverroom\product\11.2.0\dbhome_1\NETWORK\ADMIN). You can use netca utility which is provided by oracle itself to configure listener and tnsname(s).

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

                NL-00853: undefined command "status;". Try "help"

                C:\>lsnrctl status

                LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 31-JAN-2013 16:27
                :40

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

                Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=APPLNSERVER.oomsystech.c
                om)(PORT=1521)))
                STATUS of the LISTENER
                ------------------------
                Alias LISTENER
                Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Produ
                ction
                Start Date 31-JAN-2013 16:11:26
                Uptime 0 days 0 hr. 16 min. 17 sec
                Trace Level off
                Security ON: Local OS Authentication
                SNMP OFF
                Listener Parameter File E:\oracle11g\administrator\product\11.2.0\dataaudit\ne
                twork\admin\listener.ora
                Listener Log File e:\oracle11g\administrator\diag\tnslsnr\APPLNSERVER\li
                stener\alert\log.xml
                Listening Endpoints Summary...
                (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=APPLNSERVER.oomsystech.com)(PORT=152
                1)))
                The listener supports no services
                The command completed successfully

                this is the message iam getting sir can you please help to get rid of it
                thank u
                • 20. Re: listener not working
                  EdStevens
                  Prakash T Soundaapan wrote:
                  Girish Sharma wrote:
                  Please post the output of below commands (just copy and paste here)
                  C:\>set oracle_sid=<your_sid_name>
                  
                  C:\>set oracle_home=<complete path of oracle home>
                  
                  like when I says :
                  
                  C:\>echo %oracle_sid%
                  orcl
                  
                  C:\>echo %oracle_home%
                  E:\app\serverroom\product\11.2.0\dbhome_1
                  
                  C:\>lsnrctl status
                  C:\>
                  Also post sqlnet.ora, tnsnames.ora and listener.ora which found in $oracle_home\network\admin folder (in mine case these are in E:\app\serverroom\product\11.2.0\dbhome_1\NETWORK\ADMIN). You can use netca utility which is provided by oracle itself to configure listener and tnsname(s).

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

                  NL-00853: undefined command "status;". Try "help"

                  C:\>lsnrctl status

                  LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 31-JAN-2013 16:27
                  :40

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

                  Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=APPLNSERVER.oomsystech.c
                  om)(PORT=1521)))
                  STATUS of the LISTENER
                  ------------------------
                  Alias LISTENER
                  Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Produ
                  ction
                  Start Date 31-JAN-2013 16:11:26
                  Uptime 0 days 0 hr. 16 min. 17 sec
                  Trace Level off
                  Security ON: Local OS Authentication
                  SNMP OFF
                  Listener Parameter File E:\oracle11g\administrator\product\11.2.0\dataaudit\ne
                  twork\admin\listener.ora
                  Listener Log File e:\oracle11g\administrator\diag\tnslsnr\APPLNSERVER\li
                  stener\alert\log.xml
                  Listening Endpoints Summary...
                  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=APPLNSERVER.oomsystech.com)(PORT=152
                  1)))
                  The listener supports no services
                  The command completed successfully

                  this is the message iam getting sir can you please help to get rid of it
                  thank u
                  Get rid of what? That looks like a perfectly healthy listener, just waiting for a database instance to register with it.
                  1 2 Previous Next