Delete / Remove User Account : Error : Creating mailbox file: File exists

[root@test ~]# /usr/sbin/useradd -g oinstall -G dba,oper oracle
Creating mailbox file: File exists
[root@test ~]#

[root@test mail]# pwd
/var/spool/mail

delete oracle file

[root@test mail]# ls -lrt
total 0
-rw-rw----. 1 rpc   mail 0 Feb 21 22:12 rpc
-rw-rw----. 1 54321 mail 0 Feb 22 00:26 oracle
[root@test mail]#
[root@test mail]# cat oracle
[root@test mail]#
[root@test mail]# rm -rf oracle
[root@test mail]#
[root@test mail]# userdel -r oracle
[root@test mail]# /usr/sbin/useradd -g oinstall -G dba,oper oracle
[root@test mail]#

Starting httpd: httpd: apr_sockaddr_info_get() failed for test.dba.com

[root@test repo]# service httpd start
Starting httpd: httpd: apr_sockaddr_info_get() failed for test.dba.com
httpd: Could not reliably determine the server's fully qualified domain name, using 127.0.0.1 for ServerName
                                                           [  OK  ]
[root@test repo]#
[root@test repo]#
[root@test repo]#
[root@test repo]# cd /etc/httpd/
conf/    conf.d/  logs/    modules/ run/
[root@test repo]# cd /etc/httpd/conf.d/
mod_dnssd.conf  php.conf        README          welcome.conf
[root@test repo]# cd /etc/httpd/conf/
httpd.conf  magic
[root@test repo]# cd /etc/httpd/conf/
[root@test conf]# ls
httpd.conf  magic
[root@test conf]#
[root@test conf]# cp httpd.conf httpd.conf_org
[root@test conf]#
[root@test conf]#
[root@test conf]# vi httpd.conf
[root@test conf]#

Changes
# ServerName gives the name and port that the server uses to identify itself.
# This can often be determined automatically, but we recommend you specify
# it explicitly to prevent problems during startup.
#
# If this is not set to valid DNS name for your host, server-generated
# redirections will not work.  See also the UseCanonicalName directive.
#
# If your host doesn't have a registered DNS name, enter its IP address here.
# You will have to access it by its address anyway, and this will make
# redirections work in a sensible way.
#
#ServerName www.example.com:80
ServerName 192.168.0.61(your system ip)



#

[root@test conf]#
[root@test conf]# service httpd stop
Stopping httpd:                                            [  OK  ]
[root@test conf]#
[root@test conf]# service httpd start
Starting httpd:                                            [  OK  ]
[root@test conf]#
[root@test conf]#

[root@test conf]# service iptables stop
iptables: Setting chains to policy ACCEPT: filter          [  OK  ]
iptables: Flushing firewall rules:                         [  OK  ]
iptables: Unloading modules:                               [  OK  ]
[root@test conf]#
[root@test conf]#
[root@test conf]#

Then check from browser 

192.168.0.61

Enjoy!!!!

How to setup a local YUM repository on OEL6

mkdir  -p /var/www/html/oel6

service httpd start

service iptables stop

 cd /media/OL6.5\ x86_64\ Disc\ 1\ 20131125/

 cp -ar . /var/www/html/oel6/

cd /etc/yum.repos.d/

ls
vim oel6.repo

[OEL6DVD]
name=OEL6 DVD hosted locally
baseurl=http://localhost/oel6
enable=1
gpgcheck=0

[root@localhost yum.repos.d]#
[root@localhost yum.repos.d]# cat oel6.repo
[OEL6DVD]
name=OEL6 DVD hosted locally
baseurl=http://localhost/oel6
enable=1
gpgcheck=0
[root@localhost yum.repos.d]#
[root@localhost yum.repos.d]#

---------------------------------------------------------------------
If your repo location different like other mount point
==================================================
[root@test yum.repos.d]#
[root@test yum.repos.d]# cat oel6.repo
[OEL6DVD]
name=OEL6 DVD hosted locally
baseurl=file:///repo/oel6
enable=1
gpgcheck=0

[root@test yum.repos.d]#
[root@test yum.repos.d]#
[root@test yum.repos.d]# df -h
Filesystem                   Size  Used Avail Use% Mounted on
/dev/mapper/vg_test-lv_root  8.3G  5.1G  2.8G  65% /
tmpfs                        2.0G   76K  2.0G   1% /dev/shm
/dev/sda1                    477M   55M  397M  13% /boot
/dev/sdb1                    9.8G  3.7G  5.6G  40% /repo
/dev/sr0                     3.7G  3.7G     0 100% /media/OL6.5 x86_64 Disc 1 20131125
[root@test yum.repos.d]#

yum repolist all



