Centos5.10中 64位静默安装oracle10g 升级10.2.0.5.12方法

同步时间

cp /usr/share/zoneinfo/Asia/Shanghai /etc/localtime
crontab -e
0-59/10 * * * * /usr/sbin/ntpdate us.pool.ntp.org | logger -t NTP
ntpdate  us.pool.ntp.org
hwclock -w
设置本地DVD 为源:

mkdir /mnt/cdrom
mount /dev/cdrom /mnt/cdrom
#添加本地源

cat >>/etc/yum.repos.d/CentOS-Base.repo<<EOF
[local-cdrom-media]
name=CentOS-$releasever - Media
baseurl=file:///mnt/cdrom/
gpgcheck=1
enabled=0
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-beta
EOF
#注意可能会碰到如下报错信息
Public key for *****.rpm is not installed
#其实此时要导入rpm的签名信息即可
以root登录，执行下面命令
# rpm –import /etc/pki/rpm-gpg/RPM-GPG-KEY-redhat-release
根据我的Linux版本是CentOS 5.10
于是我执行下面命令
#rpm –import /etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-5
#本地安装的方法

yum --disablerepo=* --enablerepo=local-cdrom-media install screen lrzsz -y
1、安装Oracle所需软件包[直接网络方式]
yum install avahi-compat-libdns_sd.x86_64 compat-db.i386 compat-db.x86_64 compat-gcc-34.x86_64 compat-gcc-34-c++.x86_64 compat-gcc-34-g77.x86_64 compat-glibc.i386 compat-glibc.x86_64 compat-glibc-headers.x86_64 compat-libf2c-34.x86_64 compat-libgcc-296.i386 compat-libstdc++-296.i386 compat-libstdc++-33.i386 compat-libstdc++-33.x86_64 java-1.4.2-gcj-compat.x86_64 elfutils-libelf.i386 elfutils-libelf-devel.x86_64 elfutils-libelf-devel-static.x86_64 compat-glibc.x86_64 glibc-devel.i386 glibc-devel.x86_64 glibc-headers.x86_64  glibc.x86_64 glibc.i686 kernel-headers.x86_64 libaio.i386  libaio.x86_64 libaio-devel.i386 libaio-devel.x86_64 libstdc++-devel.i386 libXp.i386 libXp.x86_64  libXpm.x86_64 sysstat.x86_64 readline-devel.x86_64 openssl-devel -y

[DVD本地源安装]

 

yum --disablerepo=* --enablerepo=local-cdrom-media install avahi-compat-libdns_sd.x86_64 compat-db.i386 compat-db.x86_64 compat-gcc-34.x86_64 compat-gcc-34-c++.x86_64 compat-gcc-34-g77.x86_64 compat-glibc.i386 compat-glibc.x86_64 compat-glibc-headers.x86_64 compat-libf2c-34.x86_64 compat-libgcc-296.i386 compat-libstdc++-296.i386 compat-libstdc++-33.i386 compat-libstdc++-33.x86_64 java-1.4.2-gcj-compat.x86_64 elfutils-libelf.i386 elfutils-libelf-devel.x86_64 elfutils-libelf-devel-static.x86_64 compat-glibc.x86_64 glibc-devel.i386 glibc-devel.x86_64 glibc-headers.x86_64  glibc.x86_64 glibc.i686 kernel-headers.x86_64 libaio.i386  libaio.x86_64 libaio-devel.i386 libaio-devel.x86_64 libstdc++-devel.i386 libXp.i386 libXp.x86_64  libXpm.x86_64 sysstat.x86_64 readline-devel.x86_64 openssl-devel -y
2、修改系统版本
vi /etc/redhat-release
redhat-4
#CentOS release 5.7 (Final)
3、修改内核参数

cat >>/etc/sysctl.conf<<EOF
#for oracle10G
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 655360
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default=1048576
net.core.rmem_max=1048576
net.core.wmem_default=262144
net.core.wmem_max=262144
EOF

cat >>/etc/security/limits.conf<<EOF
#for oracle10G
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
EOF

#32位
cat>>/etc/pam.d/login<<EOF
#for oracle10G
session required /lib/security/pam_limits.so
EOF
 
