Yiyu Jia's technical Blog: fedora

Showing posts with label fedora. Show all posts

Monday, April 29, 2013

step by step to setup Oracle instant client and Oracle express 11

First, go to Oracle web site to download rpm files used below.
Below is just a raw copy of steps for installing Oracle instant client and Oracle Express 11 on a CentOS 64 machine.

19:45 yiyujia@localhost:~ $ hostname
localhost.localdomain
19:45 yiyujia@localhost:~ $ su
Password: 
[root@localhost yiyujia]# rpm -ivh /home/yiyujia/Downloads/oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm 
Preparing...                ########################################### [100%]
   1:oracle-instantclient11.########################################### [100%]
[root@localhost yiyujia]# rpm -ivh /home/yiyujia/Downloads/oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm 
Preparing...                ########################################### [100%]
   1:oracle-instantclient11.########################################### [100%]
[root@localhost yiyujia]# rpm -ivh /home/yiyujia/Downloads/oracle-instantclient11.2-odbc-11.2.0.4.0-1.x86_64.rpm 
Preparing...                ########################################### [100%]
   1:oracle-instantclient11.########################################### [100%]
[root@localhost yiyujia]# rpm -ivh /home/yiyujia/Downloads/Disk1/oracle-xe-11.2.0-1.0.x86_64.rpm 
Preparing...                ########################################### [100%]
   1:oracle-xe              ########################################### [100%]
Executing post-install steps...
You must run '/etc/init.d/oracle-xe configure' as the root user to configure the database.

[root@localhost yiyujia]# /etc/init.d/oracle-xe configure

Oracle Database 11g Express Edition Configuration
-------------------------------------------------
This will configure on-boot properties of Oracle Database 11g Express 
Edition.  The following questions will determine whether the database should 
be starting upon system boot, the ports it will use, and the passwords that 
will be used for database accounts.  Press  to accept the defaults. 
Ctrl-C will abort.

Specify the HTTP port that will be used for Oracle Application Express [8080]:8888

Specify a port that will be used for the database listener [1521]:

Specify a password to be used for database accounts.  Note that the same
password will be used for SYS and SYSTEM.  Oracle recommends the use of 
different passwords for each database account.  This can be done after 
initial configuration:
Confirm the password:

Do you want Oracle Database 11g Express Edition to be started on boot (y/n) [y]:n

Starting Oracle Net Listener...Done
Configuring database...Done
Starting Oracle Database 11g Express Edition instance...Done
Installation completed successfully.
[root@localhost yiyujia]# rpm -ivh /home/yiyujia/Downloads/sqldeveloper-3.2.20.09.87-1.noarch.rpm 
Preparing...                ########################################### [100%]
   1:sqldeveloper           ########################################### [100%]
[root@localhost yiyujia]# source /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.sh 
[root@localhost yiyujia]# vi /etc/bashrc
#export LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib:/usr/local/lib
#source /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.sh
[root@localhost yiyujia]# usermod -a -G oracle yiyujia
usermod: group 'oracle' does not exist
[root@localhost yiyujia]# usermod -a -G dba yiyujia
[root@localhost yiyujia]# usermod -a -G dba root
[root@localhost yiyujia]# exit
exit
21:11 yiyujia@localhost:~ $ sqlplus / as sysdba
bash: sqlplus: command not found
21:11 yiyujia@localhost:~ $ source /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.sh

21:11 yiyujia@localhost:~ $ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Tue Oct 29 21:11:55 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production

SQL> select * from v$database;                                     

      DBID NAME      CREATED  RESETLOGS_CHANGE# RESETLOGS_TIME
---------- --------- ------------------ ----------------- ------------------
PRIOR_RESETLOGS_CHANGE# PRIOR_RESETLOGS_TI LOG_MODE CHECKPOINT_CHANGE#
----------------------- ------------------ ------------ ------------------
ARCHIVE_CHANGE# CONTROL CONTROLFILE_CREATE CONTROLFILE_SEQUENCE#
--------------- ------- ------------------ ---------------------
CONTROLFILE_CHANGE# CONTROLFILE_TIME   OPEN_RESETL VERSION_TIME
------------------- ------------------ ----------- ------------------
OPEN_MODE      PROTECTION_MODE   PROTECTION_LEVEL     REMOTE_A
-------------------- -------------------- -------------------- --------
ACTIVATION# SWITCHOVER# DATABASE_ROLE  ARCHIVELOG_CHANGE# ARCHIVEL
----------- ----------- ---------------- ------------------ --------
SWITCHOVER_STATUS    DATAGUAR GUARD_S SUPPLEME SUP SUP FOR PLATFORM_ID
-------------------- -------- ------- -------- --- --- --- -----------
PLATFORM_NAME
--------------------------------------------------------------------------------
RECOVERY_TARGET_INCARNATION# LAST_OPEN_INCARNATION# CURRENT_SCN
---------------------------- ---------------------- -----------
FLASHBACK_ON    SUP SUP DB_UNIQUE_NAME
------------------ --- --- ------------------------------
STANDBY_BECAME_PRIMARY_SCN FS_FAILOVER_STATUS   FS_FAILOVER_CURRENT_TARGET
-------------------------- ---------------------- ------------------------------
FS_FAILOVER_THRESHOLD FS_FAIL
--------------------- -------
FS_FAILOVER_OBSERVER_HOST
--------------------------------------------------------------------------------
CON PRIMARY_DB_UNIQUE_NAME    SUP MIN_REQUIRED_CAPTURE_CHANGE#
--- ------------------------------ --- ----------------------------
2711238071 XE      29-OCT-13      353178 29-OCT-13

      DBID NAME      CREATED  RESETLOGS_CHANGE# RESETLOGS_TIME