[root@test Packages]#
[root@test Packages]# yum install oracle-rdbms-server-11gR2-preinstall-1.0-7.el6.x86_64.rpm
Loaded plugins: refresh-packagekit, security
Setting up Install Process
Examining oracle-rdbms-server-11gR2-preinstall-1.0-7.el6.x86_64.rpm: oracle-rdbms-server-11gR2-preinstall-1.0-7.el6.x86_64
Marking oracle-rdbms-server-11gR2-preinstall-1.0-7.el6.x86_64.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package oracle-rdbms-server-11gR2-preinstall.x86_64 0:1.0-7.el6 will be installed
--> Processing Dependency: ksh for package: oracle-rdbms-server-11gR2-preinstall-1.0-7.el6.x86_64
--> Processing Dependency: libaio-devel for package: oracle-rdbms-server-11gR2-preinstall-1.0-7.el6.x86_64
--> Running transaction check
---> Package ksh.x86_64 0:20120801-10.el6 will be installed
---> Package libaio-devel.x86_64 0:0.3.107-10.el6 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

========================================================================================================================================================================
 Package                                         Arch              Version                      Repository                                                         Size
========================================================================================================================================================================
Installing:
 oracle-rdbms-server-11gR2-preinstall            x86_64            1.0-7.el6                    /oracle-rdbms-server-11gR2-preinstall-1.0-7.el6.x86_64             32 k
Installing for dependencies:
 ksh                                             x86_64            20120801-10.el6              OEL6DVD                                                           755 k
 libaio-devel                                    x86_64            0.3.107-10.el6               OEL6DVD                                                            13 k

Transaction Summary
========================================================================================================================================================================
Install       3 Package(s)

Total size: 800 k
Total download size: 768 k
Installed size: 1.7 M
Is this ok [y/N]: y
Downloading Packages:
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total                                                                                                                                    23 MB/s | 768 kB     00:00
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing : libaio-devel-0.3.107-10.el6.x86_64                                                                                                                   1/3
  Installing : ksh-20120801-10.el6.x86_64                                                                                                                           2/3
  Installing : oracle-rdbms-server-11gR2-preinstall-1.0-7.el6.x86_64                                                                                                3/3
  Verifying  : oracle-rdbms-server-11gR2-preinstall-1.0-7.el6.x86_64                                                                                                1/3
  Verifying  : ksh-20120801-10.el6.x86_64                                                                                                                           2/3
  Verifying  : libaio-devel-0.3.107-10.el6.x86_64                                                                                                                   3/3

Installed:
  oracle-rdbms-server-11gR2-preinstall.x86_64 0:1.0-7.el6

Dependency Installed:
  ksh.x86_64 0:20120801-10.el6                                                   libaio-devel.x86_64 0:0.3.107-10.el6

Complete!
[root@test Packages]#

Connecting with a user which has SYSDBA privilege, you act like SYS user

bash-3.2$ sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.1.0 Production on Thu Jul 23 11:12:10 2015

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>
SQL>
SQL> show user
USER is "SYS"
SQL>
SQL>
SQL>
SQL> show parameter REMOTE_LOGIN_PASSWORDFILE

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile            string      EXCLUSIVE
SQL>
SQL>

SQL>

SQL> select * from v$pwfile_users;

USERNAME                       SYSDB SYSOP SYSAS

------------------------------ ----- ----- -----

SYS                            TRUE  TRUE  FALSE

SQL>

SQL>

SQL>

SQL> create user admin identified by admin;

User created.

SQL> grant sysdba to admin;

Grant succeeded.

SQL> grant dba to admin;

Grant succeeded.

SQL>

SQL> select * from v$pwfile_users;

USERNAME                       SYSDB SYSOP SYSAS

------------------------------ ----- ----- -----

SYS                            TRUE  TRUE  FALSE

ADMIN                          TRUE  FALSE FALSE

SQL>

SQL>
SQL> grant sysoper to admin;

Grant succeeded.

SQL> select * from v$pwfile_users;

USERNAME                       SYSDB SYSOP SYSAS
------------------------------ ----- ----- -----
SYS                            TRUE  TRUE  FALSE
ADMIN                          TRUE  TRUE  FALSE


SQL>conn admin/admin
SQL> show user
USER is "ADMIN"
SQL>
SQL> select * from v$tablespace;

       TS# NAME                           INC BIG FLA ENC
---------- ------------------------------ --- --- --- ---
         0 SYSTEM                         YES NO  YES
         1 SYSAUX                         YES NO  YES
         4 USERS                          YES NO  YES
         3 TEMP                           NO  NO  YES
         6 EXAMPLE                        YES NO  YES
         5 UNDOTBS2                       YES NO  YES

6 rows selected.

but when you go to shutdown  databasethen use sysdba role

SQL>

SQL> conn admin/admin as sysdba

Connected.

SQL>

SQL> shut immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL>

SQL> conn admin/admin as sysdba
Connected.
SQL> show user
USER is "SYS"
SQL>
SQL>

if use without  as sysdba so you got ora error

SQL>

SQL> conn admin/admin

Connected.

SQL>

SQL> shut immediate

ORA-01031: insufficient privileges

SQL>