8 Replies Latest reply: Sep 17, 2013 7:14 PM by EdStevens RSS

    useradd error during oracle 11g installation

    Aryacool

      Hi,

       

         We arenow moving to RHEL 4 to RHEL 5.3. When creating oracle user we are getting a error

       

      [root@arya ~]# useradd -u 1010 -g oinstall -G dba -d /oraeng/app/oracle/product/11.2.0.1 -m oracle11g

      Creating mailbox file: File exists

      useradd: warning: the home directory already exists.

      Not copying any file from skel directory into it.

       

      Why this useradd warning is coming ?

      it will affect in installation and database creation or it will give error during database operation ?

       

      Regards,

      Arya

        • 1. Re: useradd error during oracle 11g installation
          Asif Muhammad

          Hi Arya,

           

          useradd: warning: the home directory already exists.

          This means the user is already existing in your system.

          Do a :

          ls -l /oraeng/app/oracle/product/11.2.0.1

           

          and you will find the Oracle home already exist for user, Moreover why are you trying to have the Oracle users's OS home on DB Oracle home, this will some time confuse your self. Just simple accept the default installation and have your OS Oracle to /home/oracle, i.e:

          useradd -u 1010 -g oinstall -G dba -d /home/oracle -m oracle11g


          Provide the output of following command if you wish to have '/oraeng/app/oracle/product/11.2.0.1' as your Oracle Home for the User, and we'll advice you.

          ll - /oraeng/app/oracle/product/11.2.0.1

           

          Thanks &

          Best Regards,

          • 2. Re: useradd error during oracle 11g installation
            EdStevens

            Just to clarify something said by the previous responder.

             

            Do not confuse the 'home' directory of the os user 'oracle' with the concept of the ORACLE_HOME directory.

             

            Every user defined on a *nix operating system has a 'home' directory.  By default, this is '/home/<username>'.  And there is rarely, if ever, a reason to change from the default. So when you are installing Oracle, you need a user account from which to run and manage the installation and ensuing DBA activities.  This account is normally called simply 'oracle'.  And just like any other OS account, it's home directory will be '/home/oracle'.

             

            The idea of the ORACLE_HOME directory is the method of designating where the Oracle software is installed.  It has no relationship at all to the 'home directory' of the user ('oracle') doing the installation. 

            • 3. Re: useradd error during oracle 11g installation
              Aryacool

              [root@arya ~]# ls -l /oraeng/app/oracle/product/11.2.0.1

              total 0

               

              Before creating user oracle11g

              [root@arya ~]# cat /etc/passwd

              root:x:0:0:root:/root:/bin/bash

              bin:x:1:1:bin:/bin:/sbin/nologin

              daemon:x:2:2:daemon:/sbin:/sbin/nologin

              adm:x:3:4:adm:/var/adm:/sbin/nologin

              lp:x:4:7:lp:/var/spool/lpd:/sbin/nologin

              sync:x:5:0:sync:/sbin:/bin/sync

              shutdown:x:6:0:shutdown:/sbin:/sbin/shutdown

              halt:x:7:0:halt:/sbin:/sbin/halt

              mail:x:8:12:mail:/var/spool/mail:/sbin/nologin

              news:x:9:13:news:/etc/news:

              uucp:x:10:14:uucp:/var/spool/uucp:/sbin/nologin

              operator:x:11:0:operator:/root:/sbin/nologin

              games:x:12:100:games:/usr/games:/sbin/nologin

              gopher:x:13:30:gopher:/var/gopher:/sbin/nologin

              ftp:x:14:50:FTP User:/var/ftp:/sbin/nologin

              nobody:x:99:99:Nobody:/:/sbin/nologin

              nscd:x:28:28:NSCD Daemon:/:/sbin/nologin

              vcsa:x:69:69:virtual console memory owner:/dev:/sbin/nologin

              pcap:x:77:77::/var/arpwatch:/sbin/nologin

              mailnull:x:47:47::/var/spool/mqueue:/sbin/nologin

              smmsp:x:51:51::/var/spool/mqueue:/sbin/nologin

              rpc:x:32:32:Portmapper RPC user:/:/sbin/nologin

              rpcuser:x:29:29:RPC Service User:/var/lib/nfs:/sbin/nologin

              nfsnobody:x:4294967294:4294967294:Anonymous NFS User:/var/lib/nfs:/sbin/nologin

              sshd:x:74:74:Privilege-separated SSH:/var/empty/sshd:/sbin/nologin

              dbus:x:81:81:System message bus:/:/sbin/nologin

              haldaemon:x:68:68:HAL daemon:/:/sbin/nologin

              avahi-autoipd:x:100:101:avahi-autoipd:/var/lib/avahi-autoipd:/sbin/nologin

              avahi:x:70:70:Avahi daemon:/:/sbin/nologin

              distcache:x:94:94:Distcache:/:/sbin/nologin

              apache:x:48:48:Apache:/var/www:/sbin/nologin

              webalizer:x:67:67:Webalizer:/var/www/usage:/sbin/nologin

              squid:x:23:23::/var/spool/squid:/sbin/nologin

              ntp:x:38:38::/etc/ntp:/sbin/nologin

              named:x:25:25:Named:/var/named:/sbin/nologin

              xfs:x:43:43:X Font Server:/etc/X11/fs:/sbin/nologin

              gdm:x:42:42::/var/gdm:/sbin/nologin

              sabayon:x:86:86:Sabayon user:/home/sabayon:/sbin/nologin

              amanda:x:33:6:Amanda user:/var/lib/amanda:/bin/bash

              ident:x:98:98::/home/ident:/sbin/nologin

              pvm:x:24:24::/usr/share/pvm3:/bin/bash

              quagga:x:92:92:Quagga routing suite:/var/run/quagga:/sbin/nologin

              radvd:x:75:75:radvd user:/:/sbin/nologin

              privoxy:x:73:73::/etc/privoxy:/sbin/nologin

              uuidd:x:101:104:UUID generator helper daemon:/var/lib/libuuid:/sbin/nologin

              ldap:x:55:55:LDAP User:/var/lib/ldap:/bin/false

              radiusd:x:95:95:radiusd user:/home/radiusd:/sbin/nologin

              pegasus:x:66:65:tog-pegasus OpenPegasus WBEM/CIM services:/var/lib/Pegasus:/sbin/nologin

              tomcat:x:91:91:Tomcat:/usr/share/tomcat5:/bin/sh

               

              And after executing the command # useradd -u 1010 -g oinstall -G dba -d /oraeng/app/oracle/product/11.2.0.1 -m oracle11g

               

              only one line added to above

              oracle11g:x:1010:1002::/oraeng/app/oracle/product:/bin/bash

               

              and warning as i posted before

              [root@arya ~]# useradd -u 1010 -g oinstall -G dba -d /oraeng/app/oracle/product -m oracle

              useradd: warning: the home directory already exists.

              Not copying any file from skel directory into it.

               

              Regards,

              Arya

              • 4. Re: useradd error during oracle 11g installation
                Aryacool

                Hi,

                 

                  Thanks for your reply. Ya i am using RHEL V5.3 . In this version no Oracle user as i have posted above. You can get oracle user pre created in ORACLE ENTERPRISE LINUX Versions. For that reason i am creating oracle/oracle11g. And one more thing i think this is user defined i can give any name, if a i am wrong please rectify me.

                 

                I am getting this warning

                [root@arya ~]# useradd -u 1010 -g oinstall -G dba -d /oraeng/app/oracle/product -m oracle

                useradd: warning: the home directory already exists.

                Not copying any file from skel directory into it.

                 

                what about this Not copying any file from skel directory into it.

                 

                Regards,

                Arya

                • 5. Re: useradd error during oracle 11g installation
                  Aryacool

                  Hi,,

                  Any body have any solution to this warning

                   

                  Regards,

                  Arya

                  • 6. Re: useradd error during oracle 11g installation
                    G Srikanth

                    Hi Arya

                     

                    Seems like you have /oraeng/app/oracle/product directory created already and hence it giving the above warning. try deleting product folder and run the command again.

                     

                    Thank you

                     

                    REgards

                    G Srikanth

                    • 7. Re: useradd error during oracle 11g installation
                      jgarry

                      Ed gave you the solution, don't try to add a user home to ORACLE_HOME.

                      • 8. Re: useradd error during oracle 11g installation
                        EdStevens

                        Aryacool wrote:

                         

                        Hi,

                         

                          Thanks for your reply. Ya i am using RHEL V5.3 . In this version no Oracle user as i have posted above. You can get oracle user pre created in ORACLE ENTERPRISE LINUX Versions. For that reason i am creating oracle/oracle11g. And one more thing i think this is user defined i can give any name, if a i am wrong please rectify me.

                         

                        I am getting this warning

                        [root@arya ~]# useradd -u 1010 -g oinstall -G dba -d /oraeng/app/oracle/product -m oracle

                        useradd: warning: the home directory already exists.

                        Not copying any file from skel directory into it.

                         

                        what about this Not copying any file from skel directory into it.

                         

                        Regards,

                        Arya

                         

                        Yes, you can make the username anything you like.  But just because something can be done doesn't meant it should be done.  The entire Oracle world assumes that the owner of the software is named 'oracle'.  Every piece of documentation, every blog, every example procedure.  Naming it something else will just lead to eternal confusion on your part.  Especially since you are a newbie and struggling with the very basics.

                         

                        And I say again, there is (should be) no connection whatsoever between the home directory of the said 'oracle' user and the concept of the ORACLE_HOME directory.  In your useradd command you are trying to assign the directory that is pretty obviously ORACLE_HOME as the home directory for user 'oracle'.  Not a good idea.

                         

                        Thousands of people have successfully installed oracle on their first try by simply following - to the letter - the instructions in the Installation Guide (not someone's blog, but Oracle's own documentation found at docs.oracle.com).  You are running into trouble because you are trying to get creative.