---------- --------- ------------------ ----------------- ------------------
PRIOR_RESETLOGS_CHANGE# PRIOR_RESETLOGS_TI LOG_MODE CHECKPOINT_CHANGE#
----------------------- ------------------ ------------ ------------------
ARCHIVE_CHANGE# CONTROL CONTROLFILE_CREATE CONTROLFILE_SEQUENCE#
--------------- ------- ------------------ ---------------------
CONTROLFILE_CHANGE# CONTROLFILE_TIME   OPEN_RESETL VERSION_TIME
------------------- ------------------ ----------- ------------------
OPEN_MODE      PROTECTION_MODE   PROTECTION_LEVEL     REMOTE_A
-------------------- -------------------- -------------------- --------
ACTIVATION# SWITCHOVER# DATABASE_ROLE  ARCHIVELOG_CHANGE# ARCHIVEL
----------- ----------- ---------------- ------------------ --------
SWITCHOVER_STATUS    DATAGUAR GUARD_S SUPPLEME SUP SUP FOR PLATFORM_ID
-------------------- -------- ------- -------- --- --- --- -----------
PLATFORM_NAME
--------------------------------------------------------------------------------
RECOVERY_TARGET_INCARNATION# LAST_OPEN_INCARNATION# CURRENT_SCN
---------------------------- ---------------------- -----------
FLASHBACK_ON    SUP SUP DB_UNIQUE_NAME
------------------ --- --- ------------------------------
STANDBY_BECAME_PRIMARY_SCN FS_FAILOVER_STATUS   FS_FAILOVER_CURRENT_TARGET
-------------------------- ---------------------- ------------------------------
FS_FAILOVER_THRESHOLD FS_FAIL
--------------------- -------
FS_FAILOVER_OBSERVER_HOST
--------------------------------------------------------------------------------
CON PRIMARY_DB_UNIQUE_NAME    SUP MIN_REQUIRED_CAPTURE_CHANGE#
--- ------------------------------ --- ----------------------------
        1 28-AUG-11    NOARCHIVELOG      357224

      DBID NAME      CREATED  RESETLOGS_CHANGE# RESETLOGS_TIME
---------- --------- ------------------ ----------------- ------------------
PRIOR_RESETLOGS_CHANGE# PRIOR_RESETLOGS_TI LOG_MODE CHECKPOINT_CHANGE#
----------------------- ------------------ ------------ ------------------
ARCHIVE_CHANGE# CONTROL CONTROLFILE_CREATE CONTROLFILE_SEQUENCE#
--------------- ------- ------------------ ---------------------
CONTROLFILE_CHANGE# CONTROLFILE_TIME   OPEN_RESETL VERSION_TIME
------------------- ------------------ ----------- ------------------
OPEN_MODE      PROTECTION_MODE   PROTECTION_LEVEL     REMOTE_A
-------------------- -------------------- -------------------- --------
ACTIVATION# SWITCHOVER# DATABASE_ROLE  ARCHIVELOG_CHANGE# ARCHIVEL
----------- ----------- ---------------- ------------------ --------
SWITCHOVER_STATUS    DATAGUAR GUARD_S SUPPLEME SUP SUP FOR PLATFORM_ID
-------------------- -------- ------- -------- --- --- --- -----------
PLATFORM_NAME
--------------------------------------------------------------------------------
RECOVERY_TARGET_INCARNATION# LAST_OPEN_INCARNATION# CURRENT_SCN
---------------------------- ---------------------- -----------
FLASHBACK_ON    SUP SUP DB_UNIQUE_NAME
------------------ --- --- ------------------------------
STANDBY_BECAME_PRIMARY_SCN FS_FAILOVER_STATUS   FS_FAILOVER_CURRENT_TARGET
-------------------------- ---------------------- ------------------------------
FS_FAILOVER_THRESHOLD FS_FAIL
--------------------- -------
FS_FAILOVER_OBSERVER_HOST
--------------------------------------------------------------------------------
CON PRIMARY_DB_UNIQUE_NAME    SUP MIN_REQUIRED_CAPTURE_CHANGE#
--- ------------------------------ --- ----------------------------
       0 CURRENT 29-OCT-13        430

      DBID NAME      CREATED  RESETLOGS_CHANGE# RESETLOGS_TIME
---------- --------- ------------------ ----------------- ------------------
PRIOR_RESETLOGS_CHANGE# PRIOR_RESETLOGS_TI LOG_MODE CHECKPOINT_CHANGE#
----------------------- ------------------ ------------ ------------------
ARCHIVE_CHANGE# CONTROL CONTROLFILE_CREATE CONTROLFILE_SEQUENCE#
--------------- ------- ------------------ ---------------------
CONTROLFILE_CHANGE# CONTROLFILE_TIME   OPEN_RESETL VERSION_TIME
------------------- ------------------ ----------- ------------------
OPEN_MODE      PROTECTION_MODE   PROTECTION_LEVEL     REMOTE_A
-------------------- -------------------- -------------------- --------
ACTIVATION# SWITCHOVER# DATABASE_ROLE  ARCHIVELOG_CHANGE# ARCHIVEL
----------- ----------- ---------------- ------------------ --------
SWITCHOVER_STATUS    DATAGUAR GUARD_S SUPPLEME SUP SUP FOR PLATFORM_ID
-------------------- -------- ------- -------- --- --- --- -----------
PLATFORM_NAME
--------------------------------------------------------------------------------
RECOVERY_TARGET_INCARNATION# LAST_OPEN_INCARNATION# CURRENT_SCN
---------------------------- ---------------------- -----------
FLASHBACK_ON    SUP SUP DB_UNIQUE_NAME
------------------ --- --- ------------------------------
STANDBY_BECAME_PRIMARY_SCN FS_FAILOVER_STATUS   FS_FAILOVER_CURRENT_TARGET
-------------------------- ---------------------- ------------------------------
FS_FAILOVER_THRESHOLD FS_FAIL
--------------------- -------
FS_FAILOVER_OBSERVER_HOST
--------------------------------------------------------------------------------
CON PRIMARY_DB_UNIQUE_NAME    SUP MIN_REQUIRED_CAPTURE_CHANGE#
--- ------------------------------ --- ----------------------------
      357257 29-OCT-13        NOT ALLOWED 29-OCT-13

      DBID NAME      CREATED  RESETLOGS_CHANGE# RESETLOGS_TIME
---------- --------- ------------------ ----------------- ------------------
PRIOR_RESETLOGS_CHANGE# PRIOR_RESETLOGS_TI LOG_MODE CHECKPOINT_CHANGE#
----------------------- ------------------ ------------ ------------------
ARCHIVE_CHANGE# CONTROL CONTROLFILE_CREATE CONTROLFILE_SEQUENCE#
--------------- ------- ------------------ ---------------------
CONTROLFILE_CHANGE# CONTROLFILE_TIME   OPEN_RESETL VERSION_TIME
------------------- ------------------ ----------- ------------------
OPEN_MODE      PROTECTION_MODE   PROTECTION_LEVEL     REMOTE_A
-------------------- -------------------- -------------------- --------
ACTIVATION# SWITCHOVER# DATABASE_ROLE  ARCHIVELOG_CHANGE# ARCHIVEL
----------- ----------- ---------------- ------------------ --------
SWITCHOVER_STATUS    DATAGUAR GUARD_S SUPPLEME SUP SUP FOR PLATFORM_ID
-------------------- -------- ------- -------- --- --- --- -----------
PLATFORM_NAME
--------------------------------------------------------------------------------
RECOVERY_TARGET_INCARNATION# LAST_OPEN_INCARNATION# CURRENT_SCN
---------------------------- ---------------------- -----------
FLASHBACK_ON    SUP SUP DB_UNIQUE_NAME
------------------ --- --- ------------------------------
STANDBY_BECAME_PRIMARY_SCN FS_FAILOVER_STATUS   FS_FAILOVER_CURRENT_TARGET
-------------------------- ---------------------- ------------------------------
FS_FAILOVER_THRESHOLD FS_FAIL
--------------------- -------
FS_FAILOVER_OBSERVER_HOST
--------------------------------------------------------------------------------
CON PRIMARY_DB_UNIQUE_NAME    SUP MIN_REQUIRED_CAPTURE_CHANGE#
--- ------------------------------ --- ----------------------------
READ WRITE      MAXIMUM PERFORMANCE  UNPROTECTED        ENABLED

      DBID NAME      CREATED  RESETLOGS_CHANGE# RESETLOGS_TIME