#64位
cat>>/etc/pam.d/login<<EOF
#for oracle10G
session required /lib64/security/pam_limits.so
EOF
注意：如果你的操作系统是x64的则为session required /lib64/security/pam_limits.so
否则系统拒绝登录
然后sysctl -p 应用系统参数。
如果是c shell，则环境变量文件 /etc/csh.login的修改值如下（此处若不确定，跳过）:
if ( ＼$USER == "oracle" ) then
limit maxproc 16384
limit descriptors 65536
umask 022
endif
4 ，在/etc/profile里添加如下行
vim /etc/profile

#for oracle10G
export LIBXCB_ALLOW_SLOPPY_LOCK=true
if [ $USER = "oracle" ]; then
    if [ $SHELL = "/bin/ksh" ]; then
        ulimit -p 16384
        ulimit -n 65536
    else   
        ulimit -u 16384 -n 65536
    fi
        umask 022
fi
EOF
使用命令source profile使环境变量生效
source /etc/profile
5，建立安装Oracle需要的用户、组及目录
(1)新增组和用户：

groupadd oinstall
groupadd dba
useradd -g oinstall -G dba oracle
passwd oracle
创建目录

mkdir -p /u01/app/oracle/product/10.2.0/db_1
chown -R oracle.oinstall /u01
chmod -R 755 /u01
创建oracle profile文件
#注意切换 oracle 用户

su – oracle
vim /home/oracle/.bash_profile
 
#Oracle Settings umask 022;
export ORACLE_BASE=/u01/app/oracle;
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1;
export ORACLE_SID=orcl;
export NLS_LANG='simplified chinese_china.ZHS16GBK'
export PATH=$ORACLE_HOME/bin:$PATH;
export LANG=en_US.UTF-8
 
if [ $USER = "oracle" ]; then
    if [ $SHELL = "/bin/ksh" ]; then
        ulimit -p 16384
        ulimit -p 65536
    else
        ulimit -u 16384 -n 65536
    fi
    umask 022
fi
 
source .bash_profile
然后再设置本地字符集型export LANG=en_US.UTF-8
6 ， 修改oracle安装文件
vim /home/oracle/database/install/oraparam.ini

oracle10G静默安装
配置enterprise.rsp文件
先拷贝一份

cp /home/oracle/database/response/enterprise.rsp /home/oracle/database/response/enterprise_new.rsp
vim /home/oracle/database/response/enterprise_new.rsp
#修改以下值即可
RESPONSEFILE_VERSION=2.2.1.0.0
UNIX_GROUP_NAME="oinstall"
ORACLE_HOME_NAME="OraDb10g_home1"
ORACLE_HOME="/u01/app/oracle/product/10.2.0/db_1"
SHOW_INSTALL_PROGRESS_PAGE= true
SHOW_END_OF_INSTALL_MSGS= true
COMPONENT_LANGUAGES={"zh_CN"}
s_nameForDBAGrp= "dba"
s_nameForOPERGrp="dba"
INSTALL_TYPE="EE"
n_configurationOption=3
RESTART_SYSTEM=false
RESTART_REMOTE_SYSTEM=false
说明：这几项要视情况而定比如说 UNIX_GROUP_NAME="oinstall" 和s_nameForDBAGrp= "dba" s_nameForOPERGrp="dba"还有环境变量都要参照前面自己定义好的来
完整的参考如下

