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 Environment
　　1.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
　　

• [root@server ~]#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
　　

• [oracle@server ~]$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:
　　

• [root@server ~]#chkconfig oracle-xe off
  
• [root@server ~]#chmod -x /etc/init.d/oracle-xe
  

　　

　　4.Edit the /etc/rhn/rhn.conf file and replace any occurrence of 'xe' with 'spwdb'
　　

• [root@server ~]# grep -n spwdb /etc/rhn/rhn.conf
  
• 32:db_name = //localhost/spwdb
  

　　

　　5.Edit the /etc/rhn/cluster.ini and replace 'xe' with 'spwdb'
　　

• [root@server ~]# grep -n spwdb /etc/rhn/cluster.ini
  
• 2:LocalConfig.0.dbname=//LOCALHOST/spwdb
  

　　

　　6.Start the spacewalk services:
　　

• [root@server rhn]# spacewalk-service start
  
• Starting spacewalk services...
  
• Initializing jabberd processes ...
  
• Starting router:                                           [  OK  ]
  
• Starting sm:                                               [  OK  ]
  
• Starting c2s:                                              [  OK  ]
  
• Starting s2s:                                              [  OK  ]
  
• Starting osa-dispatcher:                                   [  OK  ]
  
• Starting tomcat6:                                          [  OK  ]
  
• Waiting for tomcat to be ready ...
  
• Starting httpd:                                            [  OK  ]
  
• 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:                                   [  OK  ]
  
• Starting RHN Taskomatic...
  
• Done.