---------- --------- ------------------ ----------------- ------------------
PRIOR_RESETLOGS_CHANGE# PRIOR_RESETLOGS_TI LOG_MODE CHECKPOINT_CHANGE#
----------------------- ------------------ ------------ ------------------
ARCHIVE_CHANGE# CONTROL CONTROLFILE_CREATE CONTROLFILE_SEQUENCE#
--------------- ------- ------------------ ---------------------
CONTROLFILE_CHANGE# CONTROLFILE_TIME   OPEN_RESETL VERSION_TIME
------------------- ------------------ ----------- ------------------
OPEN_MODE      PROTECTION_MODE   PROTECTION_LEVEL     REMOTE_A
-------------------- -------------------- -------------------- --------
ACTIVATION# SWITCHOVER# DATABASE_ROLE  ARCHIVELOG_CHANGE# ARCHIVEL
----------- ----------- ---------------- ------------------ --------
SWITCHOVER_STATUS    DATAGUAR GUARD_S SUPPLEME SUP SUP FOR PLATFORM_ID
-------------------- -------- ------- -------- --- --- --- -----------
PLATFORM_NAME
--------------------------------------------------------------------------------
RECOVERY_TARGET_INCARNATION# LAST_OPEN_INCARNATION# CURRENT_SCN
---------------------------- ---------------------- -----------
FLASHBACK_ON    SUP SUP DB_UNIQUE_NAME
------------------ --- --- ------------------------------
STANDBY_BECAME_PRIMARY_SCN FS_FAILOVER_STATUS   FS_FAILOVER_CURRENT_TARGET
-------------------------- ---------------------- ------------------------------
FS_FAILOVER_THRESHOLD FS_FAIL
--------------------- -------
FS_FAILOVER_OBSERVER_HOST
--------------------------------------------------------------------------------
CON PRIMARY_DB_UNIQUE_NAME    SUP MIN_REQUIRED_CAPTURE_CHANGE#
--- ------------------------------ --- ----------------------------
 2711229879  2711229879 PRIMARY      0 DISABLED

      DBID NAME      CREATED  RESETLOGS_CHANGE# RESETLOGS_TIME
---------- --------- ------------------ ----------------- ------------------
PRIOR_RESETLOGS_CHANGE# PRIOR_RESETLOGS_TI LOG_MODE CHECKPOINT_CHANGE#
----------------------- ------------------ ------------ ------------------
ARCHIVE_CHANGE# CONTROL CONTROLFILE_CREATE CONTROLFILE_SEQUENCE#
--------------- ------- ------------------ ---------------------
CONTROLFILE_CHANGE# CONTROLFILE_TIME   OPEN_RESETL VERSION_TIME
------------------- ------------------ ----------- ------------------
OPEN_MODE      PROTECTION_MODE   PROTECTION_LEVEL     REMOTE_A
-------------------- -------------------- -------------------- --------
ACTIVATION# SWITCHOVER# DATABASE_ROLE  ARCHIVELOG_CHANGE# ARCHIVEL
----------- ----------- ---------------- ------------------ --------
SWITCHOVER_STATUS    DATAGUAR GUARD_S SUPPLEME SUP SUP FOR PLATFORM_ID
-------------------- -------- ------- -------- --- --- --- -----------
PLATFORM_NAME
--------------------------------------------------------------------------------
RECOVERY_TARGET_INCARNATION# LAST_OPEN_INCARNATION# CURRENT_SCN
---------------------------- ---------------------- -----------
FLASHBACK_ON    SUP SUP DB_UNIQUE_NAME
------------------ --- --- ------------------------------
STANDBY_BECAME_PRIMARY_SCN FS_FAILOVER_STATUS   FS_FAILOVER_CURRENT_TARGET
-------------------------- ---------------------- ------------------------------
FS_FAILOVER_THRESHOLD FS_FAIL
--------------------- -------
FS_FAILOVER_OBSERVER_HOST
--------------------------------------------------------------------------------
CON PRIMARY_DB_UNIQUE_NAME    SUP MIN_REQUIRED_CAPTURE_CHANGE#
--- ------------------------------ --- ----------------------------
NOT ALLOWED      DISABLED NONE    NO       NO  NO  NO     13

      DBID NAME      CREATED  RESETLOGS_CHANGE# RESETLOGS_TIME
---------- --------- ------------------ ----------------- ------------------
PRIOR_RESETLOGS_CHANGE# PRIOR_RESETLOGS_TI LOG_MODE CHECKPOINT_CHANGE#
----------------------- ------------------ ------------ ------------------
ARCHIVE_CHANGE# CONTROL CONTROLFILE_CREATE CONTROLFILE_SEQUENCE#
--------------- ------- ------------------ ---------------------
CONTROLFILE_CHANGE# CONTROLFILE_TIME   OPEN_RESETL VERSION_TIME
------------------- ------------------ ----------- ------------------
OPEN_MODE      PROTECTION_MODE   PROTECTION_LEVEL     REMOTE_A
-------------------- -------------------- -------------------- --------
ACTIVATION# SWITCHOVER# DATABASE_ROLE  ARCHIVELOG_CHANGE# ARCHIVEL
----------- ----------- ---------------- ------------------ --------
SWITCHOVER_STATUS    DATAGUAR GUARD_S SUPPLEME SUP SUP FOR PLATFORM_ID
-------------------- -------- ------- -------- --- --- --- -----------
PLATFORM_NAME
--------------------------------------------------------------------------------
RECOVERY_TARGET_INCARNATION# LAST_OPEN_INCARNATION# CURRENT_SCN
---------------------------- ---------------------- -----------
FLASHBACK_ON    SUP SUP DB_UNIQUE_NAME
------------------ --- --- ------------------------------
STANDBY_BECAME_PRIMARY_SCN FS_FAILOVER_STATUS   FS_FAILOVER_CURRENT_TARGET
-------------------------- ---------------------- ------------------------------
FS_FAILOVER_THRESHOLD FS_FAIL
--------------------- -------
FS_FAILOVER_OBSERVER_HOST
--------------------------------------------------------------------------------
CON PRIMARY_DB_UNIQUE_NAME    SUP MIN_REQUIRED_CAPTURE_CHANGE#
--- ------------------------------ --- ----------------------------
Linux x86 64-bit

      DBID NAME      CREATED  RESETLOGS_CHANGE# RESETLOGS_TIME