RESPONSEFILE_VERSION=2.2.1.0.0
UNIX_GROUP_NAME="oinstall"
FROM_LOCATION="../stage/products.xml"
NEXT_SESSION_RESPONSE=<Value Unspecified>
ORACLE_HOME="/u01/app/oracle/product/10.2.0/db_1"
ORACLE_HOME_NAME="OraDb10g_home1"
TOPLEVEL_COMPONENT={"oracle.server","10.2.0.1.0"}
DEINSTALL_LIST={"oracle.server","10.2.0.1.0"}
SHOW_SPLASH_SCREEN=false
SHOW_WELCOME_PAGE=false
SHOW_NODE_SELECTION_PAGE=false
SHOW_SUMMARY_PAGE=false
SHOW_INSTALL_PROGRESS_PAGE=true
SHOW_CONFIG_TOOL_PAGE=false
SHOW_XML_PREREQ_PAGE=false
SHOW_ROOTSH_CONFIRMATION=true
SHOW_END_SESSION_PAGE=false
SHOW_EXIT_CONFIRMATION=false
NEXT_SESSION=false
NEXT_SESSION_ON_FAIL=false
SHOW_DEINSTALL_CONFIRMATION=false
SHOW_DEINSTALL_PROGRESS=false
RESTART_SYSTEM=false
RESTART_REMOTE_SYSTEM=false
REMOVE_HOMES=<Value Unspecified>
ORACLE_HOSTNAME=<Value Unspecified>
SHOW_END_OF_INSTALL_MSGS=true
CLUSTER_NODES=<Value Unspecified>
COMPONENT_LANGUAGES={"zh_CN"}
INSTALL_TYPE="EE"
s_nameForDBAGrp="dba"
s_nameForOPERGrp="dba"
n_configurationOption=3
s_ASMSYSPassword=""
s_ASMSYSPasswordAgain=""
n_dbType=<Value Required>
oracle.assistants.server:s_responseFileName=<Value Unspecified>
s_globalDBName=<Value Required>
s_dbSid=<Value Required>
s_dbRetChar="WE8ISO8859P1"
b_loadExampleSchemas=false
b_useDBControl=true
b_receiveEmailNotification=false
s_dlgEMSMTPServer=<Value Unspecified>
s_dlgEMEmailAddress=<Value Unspecified>
s_dlgEMCentralAgentSelected=<Value Unspecified>
n_dbStorageType=<Value Unspecified>
s_mountPoint=<Value Unspecified>
s_rawDeviceMapFileLocation=<Value Unspecified>
b_enableAutoBackup=false
b_useFileSystemForRecovery=true
s_dlgRBORecoveryLocation=<Value Unspecified>
s_dlgRBOUsername=<Value Unspecified>
s_dlgRBOPassword=<Value Unspecified>
s_dlgASMCfgDiskGroupName="DATA"
s_dlgASMCfgDiskDiscoveryString=<Value Unspecified>
n_dlgASMCfgRedundancySelected=<Value Unspecified>
sl_dlgASMCfgSelectableDisks=<Value Unspecified>
sl_dlgASMCfgDiskSelections=<Value Unspecified>
sl_dlgASMDskGrpSelectedGroup={" "," "," "," "}
b_centrallyManageASMInstance=true
b_useSamePassword=true
s_superAdminSamePasswd=<Value Unspecified>
s_superAdminSamePasswdAgain=<Value Unspecified>
sl_superAdminPasswds=<Value Unspecified>
sl_superAdminPasswdsAgain=<Value Unspecified>
n_performUpgrade=0
n_upgradeDB=0
s_dbOHSelectedForUpgrade=""
s_dbSIDSelectedForUpgrade=""
n_upgradeASM=0
s_dbSelectedUsesASM="no"
sl_upgradableSIDBInstances={}
sl_upgradableRACDBInstances={}
n_dbSelection=0
b_stateOfUpgradeASMCheckbox=false
b_stateOfUpgradeDBCheckbox=false
b_oneClick=false
s_dlgASMCfgRedundancyValue=""
s_dlgASMCfgExistingFreeSpace="0"
s_dlgASMCfgNewDisksSize=""
s_dlgASMCfgAdditionalSpaceNeeded="0 MB"
正式安装

su - oracle
/home/oracle/database/runInstaller -silent -responseFile /home/oracle/database/response/enterprise_new.rsp
#接下来按提示操作， root身份登录
su root
sh /u01/app/oracle/oraInventory/orainstRoot.sh
sh /u01/app/oracle/product/10.2.0/db_1/root.sh
测试下
sqlplus / as sysdba
更新最新补丁 升级至最高版本
升级至最新的10.2.0.5.4

