Oracle 12c Installation method and some usage problems _oracle

Install oracle12c under Linux Centos6.5 64bit:

Groupadd oinstall
groupadd dba
mkdir-p/u01/oracle useradd-g oinstall-g dba-d
Oracle
(not Be sure to change the home directory to/u01/oracle, which is also available by default. )
Copy the following three files to the/u01/oracle directory
[root@oracle/]# cd/etc/skel/[root@oracle skel]# ll-a-rw-r--r
--. 1 root Root 18 July 2013. Bash_logout
-rw-r--r--. 1 root root 176 July 2013 Bash_profile-rw-r--r
--. 1 root root 124 July 2013. BASHRC
Note: useradd When adding a user, automatically copies the files from this directory to the user's home directory
password Oracle
chown-r oracle:oinstall/u01< C14/>chmod-r 775/u01/

/* Install vnc*/

Yum-y Install Tigervnc-server
vncserver return
input password
ps-ef | grep vnc vnc
Client Connection: ip:1

Detect if any of the following programs are installed:

binutils-2.17.50.0.6
compat-libstdc++-33-3.2.3-
elfutils-libelf-0.125
elfutils-libelf-devel-0.125-
elfutils-libelf-devel-static-0.125-
gcc-4.1.2-
gcc-c++-4.1.2-
glibc-2.5-24
glibc-common-2.5
glibc-devel-2.5
glibc-headers-2.5
kernel-headers-2.6.18
ksh-20060214-
libaio-0.3.106
libaio-devel-0.3.106-
libgcc-4.1.2
libgomp-4.1.2
libstdc++-4.1.2
libstdc++-devel-4.1.2-
make-3.81
sysstat-7.0.2 
unixODBC-2.2.11-
unixodbc-devel-2.2.11-

Modify the/etc/sysctl.conf file, plus the following parameters

FS.AIO-MAX-NR = 1048576
Fs.file-max = 6815744
kernel.shmall = 2097152 Kernel.shmmax
= 536870912
Kernel.shmmni = 4096
Kernel.sem = 32000 128 Net.ipv4.ip_local_port_range
= 9000
65500 Net.core.rmem_default = 262144
Net.core.rmem_max = 4194304
net.core.wmem_default = 262144
Net.core.wmem_max = 1048586

For the above configuration to take effect without restarting the system, execute the following command
#/sbin/sysctl-p

Modify User Restrictions

Root User: Modify the/etc/security/limits.conf file, plus the following parameter

Oracle   Soft Nproc 2047
Oracle   hard nproc 16384
Oracle   soft nofile 1024
Oracle   hard Nofile 65536

Modify user authentication Options
Under root: Modify the/etc/pam.d/login file plus the following parameters

Session Required  pam_limits.so

modifying user Profiles
Under root: Modify the/etc/profile file to add the following parameters:

if [$USER = "Oracle"]; Then
  if [$SHELL = "/bin/ksh"]; then
    ulimit-p 16384 ulimit-n 65536
  Else
    ulimit-u 16384-n 655 and
  fi
fi.

To modify Oracle User bash_profile:
$ vi. Bash_profile
Add the following content, mainly to modify

Export oracle_base=/u01 
export oracle_home= $ORACLE _base/product/12.1.0/db_1
export oracle_sid=hxw168 
Export path= $ORACLE _home/bin: $PATH: $HOME/bin

Install Oracle:

Install Oracle cannot use command/usr/bin/xdpyinfo to automatically check display colors:

[Root@oracle/]# Xdpyinfo | grep "Name of display"
name of Display:: 1.0
[root@oracle/]# 
execute command under Oracle User:
export display=:1.0 (above name of display: After: 1.0)

PRVF-0002: Unable to retrieve local section roll name

Host file IP and name correspond
192.168.198.188 Oracle

Sql> Create user admin identified by Zerostudy;
Create user admin identified by Zerostudy
*
ERROR at line 1:
Ora-65096:invalid common user or role name

sql>!oerr ora 65096
65096, 00000, "Invalid common user or role name"
*cause:an attempt is made to create a common user or role with a name
That is wass not valid for common users or roles. In addition to
The usual rules for user and role names, common user and role
Names must start with c## or c## and consist only of ASCII
Characters.
*action:specify a valid common user or role name.
//

Workaround: http://www.jb51.net/article/92720.htm

Adjust virtual machine memory to more than 600 m (originally 1G), prompt when starting Oracle:
Sql> Startup
Ora-00845:memory_target not supported on this system

sql>!oerr ora 00854
00854, 00000, "ASM ioserver Instance Fence Monitor process terminated."
*cause:the ASM ioserver Fence Monitor process died.
*action:warm start the instance.

The reason is that the SHM size of the Linux system is smaller than the SGA settings.
The size of the SHM can be adjusted:
Vi/etc/fstab
Modify the settings for the following line
TMPFS/DEV/SHM TMPFS Defaults 0 0
Change into
Tmpfs/dev/shm Tmpfs defaults,size=6g 0 0
Re-mount the SHM to make it effective
Mount-o REMOUNT/DEV/SHM

Tns-12514:tns:listener does not currently know of service requested in Connect descriptor

You need to change the Listener.ora file (heel in $oracle_home/network/admin) and restart the Lsnrctl

# Generated by Oracle configuration tools.
#LISTENER =
# (description_list = # (DESCRIPTION = # (address  = (PROTOCOL = IPC) (KEY = EXTPROC1521))
#  (address = (PROTOCOL = TCP) (HOST = 192.168.198.188) (PORT = 1521)) #)
hxw168 =
 (description_l IST =
 (DESCRIPTION = (Address
  = (PROTOCOL = TCP) (HOST = 192.168.198.188) (PORT = 1521))
 )
 sid_ list_hxw168=
 (sid_list = (
 sid_desc=
  (oracle_home =/u01/app/product/12.1.0/db_1)
  (sid_name = hxw168)
 )
 )

Oracle Simple startup script:

[Root@oracle ~]# cat/etc/init.d/oracle 
su-oracle <<eof lsnrctl
start
sqlplus/as sysdba Startup
EOF

This article comes from "although wrong, let me be wrong to die!" "Blog