Migrating RHN From Oracle XE To Oracle 11gR2 Database-candon123
I have been running redhat spacewalk server to manage packages to redhat linux systems.The initial backend database is oracle XE that the> Current Environment1.RedHat Linux 6
2.Spacewalk verison:1.7
3.Spacewalk channel:3 base,4 child
4.Total packages:13,230
Prerequisites
1.For install and configure spacewalk with oracle XE from here.
2.Configure linux for installing oracle 11gR2 database.Run following script:
[*]#!/bin/bash
[*]echo -------------------------------------------------
[*]echo "This script prepare for Oracle 11g database."
[*]#add group
[*]echo -------------------------------------------------
[*]echo "Now add asmadmin、dba、oper group."
[*]for id in oinstall asmadmin dba oper;do groupadd $id;done
[*]sleep 1
[*]#add oracle user
[*]echo -------------------------------------------------
[*]echo "Now create oracle user and set password for it."
[*]echo "The Oracle's Default Password is "oracle"."
[*]echo -------------------------------------------------
[*]useradd -g oinstall -G asmadmin,dba,oper -m -d /home/oracle -s /bin/bash oracle
[*]echo oracle|passwd --stdin oracle
[*]sleep 1
[*]
[*]echo -------------------------------------------------
[*]echo "Configure System Parameters For Oracle"
[*]sleep 2
[*]echo -------------------------------------------------
[*]echo "Edit the /etc/sysctl.conf file."
[*]#define /etc/sysctl.conf
[*]cat >>/etc/sysctl.conf>/etc/pam.d/login/etc/security/limits.conf/etc/profile/home/oracle/.bash_profile/home/oracle/.bashrc
[*]echo "alias du='du -sh'">>/home/oracle/.bashrc
[*]echo "alias la='ls -lha'">>/home/oracle/.bashrc
[*]echo ----------------------------------------------------
[*]echo "The Default ORACLE_SID is example."
[*]fi
[*]sleep 1
[*]
[*]#create /u01
[*]echo ----------------------------------------------------
[*]echo "Now,Create ORACLE_HOME."
[*] if [ ! -e /u01 ];then
[*] mkdir /u01
[*] chown -R oracle:oinstall /u01
[*] chmod 775 /u01
[*] su - oracle -c "mkdir -p \$ORACLE_HOME"
[*] else
[*] echo "The ORACLE_HOME exist."
[*] fi
[*]sleep 1
[*]#install packages
[*]echo "**********************************************************************"
[*]echo "Please Install Follow Packages:"
[*]echo "binutils compat-libstdc++ elfutils-libelf elfutils-libelf-devel"
[*]echo "elfutils-libelf-devel-static gcc gcc-c++ glibc glibc-common"
[*]echo "glibc-devel glibc-headers ksh libaio libaio-devel libgcc"
[*]echo "libgomp libstdc++ libstdc++-devel make sysstat unixODBC unixODBC-devel"
[*]echo "**********************************************************************"
[*]echo "WARNING:After run this scripts,You Must Reboot Your Machine !!!"
3.Installing oracle 11gR2 database (omitted).
4.Create the oracle 11gR2 start and stop scripts
[*]#vi /etc/init.d/oracle
[*]#!/bin/bash
[*]# oracle This shell script takes care of starting and stopping the oracle services.
[*]# Init file for oracle daemon
[*]#
[*]# chkconfig: 2345 55 25
[*]# description: oracle daemon
[*]#
[*]#oracle_home:/u01/app/oracle/product/11.2.0/db_1
[*]
[*]RETVAL=0
[*]
[*]# Source function library.
[*]. /etc/rc.d/init.d/functions
[*]
[*]
[*]# Source networking configuration.
[*][ -f /etc/sysconfig/network ] && . /etc/sysconfig/network
[*]
[*]#define global envionment variables
[*]#ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1
[*]
[*]#define the start function
[*]start () {
[*]#start LISTENER
[*]if [ -x $ORACLE_HOME/bin/lsnrctl ]; then
[*]su - oracle -c 'lsnrctl start' >/home/oracle/lsnrctl_start.log 2>&1&
[*]fi
[*]
[*]#start oracle instance
[*]if [ -x $ORACLE_HOME/bin/sqlplus ]; then
[*]su - oracle -c 'sqlplus' create tablespace spacewalk datafile '/u01/oradata/spwdb/spw01.dbf' size 10G autoextend on next 1G;
[*]SQL>create user spacewalk identified by oracle default tablespace spacewalk;
[*]SQL>grant dba to spacewalk;
2.Import the oracle XE dumped database
[*]$imp spacewalk/oracle@spwdb fromuser=spacewalk touser=spacewalk file=spacewalk.oracleXE.dmp ignore=y
[*].................
[*]
[*]import done in AL32UTF8 character set and AL16UTF16 NCHAR character set
[*]. importing SPACEWALK's objects into SPACEWALK
[*]. . importing table "DEMO_LOG" 0 rows imported
[*]. . importing table "HTMLDB_PLAN_TABLE" 2 rows imported
[*]. . importing table "PXTSESSIONS" 0 rows imported
[*]. . importing table "RHNACTION" 140 rows imported
[*]
[*]...
[*]
[*]. importing SPACEWALK's objects into SPACEWALK
[*]About to enable constraints...
[*]Import terminated successfully with warnings.
3.Remove execute permissions from the oracle-xe:
[*]#chkconfig oracle-xe off
[*]#chmod -x /etc/init.d/oracle-xe
4.Edit the /etc/rhn/rhn.conf file and replace any occurrence of 'xe' with 'spwdb'
[*]# grep -n spwdb /etc/rhn/rhn.conf
[*]32:db_name = //localhost/spwdb
5.Edit the /etc/rhn/cluster.ini and replace 'xe' with 'spwdb'
[*]# grep -n spwdb /etc/rhn/cluster.ini
[*]2:LocalConfig.0.dbname=//LOCALHOST/spwdb
6.Start the spacewalk services:
[*]# spacewalk-service start
[*]Starting spacewalk services...
[*]Initializing jabberd processes ...
[*]Starting router:
[*]Starting sm:
[*]Starting c2s:
[*]Starting s2s:
[*]Starting osa-dispatcher:
[*]Starting tomcat6:
[*]Waiting for tomcat to be ready ...
[*]Starting httpd:
[*]Starting Monitoring ...
[*] Starting InstallSoftwareConfig ...[ OK ]
[*] Starting NotifEscalator ...[ OK ]
[*] Starting GenerateNotifConfig ...[ OK ]
[*] Starting NotifLauncher ...[ OK ]
[*] Starting Notifier ...[ OK ]
[*] Starting AckProcessor ...[ OK ]
[*] Starting TSDBLocalQueue ...[ OK ]
[*][ OK ]
[*]Starting MonitoringScout ...
[*][ OK ]
[*]Starting rhn-search...
[*]Starting cobbler daemon:
[*]Starting RHN Taskomatic...
[*]Done.
页:
[1]