cp /home/oracle/Disk1/response/patchset.rsp /home/oracle/Disk1/response/patchset_new.rsp
vim /home/oracle/Disk1/response/patchset_new.rsp
1、编辑升级介质中的../Disk1/response/patchset.rsp文件，主要编辑以下条目
UNIX_GROUP_NAME="oinstall"
ORACLE_HOME="/u01/app/oracle/product/10.2.0/db_1"
ORACLE_HOME_NAME="OraDb10g_home1"
ORACLE_HOME_NAME可以从../oraInventory/ContentsXML/inventory.xml文件中 HOME NAME获取。
2、升级Oracle软件【非全新安装的话】

$ ./runInstaller -silent -responseFile /home/oracle/Disk1/response/patchset_new.rsp
3、执行root.sh
4、SQL> startup upgrade启动数据库
5、SQL> SPOOL upgrade_info.log
6、执行@$ORACLE_HOME/rdbms/admin/utlu102i.sql 收集升级信息
7、SQL> SPOOL OFF保存至文件
8、启动监听：[oracle@localhost Disk1]$ lsnrctl start
9、进入sqlplus

SQL> startup upgrade
SQL> SPOOL patch.log
SQL> @$ORACLE_HOME/rdbms/admin/catupgrd.sql –升级脚本[刷新数据字典]
SQL> SPOOL OFF
10、重启oracle
SQL> SHUTDOWN IMMEDIATE
SQL> STARTUP
11、SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql
12、查询sys.dba_registry视图，看组件的status是否是valid
13、emca -upgrade db –更新EM资料库
 
完整的参考如下

RESPONSEFILE_VERSION=2.2.1.0.0
UNIX_GROUP_NAME="oinstall"
FROM_LOCATION=<Value Required>
NEXT_SESSION_RESPONSE=<Value Unspecified>
ORACLE_HOME="/u01/app/oracle/product/10.2.0/db_1"
ORACLE_HOME_NAME="OraDb10g_home1"
TOPLEVEL_COMPONENT={"oracle.patchset.db","10.2.0.5.0"}
SHOW_SPLASH_SCREEN=false
SHOW_WELCOME_PAGE=false
SHOW_COMPONENT_LOCATIONS_PAGE=false
SHOW_CUSTOM_TREE_PAGE=false
SHOW_SUMMARY_PAGE=false
SHOW_INSTALL_PROGRESS_PAGE=true
SHOW_REQUIRED_CONFIG_TOOL_PAGE=false
SHOW_OPTIONAL_CONFIG_TOOL_PAGE=false
SHOW_CONFIG_TOOL_PAGE=false
SHOW_XML_PREREQ_PAGE=false
SHOW_RELEASE_NOTES=false
SHOW_END_OF_INSTALL_MSGS=true
SHOW_ROOTSH_CONFIRMATION=true
SHOW_END_SESSION_PAGE=false
SHOW_EXIT_CONFIRMATION=false
NEXT_SESSION=false
NEXT_SESSION_ON_FAIL=false
SHOW_DEINSTALL_CONFIRMATION=false
SHOW_DEINSTALL_PROGRESS=false
ACCEPT_LICENSE_AGREEMENT=true
RESTART_SYSTEM=<Value Unspecified>
CLUSTER_NODES=<Value Unspecified>
OUI_HOSTNAME=<Value Unspecified>
REMOVE_HOMES=<Value Unspecified>
COMPONENT_LANGUAGES={"en"}
sl_userNodeList=<Value Unspecified>
#MYORACLESUPPORT_USERNAME=<Value Unspecified>
#MYORACLESUPPORT_PASSWORD=<Value Unspecified>
PROXY_HOST=<Value Unspecified>
PROXY_PORT=<Value Unspecified>
PROXY_USER=<Value Unspecified>
PROXY_PWD=<Value Unspecified>
SECURITY_UPDATES_VIA_MYORACLESUPPORT=<Value Unspecified>
#DECLINE_SECURITY_UPDATES=<Value Unspecified>
COLLECTOR_UPGRADE=<Value Unspecified>
COLLECTOR_IGNORE_CONFIGURATION=<Value Unspecified>
COLLECTOR_IGNORE_FAILURES=<Value Unspecified>
COLLECTOR_USE_OBFUSCATED_PASSWORDS=<Value Unspecified>
COLLECTOR_RESPONSE_FILE=<Value Unspecified>
COLLECTOR_SUPPORTHUB_URL=<Value Unspecified>
MYORACLESUPPORT_USERNAME=eblisgod@gmail.com
DECLINE_SECURITY_UPDATES=true
完成后用 root 执行以下脚本
帮助