---------- --------- ------------------ ----------------- ------------------
PRIOR_RESETLOGS_CHANGE# PRIOR_RESETLOGS_TI LOG_MODE CHECKPOINT_CHANGE#
----------------------- ------------------ ------------ ------------------
ARCHIVE_CHANGE# CONTROL CONTROLFILE_CREATE CONTROLFILE_SEQUENCE#
--------------- ------- ------------------ ---------------------
CONTROLFILE_CHANGE# CONTROLFILE_TIME   OPEN_RESETL VERSION_TIME
------------------- ------------------ ----------- ------------------
OPEN_MODE      PROTECTION_MODE   PROTECTION_LEVEL     REMOTE_A
-------------------- -------------------- -------------------- --------
ACTIVATION# SWITCHOVER# DATABASE_ROLE  ARCHIVELOG_CHANGE# ARCHIVEL
----------- ----------- ---------------- ------------------ --------
SWITCHOVER_STATUS    DATAGUAR GUARD_S SUPPLEME SUP SUP FOR PLATFORM_ID
-------------------- -------- ------- -------- --- --- --- -----------
PLATFORM_NAME
--------------------------------------------------------------------------------
RECOVERY_TARGET_INCARNATION# LAST_OPEN_INCARNATION# CURRENT_SCN
---------------------------- ---------------------- -----------
FLASHBACK_ON    SUP SUP DB_UNIQUE_NAME
------------------ --- --- ------------------------------
STANDBY_BECAME_PRIMARY_SCN FS_FAILOVER_STATUS   FS_FAILOVER_CURRENT_TARGET
-------------------------- ---------------------- ------------------------------
FS_FAILOVER_THRESHOLD FS_FAIL
--------------------- -------
FS_FAILOVER_OBSERVER_HOST
--------------------------------------------------------------------------------
CON PRIMARY_DB_UNIQUE_NAME    SUP MIN_REQUIRED_CAPTURE_CHANGE#
--- ------------------------------ --- ----------------------------
      2     2  358239

      DBID NAME      CREATED  RESETLOGS_CHANGE# RESETLOGS_TIME
---------- --------- ------------------ ----------------- ------------------
PRIOR_RESETLOGS_CHANGE# PRIOR_RESETLOGS_TI LOG_MODE CHECKPOINT_CHANGE#
----------------------- ------------------ ------------ ------------------
ARCHIVE_CHANGE# CONTROL CONTROLFILE_CREATE CONTROLFILE_SEQUENCE#
--------------- ------- ------------------ ---------------------
CONTROLFILE_CHANGE# CONTROLFILE_TIME   OPEN_RESETL VERSION_TIME
------------------- ------------------ ----------- ------------------
OPEN_MODE      PROTECTION_MODE   PROTECTION_LEVEL     REMOTE_A
-------------------- -------------------- -------------------- --------
ACTIVATION# SWITCHOVER# DATABASE_ROLE  ARCHIVELOG_CHANGE# ARCHIVEL
----------- ----------- ---------------- ------------------ --------
SWITCHOVER_STATUS    DATAGUAR GUARD_S SUPPLEME SUP SUP FOR PLATFORM_ID
-------------------- -------- ------- -------- --- --- --- -----------
PLATFORM_NAME
--------------------------------------------------------------------------------
RECOVERY_TARGET_INCARNATION# LAST_OPEN_INCARNATION# CURRENT_SCN
---------------------------- ---------------------- -----------
FLASHBACK_ON    SUP SUP DB_UNIQUE_NAME
------------------ --- --- ------------------------------
STANDBY_BECAME_PRIMARY_SCN FS_FAILOVER_STATUS   FS_FAILOVER_CURRENT_TARGET
-------------------------- ---------------------- ------------------------------
FS_FAILOVER_THRESHOLD FS_FAIL
--------------------- -------
FS_FAILOVER_OBSERVER_HOST
--------------------------------------------------------------------------------
CON PRIMARY_DB_UNIQUE_NAME    SUP MIN_REQUIRED_CAPTURE_CHANGE#
--- ------------------------------ --- ----------------------------
NO     NO  NO  XE

      DBID NAME      CREATED  RESETLOGS_CHANGE# RESETLOGS_TIME
---------- --------- ------------------ ----------------- ------------------
PRIOR_RESETLOGS_CHANGE# PRIOR_RESETLOGS_TI LOG_MODE CHECKPOINT_CHANGE#
----------------------- ------------------ ------------ ------------------
ARCHIVE_CHANGE# CONTROL CONTROLFILE_CREATE CONTROLFILE_SEQUENCE#
--------------- ------- ------------------ ---------------------
CONTROLFILE_CHANGE# CONTROLFILE_TIME   OPEN_RESETL VERSION_TIME
------------------- ------------------ ----------- ------------------
OPEN_MODE      PROTECTION_MODE   PROTECTION_LEVEL     REMOTE_A
-------------------- -------------------- -------------------- --------
ACTIVATION# SWITCHOVER# DATABASE_ROLE  ARCHIVELOG_CHANGE# ARCHIVEL
----------- ----------- ---------------- ------------------ --------
SWITCHOVER_STATUS    DATAGUAR GUARD_S SUPPLEME SUP SUP FOR PLATFORM_ID
-------------------- -------- ------- -------- --- --- --- -----------
PLATFORM_NAME
--------------------------------------------------------------------------------
RECOVERY_TARGET_INCARNATION# LAST_OPEN_INCARNATION# CURRENT_SCN
---------------------------- ---------------------- -----------
FLASHBACK_ON    SUP SUP DB_UNIQUE_NAME
------------------ --- --- ------------------------------
STANDBY_BECAME_PRIMARY_SCN FS_FAILOVER_STATUS   FS_FAILOVER_CURRENT_TARGET
-------------------------- ---------------------- ------------------------------
FS_FAILOVER_THRESHOLD FS_FAIL
--------------------- -------
FS_FAILOVER_OBSERVER_HOST
--------------------------------------------------------------------------------
CON PRIMARY_DB_UNIQUE_NAME    SUP MIN_REQUIRED_CAPTURE_CHANGE#
--- ------------------------------ --- ----------------------------
    0 DISABLED

      DBID NAME      CREATED  RESETLOGS_CHANGE# RESETLOGS_TIME
