Pages: 1/12 First page 1 2 3 4 5 6 7 8 9 10 Next page Final page [ View by Articles | List ]

oracle asm configure error

[不指定 2010/03/28 21:50 | by askwan ]
when i configure the oracle asm lib for my linux system (CentOS 4.7 x86) 
[root@ra ~]# /etc/init.d/oracleasm configure
Configuring the Oracle ASM library driver.

This will configure the on-boot properties of the Oracle ASM library
driver.  The following questions will determine whether the driver is
loaded on boot and what permissions it will have.  The current values
will be shown in brackets ('[]').  Hitting <ENTER> without typing an
answer will keep that current value.  Ctrl-C will abort.

Default user to own the driver interface []: oracle
Default group to own the driver interface []: dba
Start Oracle ASM library driver on boot (y/n) [n]: y
Scan for Oracle ASM disks on boot (y/n) [y]: y
Writing Oracle ASM library driver configuration: done
Initializing the Oracle ASMLib driver:                     [FAILED]

the i check the system log message ,found that : 
Mar 28 21:32:23 ra modprobe: FATAL: Module oracleasm not found. 
Mar 28 21:32:23 ra oracleasm: Unable failed
then ,i checked the asmlib version matched my linux server kernel or not ,yes i belive
the files were right version, 
# uname -a
Linux ra 2.6.9-78.ELsmp #1 SMP Fri Jul 25 00:04:28 EDT 2008 i686 i686 i386 GNU/Linux
and the files i have downloaded:
  1. oracleasm-2.6.9-78.EL-2.0.5-1.el4.i686.rpm
  2. oracleasmlib-2.0.4-1.el4.i386.rpm
  3. oracleasm-support-2.1.3-1.el4.i386.rpm

but what cause this problem ?

after check the grub.conf ,i found i have made a mistake , the system running kernel is 2.6.9-78.ELsmp , but what i have download is 2.6.9-78.EL ,when i installed the right asm lib version ,then things seems all right! 
[root@ra ~]# /etc/init.d/oracleasm configure
Configuring the Oracle ASM library driver.

This will configure the on-boot properties of the Oracle ASM library
driver.  The following questions will determine whether the driver is
loaded on boot and what permissions it will have.  The current values
will be shown in brackets ('[]').  Hitting <ENTER> without typing an
answer will keep that current value.  Ctrl-C will abort.

Default user to own the driver interface [oracle]: 
Default group to own the driver interface [dba]: 
Start Oracle ASM library driver on boot (y/n) [y]: 
Scan for Oracle ASM disks on boot (y/n) [y]: 
Writing Oracle ASM library driver configuration: done
Initializing the Oracle ASMLib driver:                     [  OK  ]
Scanning the system for Oracle ASMLib disks:               [  OK  ]


Concluding: you must download the right oracle asm lib version that match your system kernel 100%!

---END---
Tags: , ,
DataBase | Comments(0) | Trackbacks(0) | Reads(612)

create a standby database using active database duplication in oracle 11g

[不指定 2010/03/26 18:01 | by askwan ]
active database duplication is a new feature in oracle 11g,it can create a standby database for data guard without any preexisting backups to start the database duplication process.
this is an example noted by me to test this feature on the same host.

env and plans:
IP:192.168.0.120
DB: Oracle 11g 11.2.0.1.0 for linux 64bit
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1

primary database:
instance name: ora11gr2
db_unique_name: ora11gr2
net service name: ora11gr2
oracle data file,online redo log file and controlfile are located in : /u01/app/oracle/oradata/ora11gr2
alert file located in: /u01/app/oracle/admin/ora11gr2
archied log file are located in:/u01/app/oracle/archive/ora11gr2

standby database:
instance name: standby
db_unique_name: standby
net service name :standby
oracle data file,online redo log file and controlfile are located in : /u01/app/oracle/oradata/standby
alert file located in: /u01/app/oracle/admin/standby
archied log file are located in:/u01/app/oracle/archive/standby

preparatory work:
1)install oracle11g software and create a database ora11gr2 in 192.168.0.120.
2)create dir for standby
$mkdir /u01/app/oracle/oradata/standby
$mkdir /u01/app/oracle/admin/standby
$mkdir /u01/app/oracle/admin/standby/{a,dp}dump
$mkdir /u01/app/oracle/admin/standby/pfile
$mkdir /u01/app/oracle/archive/standby