/u01/app/oracle/product/10.2.0/db_1/root.sh
#OPatch

mv $ORACLE_HOME/OPatch $ORACLE_HOME/OPatch_bak
unzip p6880880_102000_Linux-x86-64.zip
cp -rf OPatch/ $ORACLE_HOME/
2、解压p16619894_10205_Linux-x86-64.zip到$ORACLE_HOME/OPatch下。

cd $ORACLE_HOME/OPatch/
unzip p16619894_10205_Linux-x86-64.zip
3、执行$ORACLE_HOME/OPatch下./opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir ./16619894

./opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir ./16619894
4、cd 16619894
5、.././opatch apply
6，

 cd $ORACLE_HOME/rdbms/admin
 sqlplus /nolog
 SQL> CONNECT / AS SYSDBA
 SQL> STARTUP
 SQL> @catbundle.sql psu apply
 SQL> -- Execute the next statement only if this is the first PSU applied for 10.2.0.5 or this is the first PSU  applied since 10.2.0.5.3.
 SQL> @utlrp.sql
 SQL> QUIT
检查补丁：
命令1.$ORACLE_HOME/OPatch/opatch lsinventory -bugs_fixed | egrep -i 'PSU|DATABASE PATCH SET UPDATE'
2.$ORACLE_HOME/OPatch/opatch lsinventory
3.select * from registry$history
三个命令任选一个
#安装监听

cp /home/oracle/database/response/netca.rsp /home/oracle/database/response/netca_new.rsp
修改以下值:
INSTALL_TYPE=""custom"" #安装的类型
LISTENER_NUMBER=1 #监听器数量
LISTENER_NAMES={"LISTENER"} #监听器的名称列表
LISTENER_PROTOCOLS={"TCP;1521"} # 监听器使用的通讯协议列表
LISTENER_START=""LISTENER"" # 监听器启动的名称
完整的参考如下

[GENERAL]
RESPONSEFILE_VERSION="10.0"
CREATE_TYPE= "CUSTOM"
[oracle.net.ca]
INSTALLED_COMPONENTS={"server","net8","javavm"}
INSTALL_TYPE=""custom""
LISTENER_NUMBER=1
LISTENER_NAMES={"LISTENER"}
LISTENER_PROTOCOLS={"TCP;1521"}
LISTENER_START=""LISTENER""
NAMING_METHODS={"TNSNAMES","ONAMES","HOSTNAME"}
NSN_NUMBER=1
NSN_NAMES={"EXTPROC_CONNECTION_DATA"}
NSN_SERVICE = {"PLSExtProc"}
NSN_PROTOCOLS={"TCP;HOSTNAME;1521"}
#注意 在执行下面的语句时 一定要保证 /etc/hosts 跟hostname 一致 否则会报错
hostname
OrclData
cat /etc/hosts
127.0.0.1    OrclData localhost.localdomain localhost
::1        localhost6.localdomain6 localhost6

su - oracle
$ORACLE_HOME/bin/netca /silent /responseFile /home/oracle/database/response/netca_new.rsp
修改 dbstart

sed -i "s/＼/ade＼/vikrkuma_new＼/oracle/＼$ORACLE_HOME/g"  $ORACLE_HOME/bin/dbstart
确保数据库启动时，网络监听器同时启动。
增加数据实例

