| |
Comment:
A graphical interface is not open Linux OS, how to install Oracle software and databases, as is a large step 2
Cloning software
Building a database manually
First, cloning software
1, the basic configuration
1.1) system package installation
yum -y install binutils compat-libstdc ++ - 33 compat-libstdc ++ - 33.i686 elfutils-libelf elfutils-libelf-devel gcc gcc-c ++ glibc glibc.i686 glibc-common glibc-devel glibc-devel.i686 glibc-headers ksh libaio libaio .i686 libaio-devel libaio-devel.i686 libgcc libgcc.i686 libstdc ++ libstdc ++ i686 libstdc ++ -. devel make sysstat unixODBC unixODBC-devel
1.2) user-created
groupadd oinstall
groupadd dba
useradd -g oinstall -G dba oracle
passwd oracle
1.3) configuration file
1.3.1) environment variables
vi ~ oracle / .bash_profile
export ORACLE_BASE = / data / app / oracle
export ORACLE_HOME = $ ORACLE_BASE / product / 11.2.0.4 / db_1
export ORACLE_SID = test # up to 8 characters; link oracle operating system and the associated instance; ORACLE_HOME + ORACLE_SID ==> hash ==> shared memory segment
export PATH = $ PATH: $ HOME / bin: $ ORACLE_HOME / bin # the command after the installation of oracle appended to the execution search path
export LD_LIBRARY_PATH = $ ORACLE_HOME / lib: / lib: / usr / lib # dynamic library location
export nls_lang = "SIMPLIFIED CHINESE_CHINA.ZHS16GBK" # client character set
# Load a configuration: oracle user logs off or log back on source .bash_profile
1.3.2) Host
echo "10.240.1.7 Database-backup" >> / etc / hosts # error ORA-00000 while avoiding being given startup noumount: normal, successful completion
1.3.3) software directory
mkdir -p /data/app/oracle/product/11.2.0.4/db_1
chown -R oracle: oinstall / data / app
1.3.4) resource constraints
1.3.4,1) vim /etc/sysctl.conf added to the file at the bottom of
kernel.shmall = 2097152
#Total Amount of shared memory available (bytes or pages); number of pages; 2097152 * 4096/1024/1024/1024 = 8G; if memory than 8G, this parameter must be modified
kernel.shmmax = 2147483648
# To> = half Maximum size of physical memory of shared memory segment (bytes); recommendations> = sga_max_size (oracle application memory size);
# Single program memory segment maximum number; 4G, then divided into two mem_seg1 mem_seg2, affecting the efficiency;
kernel.shmmni = 4096
# Maximum number of shared memory segments system-wide; page size;
kernel.sem = SEMMSL SEMMNS SEMOPM SEMMNI
The maximum signal of the target object sets each signal number; SEMMSL Maximum number of semaphores per set
SEMMNS Maximum number of semaphores system-wide; the maximum number of objects in the system-wide signal; SEMMNS = SEMMSL * SEMMNI
The maximum number of operations of each signal object supports SEMOPM
SEMMNI Maximum number of semaphore identifiers; set system-wide maximum number of semaphore object
fs.file-max # system allowed the maximum number of file handles
IPv4 port range net.ipv4.ip_local_port_range # application that can be used
net.core.rmem_default # socket receive buffer size defaults
net.core.rmem_max # maximum socket receive buffer size
net.core.wmem_default # socket send buffer size defaults
Net.core.wmem_max # maximum socket send buffer size
# Note: OS32bit, oracle application up to 1.7G; should be installed 64bitOS
# Sysctl -p parameter to load
1.3.4, 2) /etc/security/limits.conf oracle on linux operating limit
[Root @ dba ~] # grep -v '^ #' /etc/security/limits.conf
oracle soft nproc 2047 #oracle open proc amount on linux
oracle hard nproc 16384
oracle soft nofile 1024 #oracle number of open file on linux
oracle hard nofile 65536
[Root @ dba ~] # grep 'limit' /etc/pam.d/system-auth
session required pam_limits.so
1.3.4,3) turn off the firewall, SELINUX
iptables -F
Change / etc / selinux / config file -> SELINUX = disabled
2 cloned ORACLE_HOME
2.1) Copy
scp db_1 oracle@10.240.1.7: /data/app/oracle/product/11.2.0.4/db_1/
2.2) Executive clone.pl clone script to change the configuration parameters (ORACLE_SID, ORACLE_HOME)
$ Cd /data/app/oracle/product/11.2.0.4/db_1/clone/bin
$ Ls
clone.pl prepare_clone.pl
$ Perl clone.pl ORACLE_SID = test ORACLE_BASE = / data / app / oracle ORACLE_HOME = / data / app / oracle / product / 11.2.0.4 / db_1 / ORACLE_HOME_NAME = OraDb11g_home1
....... Finally following message said cloning success ...
The following configuration scripts need to be executed as the "root" user.
/data/app/oracle/product/11.2.0.4/db_1/root.sh
To execute the configuration scripts:
1. Open a terminal window
2. Log in as "root"
3. Run the scripts
The cloning of OraDb11g_home1 was successful.
...................
Second, building a database manually
1, the configuration parameter file (a simple test environment parameters, if demand can be added)
[Oracle @ Database-backup dbs] $ cat inittest.ora
db_name = test
db_files = 80
db_file_multiblock_read_count = 8
log_checkpoint_interval = 10000
processes = 50
parallel_max_servers = 5
log_buffer = 32768
max_dump_file_size = 10240 # limit trace file size to 5 Meg each
global_names = TRUE
#control_files = (ora_control1, ora_control2)
sga_max_size = 300M
sga_target = 300M
* .local_listener = '(ADDRESS_LIST = (Address = (Protocol = tcp) (Host = 10.240.1.7) (Port = 1521)))' # avoid starting a database error (ORA-00119ORA-00130 local_listener configuration is invalid)
[Oracle @ Database-backup dbs] $
2, start the database to nomount
SQL> startup nomount
ORACLE instance started.
Total System Global Area 313159680 bytes
Fixed Size 2252824 bytes
Variable Size 104861672 bytes
Database Buffers 201326592 bytes
Redo Buffers 4718592 bytes
SQL>
3, create a database, to the open state
SQL> CREATE DATABASE test
USER SYS IDENTIFIED BY change_on_install
USER SYSTEM IDENTIFIED BY manager
LOGFILE GROUP 1 ( '/data/app/dbf/redo01.log') SIZE 100M,
GROUP 2 ( '/data/app/dbf/redo02.log') SIZE 100 M,
GROUP 3 ( '/data/app/dbf/redo03.log') SIZE 100 M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 1
CHARACTER SET GBK
NATIONAL CHARACTER SET AL16UTF16
DATAFILE '/data/app/dbf/system01.dbf' SIZE 325M REUSE
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/data/app/dbf/sysaux01.dbf' SIZE 325 M REUSE
DEFAULT TABLESPACE users datafile '/data/app/dbf/users.dbf' size 50m
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE '/data/app/dbf/temp01.dbf'
SIZE 20 M REUSE
UNDO TABLESPACE undotbs
DATAFILE '/data/app/dbf/undotbs01.dbf'
SIZE 200 M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
Database created.
SQL>
4. Verify that the database state
SQL> select status from v $ instance;
STATUS
------------
OPEN
SQL>
5, the DBF settings automatically extended later to avoid the execution of the script to load the data dictionary table / pack / user space shortage when scott
alter database datafile 1 autoextend on;
alter database datafile 2 autoextend on;
alter database datafile 3 autoextend on;
alter database datafile 4 autoextend on;
6. Create a data dictionary / pack / scott user
Data dictionary views: @ / rdbms / admin / catalog.sql?
System package / stored procedure:? @ / Rdbms / admin / catproc.sql
Users PROFILE table:? @ / Rdbms / admin / pupbld.sql
Test user scott: @ / rdbms / admin / scott.sql?
Above has been completed and the software installed oracle database.
Organize and improve the problem
1, ***** sqlplus / as sysdba prompted not libclntsh.so.11.1 files found
[Oracle @ Database-backup ~] $ sqlplus / as sysdba
sqlplus: error while loading shared libraries: libclntsh.so.11.1: can not open shared object file: No such file or directory
[Oracle @ Database-backup lib] $ ls libclntsh.so *
libclntsh.so libclntsh.so.10.1 -> Only 10.1 cp -rp complete copy of the joint property, may be normal if libclntsh.so.11.1 file permissions problem.
[Oracle @ Database-backup lib] $ cp -rp libclntsh.so.10.1 libclntsh.so.11.1
[Oracle @ Database-backup lib] $ sqlplus / as sysdba
... Normal.
2, for the sys password
orapwd file = orapwtest password = test
3, ORA-00904: "wm_concat": invalid identifier
Create a user script execution WMSYS
SQL> @? / Rdbms / admin / owmctab.plb
SQL> @? / Rdbms / admin / owmaggrs.plb
SQL> @? / Rdbms / admin / owmaggrb.plb |
|
|
|