---------- --------- ------------------ ----------------- ------------------
PRIOR_RESETLOGS_CHANGE# PRIOR_RESETLOGS_TI LOG_MODE CHECKPOINT_CHANGE#
----------------------- ------------------ ------------ ------------------
ARCHIVE_CHANGE# CONTROL CONTROLFILE_CREATE CONTROLFILE_SEQUENCE#
--------------- ------- ------------------ ---------------------
CONTROLFILE_CHANGE# CONTROLFILE_TIME   OPEN_RESETL VERSION_TIME
------------------- ------------------ ----------- ------------------
OPEN_MODE      PROTECTION_MODE   PROTECTION_LEVEL     REMOTE_A
-------------------- -------------------- -------------------- --------
ACTIVATION# SWITCHOVER# DATABASE_ROLE  ARCHIVELOG_CHANGE# ARCHIVEL
----------- ----------- ---------------- ------------------ --------
SWITCHOVER_STATUS    DATAGUAR GUARD_S SUPPLEME SUP SUP FOR PLATFORM_ID
-------------------- -------- ------- -------- --- --- --- -----------
PLATFORM_NAME
--------------------------------------------------------------------------------
RECOVERY_TARGET_INCARNATION# LAST_OPEN_INCARNATION# CURRENT_SCN
---------------------------- ---------------------- -----------
FLASHBACK_ON    SUP SUP DB_UNIQUE_NAME
------------------ --- --- ------------------------------
STANDBY_BECAME_PRIMARY_SCN FS_FAILOVER_STATUS   FS_FAILOVER_CURRENT_TARGET
-------------------------- ---------------------- ------------------------------
FS_FAILOVER_THRESHOLD FS_FAIL
--------------------- -------
FS_FAILOVER_OBSERVER_HOST
--------------------------------------------------------------------------------
CON PRIMARY_DB_UNIQUE_NAME    SUP MIN_REQUIRED_CAPTURE_CHANGE#
--- ------------------------------ --- ----------------------------
      0

      DBID NAME      CREATED  RESETLOGS_CHANGE# RESETLOGS_TIME
---------- --------- ------------------ ----------------- ------------------
PRIOR_RESETLOGS_CHANGE# PRIOR_RESETLOGS_TI LOG_MODE CHECKPOINT_CHANGE#
----------------------- ------------------ ------------ ------------------
ARCHIVE_CHANGE# CONTROL CONTROLFILE_CREATE CONTROLFILE_SEQUENCE#
--------------- ------- ------------------ ---------------------
CONTROLFILE_CHANGE# CONTROLFILE_TIME   OPEN_RESETL VERSION_TIME
------------------- ------------------ ----------- ------------------
OPEN_MODE      PROTECTION_MODE   PROTECTION_LEVEL     REMOTE_A
-------------------- -------------------- -------------------- --------
ACTIVATION# SWITCHOVER# DATABASE_ROLE  ARCHIVELOG_CHANGE# ARCHIVEL
----------- ----------- ---------------- ------------------ --------
SWITCHOVER_STATUS    DATAGUAR GUARD_S SUPPLEME SUP SUP FOR PLATFORM_ID
-------------------- -------- ------- -------- --- --- --- -----------
PLATFORM_NAME
--------------------------------------------------------------------------------
RECOVERY_TARGET_INCARNATION# LAST_OPEN_INCARNATION# CURRENT_SCN
---------------------------- ---------------------- -----------
FLASHBACK_ON    SUP SUP DB_UNIQUE_NAME
------------------ --- --- ------------------------------
STANDBY_BECAME_PRIMARY_SCN FS_FAILOVER_STATUS   FS_FAILOVER_CURRENT_TARGET
-------------------------- ---------------------- ------------------------------
FS_FAILOVER_THRESHOLD FS_FAIL
--------------------- -------
FS_FAILOVER_OBSERVER_HOST
--------------------------------------------------------------------------------
CON PRIMARY_DB_UNIQUE_NAME    SUP MIN_REQUIRED_CAPTURE_CHANGE#
--- ------------------------------ --- ----------------------------


      DBID NAME      CREATED  RESETLOGS_CHANGE# RESETLOGS_TIME
---------- --------- ------------------ ----------------- ------------------
PRIOR_RESETLOGS_CHANGE# PRIOR_RESETLOGS_TI LOG_MODE CHECKPOINT_CHANGE#
----------------------- ------------------ ------------ ------------------
ARCHIVE_CHANGE# CONTROL CONTROLFILE_CREATE CONTROLFILE_SEQUENCE#
--------------- ------- ------------------ ---------------------
CONTROLFILE_CHANGE# CONTROLFILE_TIME   OPEN_RESETL VERSION_TIME
------------------- ------------------ ----------- ------------------
OPEN_MODE      PROTECTION_MODE   PROTECTION_LEVEL     REMOTE_A
-------------------- -------------------- -------------------- --------
ACTIVATION# SWITCHOVER# DATABASE_ROLE  ARCHIVELOG_CHANGE# ARCHIVEL
----------- ----------- ---------------- ------------------ --------
SWITCHOVER_STATUS    DATAGUAR GUARD_S SUPPLEME SUP SUP FOR PLATFORM_ID
-------------------- -------- ------- -------- --- --- --- -----------
PLATFORM_NAME
--------------------------------------------------------------------------------
RECOVERY_TARGET_INCARNATION# LAST_OPEN_INCARNATION# CURRENT_SCN
---------------------------- ---------------------- -----------
FLASHBACK_ON    SUP SUP DB_UNIQUE_NAME
------------------ --- --- ------------------------------
STANDBY_BECAME_PRIMARY_SCN FS_FAILOVER_STATUS   FS_FAILOVER_CURRENT_TARGET
-------------------------- ---------------------- ------------------------------
FS_FAILOVER_THRESHOLD FS_FAIL
--------------------- -------
FS_FAILOVER_OBSERVER_HOST
--------------------------------------------------------------------------------
CON PRIMARY_DB_UNIQUE_NAME    SUP MIN_REQUIRED_CAPTURE_CHANGE#
--- ------------------------------ --- ----------------------------
NO       NO

      DBID NAME      CREATED  RESETLOGS_CHANGE# RESETLOGS_TIME