cp /home/oracle/database/response/dbca.rsp /home/oracle/database/response/dbca_new.rsp
vim /home/oracle/database/response/dbca_new.rsp
根据数据库建立方式的不同编辑不同的数据库库选项。
比如在本次安装过程中设置了下列参数：( 注意下面参数视情况而定啦不要照抄该选项原文件都有说明的)
RESPONSEFILE_VERSION = "10.0.0"
OPERATION_TYPE = "createDatabase"
GDBNAME = "orcl" # 数据库全局名称
SID = "orcl" #这个sid 必须要和前面的/home/oracle/.bash_profile文件中的sid相同
# 注意：一定要注意上面两个变量设置的两个值是不同的，但大多数情况下设置是相同的，相同值我没有测试，感兴趣的可以试一下（相同值会更容易理解）
TEMPLATENAME = "New_Database.dbt"
SYSPASSWORD = "system" # SYS 用户的初始密码
SYSTEMPASSWORD = "system" #SYSTEM 用户的初始密码
DATAFILEDESTINATION ="/u01/app/oracle/oradata/"
RECOVERYAREADESTINATION="/u01/app/oracle/flash_recovery_area"
STORAGETYPE=FS
CHARACTERSET = "ZHS16GBK" #数据库字符集（中文为 ZHS16GBK ）
MEMORYPERCENTAGE = "40"
SCRIPTDESTINATION ="/u01/app/oracle/admin/ora10g/scripts"
EMCONFIGURATION=”LOCAL”
SYSMANPASSWORD = "system"
DBSNMPPASSWORD = "system"
完整的参考如下

[GENERAL]
RESPONSEFILE_VERSION = "10.0.0"
OPERATION_TYPE = "createDatabase"
[CREATEDATABASE]
GDBNAME = "orcl"
SID = "orcl"
TEMPLATENAME = "New_Database.dbt"
SYSPASSWORD = "system"
SYSTEMPASSWORD = "system"
DATAFILEDESTINATION ="/u01/app/oracle/oradata/"
RECOVERYAREADESTINATION="/u01/app/oracle/flash_recovery_area"
STORAGETYPE=FS
CHARACTERSET = "ZHS16GBK"
MEMORYPERCENTAGE = "40"
SCRIPTDESTINATION ="/u01/app/oracle/admin/ora10g/scripts"
EMCONFIGURATION="LOCAL"
SYSMANPASSWORD = "system"
DBSNMPPASSWORD = "system"

su – oracle
$ORACLE_HOME/bin/dbca -silent -responseFile /home/oracle/database/response/dbca_new.rsp
数据库创建成功后需要修改一些信息：
vi /etc/oratab
orcl:/ u01/app/oracle/product/10.2.0/db_1:N
改为：
orcl:/u01/app/oracle/product/10.2.0/db_1:Y

sed -i "s/db_1:N/db_1:Y/g"   /etc/oratab
保证数据库实例能自动启动。
创建数据库和监听器自启动的服务
su - root
cd /etc/rc.d/init.d/
touch oradbstart
vim oradbstart
脚本内容如下：

#!/bin/bash
# chkconfig: 345 99 10
# description: Startup Script for Oracle Databases
# /etc/rc.d/init.d/oradbstart
export ORACLE_BASE=/u01/app/oracle/
export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
export ORACLE_SID=orcl
export PATH=$ORACLE_HOME/bin:$PATH
export NLS_LANG='simplified chinese_china.ZHS16GBK'
 
case "$1" in
        start)
        su - oracle -c "$ORACLE_HOME/bin/dbstart  $ORACLE_HOME"
        su - oracle -c "$ORACLE_HOME/bin/emctl start dbconsole"
        touch /var/lock/oracle
        echo "OK"
        ;;
 
        stop)
        echo -n "Shutdown Oracle: "
        su - oracle -c "$ORACLE_HOME/bin/dbshut  $ORACLE_HOME"
        su - oracle -c "$ORACLE_HOME/bin/lsnrctl stop"
        su - oracle -c "$ORACLE_HOME/bin/emctl stop dbconsole"
        rm -f /var/lock/oracle
        echo "OK"
        ;;
 
        restart)
                $0 stop
                $0 start
                echo "restart ok!!"
        ;;
 
        *)
        echo "Usage: 'basename $0' start|stop|restart"
        exit 1
        esac
exit 0
修改数据脚本的权限

su - root
chown oracle.oinstall /etc/rc.d/init.d/oradbstart
chmod 775 /etc/rc.d/init.d/oradbstart
把oradbstart 服务添加到 chkconfig 中（此处可不执行）

