1 2 Previous Next 25 Replies Latest reply: Jun 21, 2011 11:56 AM by 870403 Branched to a new discussion. RSS

    How to start services

    537742
      I need to start tnslsnr (managed to do it) and oracle with orcl database instance. How to do it?
        • 1. Re: How to start services
          Nicolas.Gasparotto
          OS ?
          Oracle version ?
          Maybe are you interest by the documentation reading ?
          http://docs.oracle.com

          Nicolas.
          • 2. Re: How to start services
            Martin Bach
            What if you tried

            $> lsnrctl start listener
            $> ORACLE_SID=orcl; EXPORT ORACLE_SID;
            $> sqlplus " / as sysdba" << EOF
            - startup
            - EOF
            END
            • 3. Re: How to start services
              537742
              Starting /mnt/e/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...

              TNS-12546: TNS:permission denied
              TNS-12560: TNS:protocol adapter error
              TNS-00516: Permission denied
              Linux Error: 13: Permission denied

              What does this mean?
              • 4. Re: How to start services
                Nicolas.Gasparotto
                What OS user are you when you run the command ?

                Nicolas.
                • 5. Re: How to start services
                  537742
                  No matter what user. Even as root I get this error
                  • 6. Re: How to start services
                    27876
                    cleanup all the log and trace files for the listener and login to the system as the user that was used to install the software and create the db. Then try again.
                    • 7. Re: How to start services
                      537742
                      Strange, but though I get error messages, listener seems to be running properly - I can connect to database successfully. Thanks for help
                      • 8. Re: How to start services
                        Nicolas.Gasparotto
                        No matter what user. Even as root I get this error
                        Yes, it does matter. As Kamal said, you need to connect to your server with the user which installed Oracle software (or at least from the same group) which is oracle in most of case. Check if you have right (w,r) for log directory (by default $ORACLE_HOME/network/log).
                        Please, if you can, paste here your listener.ora file.

                        Nicolas.
                        • 9. Re: How to start services
                          537742
                          # listener.ora Network Configuration File: /mnt/e/oracle/product/10.2.0/db_1/network/admin/listener.ora
                          # Generated by Oracle configuration tools.

                          SID_LIST_LISTENER =
                          (SID_LIST =
                          (SID_DESC =
                          (SID_NAME = PLSExtProc)
                          (ORACLE_HOME = /mnt/e/oracle/product/10.2.0/db_1)
                          (PROGRAM = extproc)
                          )
                          )

                          LISTENER =
                          (DESCRIPTION_LIST =
                          (DESCRIPTION =
                          (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
                          (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
                          )
                          )
                          • 10. Re: How to start services
                            Nicolas.Gasparotto
                            Like I asked above : check if you have right (w,r) for log directory (by default $ORACLE_HOME/network/log).
                            Furthermore, please, paste here the result for the following commands :
                            lsnrctl start
                            lsnrctl status
                            Nicolas.
                            • 11. Re: How to start services
                              537742
                              I have rw permissions
                              The problem seems to be in IPC protocol. System denies access to it. If I comment IPC string in listener.ora and leave only TCP one, listener starts properly

                              Results of commads:
                              lsnrctl start

                              LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 08-OCT-2006 13:29:51

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

                              Starting /mnt/e/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...

                              TNSLSNR for Linux: Version 10.2.0.1.0 - Production
                              System parameter file is /mnt/e/oracle/product/10.2.0/db_1/network/admin/listener.ora
                              Log messages written to /mnt/e/oracle/product/10.2.0/db_1/network/log/listener.log
                              Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
                              TNS-12555: TNS:permission denied
                              TNS-12560: TNS:protocol adapter error
                              TNS-00525: Insufficient privilege for operation
                              Linux Error: 1: Operation not permitted

                              Listener failed to start. See the error message(s) above...

                              lsnrctl status

                              LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 08-OCT-2006 13:30:10

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

                              Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
                              TNS-12541: TNS:no listener
                              TNS-12560: TNS:protocol adapter error
                              TNS-00511: No listener
                              Linux Error: 111: Connection refused
                              Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521)))
                              TNS-12541: TNS:no listener
                              TNS-12560: TNS:protocol adapter error
                              TNS-00511: No listener
                              Linux Error: 111: Connection refused
                              • 12. Re: How to start services
                                Nicolas.Gasparotto
                                What is your OS ?
                                What is the owner group for $ORACLE_HOME/bin/lsnrctl ? Is it the same group than the user which launch the listener ?

                                How is your /etc/hosts file ? Is the IP address correct ? Please paste this file here.

                                Nicolas.
                                • 13. Re: How to start services
                                  537742
                                  My OS is Fedora Core 5. I am the owner of lsnrctl (and my group)
                                  /etc/hosts:
                                  127.0.0.1     localhost.localdomain     localhost
                                  • 14. Re: How to start services
                                    Nicolas.Gasparotto
                                    Hmmm, did you know that Oracle has never been supported on Fedora ? This should be only for fun...<br>
                                    Have you follow an installation guide like this one ? It would be help for some particular points.<br>
                                    Or you maybe try to post your question into a more appropriate forum : Generic Linux<br>
                                    <br>
                                    Nicolas.
                                    1 2 Previous Next