---------- --------- ------------------ ----------------- ------------------
PRIOR_RESETLOGS_CHANGE# PRIOR_RESETLOGS_TI LOG_MODE CHECKPOINT_CHANGE#
----------------------- ------------------ ------------ ------------------
ARCHIVE_CHANGE# CONTROL CONTROLFILE_CREATE CONTROLFILE_SEQUENCE#
--------------- ------- ------------------ ---------------------
CONTROLFILE_CHANGE# CONTROLFILE_TIME   OPEN_RESETL VERSION_TIME
------------------- ------------------ ----------- ------------------
OPEN_MODE      PROTECTION_MODE   PROTECTION_LEVEL     REMOTE_A
-------------------- -------------------- -------------------- --------
ACTIVATION# SWITCHOVER# DATABASE_ROLE  ARCHIVELOG_CHANGE# ARCHIVEL
----------- ----------- ---------------- ------------------ --------
SWITCHOVER_STATUS    DATAGUAR GUARD_S SUPPLEME SUP SUP FOR PLATFORM_ID
-------------------- -------- ------- -------- --- --- --- -----------
PLATFORM_NAME
--------------------------------------------------------------------------------
RECOVERY_TARGET_INCARNATION# LAST_OPEN_INCARNATION# CURRENT_SCN
---------------------------- ---------------------- -----------
FLASHBACK_ON    SUP SUP DB_UNIQUE_NAME
------------------ --- --- ------------------------------
STANDBY_BECAME_PRIMARY_SCN FS_FAILOVER_STATUS   FS_FAILOVER_CURRENT_TARGET
-------------------------- ---------------------- ------------------------------
FS_FAILOVER_THRESHOLD FS_FAIL
--------------------- -------
FS_FAILOVER_OBSERVER_HOST
--------------------------------------------------------------------------------
CON PRIMARY_DB_UNIQUE_NAME    SUP MIN_REQUIRED_CAPTURE_CHANGE#
--- ------------------------------ --- ----------------------------


SQL>

Add new user for SQL Developer to use for connecting.


23:45 yiyujia@localhost:~ $ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Tue Oct 29 23:51:40 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production

SQL> startup
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 1068937216 bytes
Fixed Size      2233344 bytes
Variable Size    616565760 bytes
Database Buffers   444596224 bytes
Redo Buffers      5541888 bytes
Database mounted.
Database opened.
SQL> create user yiyujia identified by 123456;

User created.

SQL> grant dba to yiyujia;

Grant succeeded.

Sunday, November 11, 2012

build hadoop eclipse plugin from the source code

1) install Eclipse

2)build hadoop from the source code.

3) edit build-contrib.xml to enable eclipse plugin building

vi $Hadoop_sr_home/src/contrib/build-contrib.xml

check the version number of built hadoop and add two line in the file. For example

4) got to diretory $Hadoop_sr_home/src/contrib/eclipse-plugin/

5) run ant command

6) get hadoop-eclipse-plugin-1.1.3-SNAPSHOT.jar under $Hadoop_sr_home/build/contrib/eclipse-plugin

Saturday, October 6, 2012

Building hadoop 1.1 from the source code on centOS 6.3

1) prepare jdk

Download oracle jdk compressed version for linux
tar -xvf jdk-7u10-linux-x64.tar.gz into folder /usr/lib/jvm
alternatives --install /usr/bin/java java /usr/lib/jvm/jdk1.7.0_10-sun/bin/java 99 --slave /usr/bin/keytool keytool /usr/lib/jvm/jdk1.7.0_10-sun/bin/keytool --slave /usr/bin/rmiregistry rmiregistry /usr/lib/jvm/jdk1.7.0_10-sun/rmiregistry
alternatives --install /usr/bin/javac javac /usr/lib/jvm/jdk1.7.0_10-sun/bin/javac 99 --slave /usr/bin/jar jar /usr/lib/jvm/jdk1.7.0_10-sun/bin/jar --slave /usr/bin/rmic rmic /usr/lib/jvm/jdk1.7.0_10-sun/rmic
alternatives --config java
ln -s /usr/lib/jvm/jdk1.7.0_10-sun/ /usr/java/default (no need if we did not try oracle jdk rpm installer)

2) prepare ant and ivy

check ant installation: rpm -qa | grep ant
yum install ant
download ivy from apache
copy ivy jar files and dependent jars to /usr/share/ant/lib/

3) make sure automake is installed

yum install automake

4) make sure libtool is installed

yum install libtool

5) check out hadoop source code
svn checkout http://svn.apache.org/repos/asf/hadoop/common/branches/branch-1.1/

6) run ant command to build hadoop 1.1

Tuesday, April 10, 2012

NTP server and client configuration (without security feature)

Before successfully install and start HBase, it is very important to make each nodes in hadoop cluster to sync time with each other as timestamp plays vital important roles in HBase. The following is my step to setup NTP in my Hadoop cluster.

install NTPD server

#yum install ntp
# chkconfig ntpd on

# vi /etc/ntp.conf
add the folowing lines in the file,

#default is refuse all connections.
restrict default ignore

# allow hosts in LAN to sync time. 

restrict 192.168.1.0 mask 255.255.255.0 nomodify notrap

# Use public servers from the pool.ntp.org project.
server 0.centos.pool.ntp.org
server 1.centos.pool.ntp.org
server 2.centos.pool.ntp.org

#allow uplevel server to comunicate with server.
restrict 0.centos.pool.ntp.org nomodify notrap noquery
restrict 1.centos.pool.ntp.org nomodify notrap noquery
restrict 2.centos.pool.ntp.org nomodify notrap noquery

# Undisciplined Local Clock. This is a fake driver intended for backup
# and when no outside source of synchronized time is available.
server  127.127.1.0     # local clock
fudge   127.127.1.0 stratum 10

enable UDP at port number 123 for NTPD server
# system-configure-firewal-tui
ntpdate 0.centos.pool.ntp.org (or ip address without prefix number)
make sure ntpd server is running
#service ntpd start
check ntpd status
ntpq -p
check network interface status and see if ntpd is listening on port 123
netstat -tupln

install ntp client

# yum install ntp
# chkconfig --list | grep ntpd
chkconfig --del ntpd
# cd /etc/cron.daily/
or
# cd /etc/cron.hourly/
create file as below,
# vi ntp.sh
put command in ntp.sh
#!/bin/bash /usr/sbin/ntpdate my.ntp.hostname
make it as a executable
# chmod 755 /etc/cron.daily/ntp.sh
Finally restart the cron daemon.
# service crond restart

However, it is better to use ntpd instead of ntpdate on "client" hosts

below is my example ntp.conf for "client" hosts.

# Permit time synchronization with our time source, but do not
# permit the source to query or modify the service on this system.
restrict default kod nomodify notrap nopeer noquery
restrict -6 default kod nomodify notrap nopeer noquery

