ORACLE11G安装和升级
安装LINUX
ip写入到hosts
vim /etc/selinux/config
yum install oracle-rdbms-server-11gR2-preinstall
自动创建了oracle用户了
创建密码
mkdir -p /u01/app/oracle/product/11.2.0/db_1
chown -R oracle:oinstall /u01
chmod -R 775 /u01
mkdir /software/11.2.0
mkdir /software/11.4.0
unzip linux.x64_11gR2_database_1of2.zip
unzip linux.x64_11gR2_database_2of2.zip
chown -R oracle:oinstall /software/11.2.0/database
chown -R oracle:oinstall /software/11.4.0/database
ls –l
ORACLE_HOSTNAME= oracle11g.local; export ORACLE_HOSTNAME
ORACLE_UNQNAME=orcl; export ORACLE_UNQNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=
O
R
A
C
L
E
B
A
S
E
/
p
r
o
d
u
c
t
/
11.2.0
/
d
b
1
;
e
x
p
o
r
t
O
R
A
C
L
E
H
O
M
E
O
R
A
C
L
E
S
I
D
=
o
r
c
l
;
e
x
p
o
r
t
O
R
A
C
L
E
S
I
D
P
A
T
H
=
ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOME ORACLE_SID=orcl; export ORACLE_SID PATH=
ORACLEBASE/product/11.2.0/db1;exportORACLEHOMEORACLESID=orcl;exportORACLESIDPATH=ORACLE_HOME/bin:
P
A
T
H
;
e
x
p
o
r
t
P
A
T
H
L
D
L
I
B
R
A
R
Y
P
A
T
H
=
PATH; export PATH LD_LIBRARY_PATH=
PATH;exportPATHLDLIBRARYPATH=ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=
O
R
A
C
L
E
H
O
M
E
/
j
l
i
b
:
ORACLE_HOME/jlib:
ORACLEHOME/jlib:ORACLE_HOME/rdbms/jlib; export CLASSPATH
export LANG=CN_em
安装后的检查
tnsnames.ora
OEM检查
emctl status dbconsole
emctl start dbconsole
ORACLE升级 11.2.0.1.0升级到11.2.0.4.0
升级前的查看
tail -1 /etc/oratab
cat /u01/app/oracle/product/11.2.0/db_1/oraInst.loc
cat /u01/app/oraInventory/ContentsXML/inventory.xml
lsnrctl status
Select * from v$version;
Select comp_name,version,status from dba_registry;
创建新的oracle_home目录
mkdir -p /u01/app/oracle/product/11.2.0/db_2
chmod 775 /u01/app/oracle/product/11.2.0/db_2
临时设置oracle_home目录
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_2
echo $ORACLE_HOME
cd /software/11.4.0/database/
export LANG=en_US
升级数据库
/u01/app/oracle/product/11.2.0/db_2/bin/dbua
mkdir -p /u03/app/oracle/fra/rex/backup
chown -R oracle:oinstall /u03
chmod -R 775 /u03
ls -lh /u03/app/oracle/fra/rex/backup/
tail -2 /etc/oratab
cat /u01/app/oraInventory/ContentsXML/inventory.xml
查看admin目录下没有文件
ls -l /u01/app/oracle/product/11.2.0/db_2/network/admin/
把listener和tnsnames文件拷贝到新的oracle_home目录下
cp/u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora /u01/app/oracle/product/11.2.0/db_2/network/admin/
cp/u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora /u01/app/oracle/product/11.2.0/db_2/network/admin/
查看监听状态,不是更新的版本
lsnrctl status
停用监听状态lsnrctl stop
在启用监听
查看监听,版本正确了
OEM版本也正确了
emctl status dbconsole
/u01/app/oracle/product/11.2.0/db_2/bin/rman target /
select instance_name,host_name,status,version from v$instance;
Select comp_name,version,status from dba_registry
Where status <> ‘VALID’;
查看更新
Select
To_char(action_time, ‘DD-MON-YYYY HH:MI:AM’)upgrade_date,
Comments source_version,version target_version
From dba_registry_history
Where action = ‘UPGRADE’;
清除原来的ORACLE_HOME
cd /u01/app/oracle/product/11.2.0/db_1/deinstall/