3)alter primary database ora11gr2 to archive log mode
4)alter primary database to force logging mode.
5)modified initial startup file in primary database
LOG_ARCHIVE_CONFIG = 'DG_CONFIG=(ora11gr2,standby)'
LOG_ARCHIVE_DEST_1 = 'LOCATION=/u01/app/oracle/archive/ora11gr2 VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=ora11gr2'
LOG_ARCHIVE_DEST_2 = 'SERVICE=standby ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=standby'
DB_FILE_NAME_CONVERT='ora11gr2','standby'
LOG_FILE_NAME_CONVERT='ora11gr2','standby'
FAL_CLIENT='ora11gr2'
FAL_SERVER='standby'
Tags: , , , , ,
DataBase | Comments(0) | Trackbacks(0) | Reads(717)

create a duplicate database using active database duplication in oracle 11g

[不指定 2010/03/24 14:51 | by askwan ]
active database duplication is a new feature in oracle 11g,it can duplicate a database without any preexisting backups to start the database duplication process.

this simple note is written by me to test this feature in the same host.

env:
IP:192.168.0.120
DB: Oracle 11g 11.2.0.1.0 for linux 64bit
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1
Target Database instance name: ora11gr2
Duplicate database instance name: test1



STEP 1:configuration listener.ora in $ORACLE_HOME/network/admin
SID_LIST_LISTENER =
        (SID_LIST =
                (SID_DESC =
                        (GLOBAL_DBNAME = ora11gr2)
                        (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)
                        (SID_NAME =ora11gr2)
                )
        (SID_DESC =
                (GLOBAL_DBNAME = test1)
                (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)
                (SID_NAME =test1)
        )
)

Tags: , , , ,
DataBase | Comments(0) | Trackbacks(0) | Reads(704)

Use rman to create a duplicate database on the some host

[不指定 2010/03/23 16:35 | by askwan ]
As we all known! it's a common task to create a duplicate database from the target production database as a DBA.this is an example that i have noted the processes to create a duplicate database step by step,and duplicate database from source database to another host is the same .

IP:192.168.0.21
DB: Oracle 10g R2 for linux 64bit
Source database instance name : dg1
ORACLE_BASE=/u01
ORACLE_HOME=/u01/oracle/product/10.2.0/db_1
Duplicate database instance name :dg2


step 1.backup the source database use rman :

$ rman target /
RMAN> backup full database plus archivelog ;

Starting backup at 23-MAR-10
current log archived
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=154 devtype=DISK
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=2 recid=1 stamp=714411579
input archive log thread=1 sequence=3 recid=2 stamp=714411579
input archive log thread=1 sequence=4 recid=3 stamp=714411668
input archive log thread=1 sequence=5 recid=4 stamp=714412284
channel ORA_DISK_1: starting piece 1 at 23-MAR-10
channel ORA_DISK_1: finished piece 1 at 23-MAR-10
piece handle=/u01/oracle/product/10.2.0/db_1/dbs/01l9a47t_1_1 tag=TAG20100323T155125 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:08
Finished backup at 23-MAR-10

Starting backup at 23-MAR-10
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/u01/oracle/oradata/dg1/system01.dbf
input datafile fno=00003 name=/u01/oracle/oradata/dg1/sysaux01.dbf
input datafile fno=00005 name=/u01/oracle/oradata/dg1/example01.dbf
input datafile fno=00002 name=/u01/oracle/oradata/dg1/undotbs01.dbf
input datafile fno=00004 name=/u01/oracle/oradata/dg1/users01.dbf
channel ORA_DISK_1: starting piece 1 at 23-MAR-10
channel ORA_DISK_1: finished piece 1 at 23-MAR-10
piece handle=/u01/oracle/product/10.2.0/db_1/dbs/02l9a486_1_1 tag=TAG20100323T155134 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:56
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 23-MAR-10
channel ORA_DISK_1: finished piece 1 at 23-MAR-10
piece handle=/u01/oracle/product/10.2.0/db_1/dbs/03l9a49u_1_1 tag=TAG20100323T155134 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 23-MAR-10

Starting backup at 23-MAR-10
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=6 recid=5 stamp=714412353
channel ORA_DISK_1: starting piece 1 at 23-MAR-10
channel ORA_DISK_1: finished piece 1 at 23-MAR-10
piece handle=/u01/oracle/product/10.2.0/db_1/dbs/04l9a4a1_1_1 tag=TAG20100323T155233 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 23-MAR-10
Tags: , , , ,
DataBase | Comments(0) | Trackbacks(0) | Reads(486)
Pages: 1/12 First page 1 2 3 4 5 6 7 8 9 10 Next page Final page [ View by Articles | List ]