# Permit all access over the loopback interface.  This could
# be tightened as well, but to do so would effect some of
# the administrative functions.
restrict 127.0.0.1
restrict -6 ::1

# Hosts on local network are less restricted.
restrict 192.168.1.0 mask 255.255.255.0 nomodify notrap

# Use public servers from the pool.ntp.org project.
# Please consider joining the pool (http://www.pool.ntp.org/join.html).
#server 0.centos.pool.ntp.org
#server 1.centos.pool.ntp.org
#server 2.centos.pool.ntp.org
server 192.168.1.138

#broadcast 192.168.1.255 autokey        # broadcast server
#broadcastclient                        # broadcast client
#broadcast 224.0.1.1 autokey            # multicast server
#multicastclient 224.0.1.1              # multicast client
#manycastserver 239.255.254.254         # manycast server
#manycastclient 239.255.254.254 autokey # manycast client
restrict 192.168.1.138 nomodify notrap noquery

# Undisciplined Local Clock. This is a fake driver intended for backup
# and when no outside source of synchronized time is available.
server  127.127.1.0     # local clock
fudge   127.127.1.0 stratum 10

# Enable public key cryptography.
#crypto

includefile /etc/ntp/crypto/pw

# Key file containing the keys and key identifiers used when operating
# with symmetric key cryptography.
keys /etc/ntp/keys

# Specify the key identifiers which are trusted.
#trustedkey 4 8 42

# Specify the key identifier to use with the ntpdc utility.
#requestkey 8

# Specify the key identifier to use with the ntpq utility.
#controlkey 8

# Enable writing of statistics records.
#statistics clockstats cryptostats loopstats peerstats

Below is my server ntpd.conf file

# For more information about this file, see the man pages
# ntp.conf(5), ntp_acc(5), ntp_auth(5), ntp_clock(5), ntp_misc(5), ntp_mon(5).

driftfile /var/lib/ntp/drift

restrict default ignore  //set default to refuse all accessing.

# Permit time synchronization with our time source, but do not
# permit the source to query or modify the service on this system.
restrict default kod nomodify notrap nopeer noquery
restrict -6 default kod nomodify notrap nopeer noquery

# Permit all access over the loopback interface.  This could
# be tightened as well, but to do so would effect some of
# the administrative functions.
restrict 127.0.0.1
restrict -6 ::1

# Hosts on local network are less restricted.
restrict 192.168.1.0 mask 255.255.255.0 nomodify notrap

# Use public servers from the pool.ntp.org project.
# Please consider joining the pool (http://www.pool.ntp.org/join.html).
server 0.centos.pool.ntp.org
server 1.centos.pool.ntp.org
server 2.centos.pool.ntp.org

#broadcast 192.168.1.255 autokey        # broadcast server
#broadcastclient                        # broadcast client
#broadcast 224.0.1.1 autokey            # multicast server
#multicastclient 224.0.1.1              # multicast client
#manycastserver 239.255.254.254         # manycast server
#manycastclient 239.255.254.254 autokey # manycast client
restrict 0.centos.pool.ntp.org notrap noquery
restrict 1.centos.pool.ntp.org notrap noquery
restrict 2.centos.pool.ntp.org notrap noquery


# Undisciplined Local Clock. This is a fake driver intended for backup
# and when no outside source of synchronized time is available.
server  127.127.1.0     # local clock
fudge   127.127.1.0 stratum 10

# Enable public key cryptography.
#crypto

includefile /etc/ntp/crypto/pw

# Key file containing the keys and key identifiers used when operating
# with symmetric key cryptography.
keys /etc/ntp/keys

# Specify the key identifiers which are trusted.
#trustedkey 4 8 42

# Specify the key identifier to use with the ntpdc utility.
#requestkey 8

# Specify the key identifier to use with the ntpq utility.
#controlkey 8

# Enable writing of statistics records.
#statistics clockstats cryptostats loopstats peerstats

Saturday, April 7, 2012

configure passphraseless SSH login among CentOS servers

wget http://pkgs.repoforge.org/rpmforge-release-0.5.2-2.el5.rf.x86_64.rpm
wget http://apt.sw.be/RPM-GPG-KEY.dag.txt
rpm -K rpmforge-release-0.5.2-2.el6.rf.x86_64.rpm
rpm -ivh rpmforge-release-0.5.2-2.el6.rf.x86_64.rpm
vi /etc/yum.repos.d/rpmforge.repo
add “priority=3″ or other right priority number after “enabled = 1″
yum repolist
yum install keychain
ssh-keygen -t dsa
chmod 755 .ssh
scp ~/.ssh/id_dsa.pub user@remotehost:.ssh/authorized_keys
Or:
cat ~/.ssh/id_dsa.pub | ssh hadoopuser@remotehost "cat - >> ~/.ssh/authorized_keys"
chmod 600 ~/.ssh/authorized_keys
vi .bash_profile
add following commands:
/usr/bin/keychain -q $HOME/.ssh/id_dsa
source $HOME/.keychain/$HOSTNAME-sh
Logout and login. password for key files is asked and will be asked at first time login only. or run command source .bash_profile
run ssh among servers without being asked for password

http://www.cyberciti.biz/faq/ssh-password-less-login-with-dsa-publickey-authentication/ http://www.ehowstuff.com/how-to-configure-rpmforge-repository-on-centos-6-3/ http://www.cyberciti.biz/faq/ssh-passwordless-login-with-keychain-for-scripts/

Sunday, March 18, 2012

install eclipse on CentOS

1) Download eclipse

2) tar -xvf eclipse into directory /usr/lib/eclipse or /usr/share/eclipse

3) using alternatives configure eclipse command

alternatives --install /usr/bin/eclipse eclipse /usr/lib/eclipse/eclipse 99

4) vi /usr/share/applications/eclipse.desktop and add content

[Desktop Entry]
Name=Eclipse
Comment=Eclipse Juno
Exec=eclipse
Icon=/usr/lib/eclipse/icon.xpm
Terminal=false
Type=Application
Categories=GNOME;KDE;Application;Development;Java;
StartupNotify=true

Saturday, February 25, 2012

install phpMyAdmin on Fedora or CentOS

Install HTTPD, PHP, MySQL first.
Download phpMyAdmin
unzip phpMyAdmin under directory /var/www/html/
make sure your mysql server and httpd are running: service mysqld start and service httpd start
if you have not set root password for new installed MySQL, running the following command to set a password to avoid error message "fedora Login without a password is forbidden by configuration (see AllowNoPassword)": $ mysqladmin -u root password NEWPASSWORD
running command system-config-services and system-config-firewall to doulbe check your httpd and mysqld is enabled and running