chkconfig --add oradbstart
chkconfig --list oradbstart
启动数据库实例
su - oracle
$ORACLE_HOME/bin/dbstart
测试：
su - oracle
sqlplus /nolog
SQL> connect /as sysdba
SQL> startup
测试成功。
修改两个配置文件（此处比较重要，如果不改，可能在本地用plsql远程连接数据库连接失败）
修改tnsnames.ora文件
vi /u01/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = OrclData)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = HOSTNAME)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PLSExtProc)
)
)
改为：
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.75.20)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.75.20)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PLSExtProc)
)
)
注：标红部分请替换实际ip
修改listener.ora文件
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = OrclData)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
改为：
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
(SID_NAME = orcl)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST=192.168.75.20)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
注：标红部分为修改部分，请替换实际ip
重启oracle
su – oracle
-bash-3.2$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Sat Dec 7 15:44:19 2013
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> quit
-bash-3.2$ $ORACLE_HOME/bin/lsnrctl stop
-bash-3.2$ $ORACLE_HOME/bin/lsnrctl start
-bash-3.2$ sqlplus "/as sysdba"
SQL> startup open
SQL> quit
完成。
截止到上面其实oracle安装已经完成，下面代码就是创建表空间、用户、数据库导入了，基于完整性，一并贴出来。
用系统用户创建表空间、用户等
su - oracle
sqlplus "/as sysdba"
#创建表空间
create TEMPORARY TABLESPACE AFINITOR_TEMP TEMPFILE '/u01/app/oracle/oradata/orcl/AFINITOR_TEMP.ORA' SIZE 32M AUTOEXTEND ON NEXT 32M MAXSIZE 2048M EXTENT MANAGEMENT LOCAL;
#创建临时表空间
create TABLESPACE AFINITOR LOGGING DATAFILE '/u01/app/oracle/oradata/orcl/AFINITOR.DBF' SIZE 32M AUTOEXTEND ON NEXT 32M MAXSIZE 2048M EXTENT MANAGEMENT LOCAL;
#创建用户
create user afinitor identified by afinitor default tablespace AFINITOR temporary tablespace AFINITOR_TEMP;
#给用户授权
grant resource,connect,EXP_FULL_DATABASE,IMP_FULL_DATABASE,CREATE SESSION to afinitor;
grant dba to afinitor;
#授权导入导出
GRANT CREATE USER,DROP USER,ALTER USER ,CREATE ANY VIEW ,DROP ANY VIEW,EXP_FULL_DATABASE,IMP_FULL_DATABASE,DBA,CONNECT,RESOURCE,CREATE SESSION TO afinitor;
数据导入
cd /home
（此处是在另一服务器下载所需要的数据库dmp文件）
su – oracle
imp sys/111111@orcl file=/home/database.dmp full=y ignore=y #导入命令
或者下面的语句更快
impdp sys/111111 directory=dump_dir dumpfile=database.dmp FULL=Y
Related posts:
oracle_10g_RAC 详细配置 ocfs2 + raw裸设备
CentOS 5 VPS上配置pptpd作为VPN服务器
VPS自动每日备份文件和数据库上传FTP空间并email [实用]
CentOS 6.3上kickstart _dhcp+httpd 实现服务器批量无人值守安装
Centos下vpn（pptpd）的部署

时间： 2025-01-20 12:11:49

Centos5.10中 64位静默安装oracle10g 升级10.2.0.5.12方法的相关文章

eclispse（64位）安装问题

问题描述 eclispse(64位)安装问题 背景:1.(64位)JDK.JRE安装正常2.环境变量设置正常3.问题中出现的文件存在4.之前曾用的时候是正常的,删掉(按照原来的方式)重新下载以后,就不能用了问题: 安装时出现:(新手入门,求指教) 解决方案 原因1:给定目录下jvm.dll不存在. 对策:(1)重新安装jre或者jdk并配置好环境变量.(2)copy一个jvm.dll放在该目录下. 原因2:eclipse的版本与jre或者jdk版本不一致 对策:要么两者都安装64位的,要么都安装

32位-win7 64位下安装PL/SQL Developement扔无法使用