Sunday, August 28, 2011

install xdebug with Zend Server CE and Netbeans 7.0.x

Go to Fedora "Application -> System Tools -> Add/Remove Software" and make sure PHP PEAR and PHP PECL and XDebug are installed already. Then, run the following commands to add xdebug into Zend Server.

#  edit debugger.ini file to disable zend debugger.
#  ; register the extension to be loaded by Zend Extension Manager
# ;zend_extension_manager.dir.debugger=/usr/local/zend/lib/debugger
[root@jiaFedora14 yyjia]# sudo gedit /usr/local/zend/etc/conf.d/debugger.ini

#find where is xdebug.so
[root@jiaFedora14 /]# find /usr/ -name 'xdebug.so'
/usr/lib64/php/modules/xdebug.so

#  Make zend server to load xdegug.so before extension manager is loaded.
#  zend_extension=/usr/lib64/php/modules/xdebug.so
#  zend_extension=/usr/local/zend/lib/ZendExtensionManager.so
[root@jiaFedora14 yyjia]# sudo gedit /usr/local/zend/etc/conf.d/extension_manager.ini

# edit php.ini or other configuration files to have xdebug settings
# [xdebug]
# xdebug.remote_enable=on
# xdebug.remote_handler=dbgp
# xdebug.remote_mode=req
# ;xdebug.remote_connect_back=1
# xdebug.remote_host=192.168.1.190
# xdebug.remote_port=9001
# xdebug.idekey="netbeans-xdebug"
[root@jiaFedora14 yyjia]# sudo gedit /usr/local/zend/etc/php.ini

# Fedora has SELinux enabled by default. I open the port 9001.
[root@jiaFedora14 yyjia]# semanage port -a -t http_port_t -p tcp 9001

# restart Zend Server
[root@jiaFedora14 yyjia]# service zend-server restart

# check xdebug configuration.
[root@jiaFedora14 yyjia]# php -i | grep xdebug

After running all above command and see every thing is correct as expected, we do a simple configuration in Netbeans as shown in figure below,

Some notes:
1) The above steps only install xdebug for one developer. For a team developing environment, we need to install DBGp proxy.

2) I tried "xdebug.remote_connect_back=1" and hope I do not need to specify a fix hostname/ipaddress in php.ini. But, I failure on it. I have not dig deep into it.

Monday, August 8, 2011

upgrade Fedora 14 to Fedora 15

Since Fedora 15 was released for some time already, I upgraded my development server from Fedora 14 to Fedora 15 recently. Below is the command set I used to upgrade to Fedora 15. Before run those commands, I backup my virtual machine files in case.

# change account to Root account
[yyjia@jiaFedora14 ~]$ su
Password: 

# upgrade to latest rpm version
[root@jiaFedora14 yyjia]# yum upgrade rpm
Loaded plugins: langpacks, presto, refresh-packagekit
Adding en_US to language list
Zend                                       |  951 B     00:00     
Zend_noarch                                |  951 B     00:00     
fedora/metalink                            |  21 kB     00:00     
jenkins                                    |  951 B     00:00     
jenkins/primary                            | 1.3 kB     00:00     
jenkins                                                                     1/1
updates/metalink                           |  13 kB     00:00     
updates                                    | 4.7 kB     00:00     
updates/primary_db                         | 6.5 MB     00:07     
Setting up Upgrade Process
No Packages marked for Update
[root@jiaFedora14 yyjia]# 

#make sure I have latest packages installed.
[root@jiaFedora14 yyjia]# yum -y update

#clean up yum cache.
[root@jiaFedora14 yyjia]# yum clean all

#insall preupgrade package.
[root@jiaFedora14 yyjia]# yum install preupgrade

#running preupgrade
[root@jiaFedora14 yyjia]# preupgrade

After running preupgrade, we have below screen. I don't want to try Fedora 16 beta version. So, I selected Fedora 15.

I followed instructions shown on the screen. Then, I have a below screen to ask for reboot.

After reboot, the upgrade process starts.

Here is upgrade manual from Fedora web site: http://fedoraproject.org/wiki/YumUpgradeFaq

Wednesday, November 3, 2010

upgrade Fedora 13 to Fedora 14

I have been waiting for Fedora 14 for months as Fedora 13 has screen flickers (see bug report here) on my notebook. Fedora 14 was released yesterday. I luckily upgrade my notebook from Fedora 13 to Fedora 14 without problem. I just followed the instruction from Fedora forum. I will list the command here,

1) type su to be a root user.
2) run command yum update rpm
3) run command yum -y update to make sure upgrading Fedora 13 to the latest version. If new Fedora 13 kernel is installed at this step, reboot is required.
4) run command yum clean all
5) run command yum -install preupgrade
6) run command preupgrade-cli and find the valid entry
7) run command preupgrade-cli "Fedora 14 (Laughlin)"
8) answered yes during the upgrading and waited patiently.

The only problem I got is that preupgrade GUI does not work. It shows the windows. But, I can not make selection in its drop down box. So, I use preupgrade-cli and it works. I installed both GNOME and KDE in my Fedora 13. preupgrade-cli upgraded my desktop environment too. Btw, I think we need to leave enough spare space on hard drive for upgrading as I saw somebody complain the upgrade command does not work and the error message shows the enough hard drive space.

Friday, August 13, 2010

setup simple configured SVN with httpd on Fedora 13

To write down the step of configuring my system, I am writing this post as memo.

1) install httpd and SVN
# yum install httpd subversion

2) install mod_dav_svn
# yum install httpd mod_dav_svn

3) create subversion repository
# svnadmin create /home/svn-repos/ubianalysis

4) running following command to allow apache account to access the repository directory
# chown -R apache.apache /home/svn-repos/ubianalysis

5) running the following command to update Selinux context. If command does not work, I use Selinux GUI admin tool to add this. Actually, I added this via SeLinux admin tool found in Administration menu.
# chcon -R -t httpd_sys_content_rw_t /home/svn-repos/ubianalysis

6) go to directory /etc/httpd/conf.d and add following content in subversion.conf

<Location /svn-repos >
DAV svn
SVNParentPath /home/svn-repo/
# Require SSL connection for password protection.
# SSLRequireSSL

AuthType Basic
AuthName "Authorization Realm"
AuthUserFile /etc/httpd/passwd/passwords
Require valid-user
</Location>

7) create password file for httpd since I use Basic authType as shown on above.
#htpasswd -c /etc/httpd/passwd/passwords user1
#htpasswd /etc/httpd/passwd/passwords user2

8) testing the job
#service httpd restart

using web browser to access URL http://localhost//svn-repos/ubianalysis