问题描述 win7 64位下安装PL/SQL Developement扔无法使用 首先,我从命令台那是可以登入Oracle的,说明了我的数据库安装是没问题的.然后,我按照网上说的,1下了Oracle32位的客户端,并且解压在了Oracle的安装目录的product同级目录下,也把安装目录下的NETWORKADMIN拷贝到了解压的客户端文件中,2.还在PL/SQL Developement的设置中设置了相应的Oracle Home和OCI library路径配置,3也在我的电脑的环境变量中设置了相

Ubuntu10.10（64位）编译Android2.3源码问题解决

http://www.cnblogs.com/jvlstudio/archive/2011/05/14/2046562.html 1.安装Ubuntu 10.10      可选择使用Wubi安装. 2.安装Python      Ubuntu 10.10 已经安装了2.6版. 3.安装JDK      更新软件库:      sudo add-apt-repository "deb http://archive.canonical.com/ lucid partner"      s

在WINDOWS 10 64位环境，实现 ASP.NET 4.0 连接ORACLE 11g

问题描述 在WINDOWS 10 64位环境,实现 ASP.NET 4.0 连接ORACLE 11g 如题 环境 window 10 64位 需要让ASP.NET 连接到 ORACLE 数据库 解决方案 关于redhat 6.3 环境下 安装模拟pl/sql developer连接oracle 11g的方法Windows 64位 PLSQL Developer 连接Oracle 11g 64位Win7 64位 的VS2010 ASP.NET连接 Oracle 11g

centos6.5 64位，安装gearman-mysql-udf，报错!

问题描述 centos6.5 64位,安装gearman-mysql-udf,报错! 登入MySQL运行语句注册UDF函数: CREATE FUNCTION gman_do_background RETURNS STRING SONAME 'libgearman_mysql_udf.so'; 这时报错: ERROR 1126 (HY000): Can't open shared library 'libgearman_mysql_udf.so' (errno: 11 libgearman.so.

ftpserver-red?hat?6.0?64位?想安装ftp或telnet如何安装

问题描述 red?hat?6.0?64位?想安装ftp或telnet如何安装 red?hat?6.0?64位?想安装ftp或telnet如何安装,安装包哪里下载,什么版本合适?安装步骤?越详细越好?先谢谢大家 解决方案 最好找到redhat系统盘,里面rpm软件包里面有你要的ftp.telnet组件,百度后自己动手,印象深刻

91-Windows Server 2008 64位，安装SQL Server 2008 R2 出现问题

问题描述 Windows Server 2008 64位,安装SQL Server 2008 R2 出现问题 在选择功能时,只有部分,主要的好像都没有,求大神解,最好留个联系方式 解决方案 没问题啊,你都勾上就好了.实例功能就是服务器端 下面共享功能就是客户端 解决方案二: Windows8.1 安装 Sql server 2008R2 并附加数据库文件免安装Oracle客户端使用PL/SQL(Server2008 R2 64位问题也可解决)

win7升级64位后excel2003打不开的几种解决方法

  win7升级64位后excel2003打不开的几种解决方法         解决方法1: 1.如果使用的是2003版本的excel保存的表格文件是以.xls为后缀名结尾的,而2003以后的版本都是默认以.xlsx为后缀名结尾的,所以低版本的excel肯定是打不开高版本的excel表格 解决办法:就是升级excel版本,安装excel2007或以上的版本即可. 解决方法2: 1.如果是被病毒感染,需要先将杀毒软件更新至最新版本,然后断网,在隔离网络的状态下,对全盘进行杀毒,看下文件是否被感染.

Centos 5.8中64位系统yum安装php5.2步骤

由于程序运行环境需要,不得不使用老掉牙的PHP5.2以下版本. 下面提供两种方法安装PHP5.2 操作系统: CentOS 5.8 64位(阿里云空间) 1.通过官方下载源码,编译安装 下载地址:http://museum.php.net/php2/ 编译安装方法,可以解压后看README文本文件. 2.通过第三方的yum源安装php5.2.17 参考方法:https://webtatic.com/packages/php53/ 1)通过rpm -qa |grep php 命令,查看系统已经安装