AskTom

Hi,
today one of databases stopped. The reason was that ASM disk group were out of space.

Alert.log
=========
Mon Mar  1 11:57:45 2010
Errors in file /opt/app/oracle/admin/replica1/bdump/replica1_arc1_15884.trc:
ORA-19816: WARNING: Files may exist in db_recovery_file_dest that are not known to database.
ORA-17502: ksfdcre:4 Failed to create file +DATA
ORA-15041: diskgroup space exhausted

Sqlplus:
========

SQL> select a.name DiskGroup, b.disk_number Disk#, b.name DiskName, b.total_mb, b.free_mb, b.path, b.header_status
2  from v$asm_disk b, v$asm_diskgroup a
3  where a.group_number (+) =b.group_number
4  order by b.group_number, b.disk_number, b.name
5  /

DISKGROUP       DISK# DISKNAME                 TOTAL_MB      FREE_MB PATH       HEADER_STATU
————— —– ——————– ———— ———— ———————————– ————
DATA 0 DATA_0000                 148,256            0 /dev/raw/raw1                       UNKNOWN
***************                            ———— ————
sum                                             148,256            0

SYS@replica1 SQL> show parameter recovery

NAME                                 TYPE        VALUE
———————————— ———– ——————————
db_recovery_file_dest                string      +DATA
db_recovery_file_dest_size           big integer 106290M
recovery_parallelism                 integer     0

SOLUTION:
=========
backup and delete ald archivelog by RMAN command

RMAN> backup archivelog all delete input;

Starting backup at Mar 01 2010 11:59:06
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
…

ls -ltr
…
-rw-r—–  1 oracle oinstall 1612922880 2010-02-17 10:16 38l67qh7_10_1
-rw-r—–  1 oracle oinstall   24561664 2010-02-17 10:16 39l67uoj_1_1
-rw-r—–  1 oracle oinstall 2147483648 2010-03-01 12:05 3cl7fmcu_1_1
-rw-r—–  1 oracle oinstall 2147484160 2010-03-01 12:05 3cl7fmcu_2_1

Regards,

Tom

Hi,

today I installed Oracle VM Server and Oracle VM Manager from images provided by Oracle.
Everything goes fine. I setup my VM machines but when I tried to create Server Pool trought VM Manager I’ve got an error

OVM-1011 OVM Manager communication with <hostname> for operation Pre-check cluster root for Server Pool failed: <Exception: Cluster root not found.>

So I did new repository and after than I was able to create Server Pool.

This is my solution:

[root@ovs ~]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/sda2              29G   26G  1.3G  96% /
/dev/sda1              99M   45M   49M  48% /boot
tmpfs                 272M     0  272M   0% /dev/shm
[root@ovs ~]# cd /opt/ovs-agent-2.3/utils/
[root@ovs utils]# ./repos.py –new /dev/sda4
Mount point: /tmp/ovsrepo_qlGMC0
Error: ['mount', '/dev/sda4', '/tmp/ovsrepo_qlGMC0'] => mount: you must specify the filesystem type

[root@ovs utils]# mkfs.ocfs2 -L sdilenapar -b 4K -C 4K -J size=64M -N 16 /dev/sda4
mkfs.ocfs2 1.4.3
Cluster stack: classic o2cb
Filesystem label=sdilenapar
Block size=4096 (bits=12)
Cluster size=4096 (bits=12)
Volume size=286363119616 (69912871 clusters) (69912871 blocks)
2168 cluster groups (tail covers 14119 clusters, rest cover 32256 clusters)
Journal size=67108864
Initial number of node slots: 16
Creating bitmaps: done
Initializing superblock: done
Writing system files: done
Writing superblock: done
Writing backup superblock: 5 block(s)
Formatting Journals: done
Formatting slot map: done
Writing lost+found: done
mkfs.ocfs2 successful

[root@ovs utils]# ./repos.py –new /dev/sda4
[ NEW ] 5ce04f38-20af-48ec-ab2f-1afd138047a7 => /dev/sda4

[root@ovs utils]# ./repos.py –list
[   ] 5ce04f38-20af-48ec-ab2f-1afd138047a7 => /dev/sda4
[root@ovs utils]# ./repos.py –root 5ce04f38-20af-48ec-ab2f-1afd138047a7
[ R ] 5ce04f38-20af-48ec-ab2f-1afd138047a7 => /dev/sda4

Regards,

Tom

[root@localhost OracleVM-Manager-2.2 20091013]# ls -ltr
total 108
-r–r–r– 1 root root  4180 Jul 13  2009 readme.txt
-r–r–r– 1 root root  6922 Jul 13  2009 LICENSE
-r–r–r– 1 root root  6922 Jul 13  2009 EULA
-r–r–r– 1 root root 80530 Sep 25 11:03 runInstaller.sh
dr-xr-xr-x 2 root root  1712 Oct 13 11:30 scripts
dr-xr-xr-x 2 root root   816 Oct 13 20:24 source
-r–r–r– 1 root root  1321 Oct 13 20:25 TRANS.TBL
[root@localhost OracleVM-Manager-2.2 20091013]# sh runInstaller.sh
Welcome to Oracle VM Manager 2.2

Please enter the choice: [1|2|3]
1. Install Oracle VM Manager
2. Uninstall Oracle VM Manager
3. Upgrade Oracle VM Manager
1

Starting Oracle VM Manager 2.2 installation …

Do you want to install a new database or use an existing one? [1|2]
1. Install a new Oracle XE database on localhost
2. Use an existing Oracle database in my network
1

Prepare to install the Oracle XE database …
Checking the supported platforms … Done

Checking the prerequisite packages are installed … Done

Checking the available disk space … Done

Installing the oracle-xe-univ package (rpm) now …
Done

Oracle Database 10g Express Edition Configuration
————————————————-
This will configure on-boot properties of Oracle Database 10g 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 <Enter> to accept the defaults.
Ctrl-C will abort.

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

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 10g Express Edition to be started on boot (y/n) [y]:

Starting Oracle Net Listener…Done
Configuring Database…Done
Starting Oracle Database 10g Express Edition Instance…Done
Installation Completed Successfully.
To access the Database Home Page go to “http://127.0.0.1:8080/apex”

Checking the availability of the database …

Set default database schema to ‘OVS’.
Please enter the password for account ‘OVS’:
Confirm the password:

Creating the Oracle VM Manager database schema …Done

Installing the ovs-manager package (rpm) …
Done

Installing the oc4j package (rpm) …
Done

Please enter the password for account ‘oc4jadmin’:
Confirm the password:

Starting OC4J … Done.
To access the OC4J Home Page and change the password go to http://127.0.0.1:8888/em

Deploying Oracle VM Manager application to OC4J container.
Creating connection pool … Done
Creating data source … Done
Deploying application help … Done
Deploying application … Done

Please enter the keystore password for the Web Service:
Confirm the password:

Setting keystore password for Web Service … Done
Do you want to use HTTPS access for Oracle VM Manager (Y|n)?Y

Configuring OC4J to use HTTPS … Done
Stopping OC4J … Done
Starting OC4J … Done

Please enter the password for the default account ‘admin’:
Confirm the password:

Configuring SMTP server …
Please enter the outgoing SMTP mail server(e.g. - mail.abc.com, mail.abc.com:25):
Please enter the outgoing SMTP mail server(e.g. - mail.abc.com, mail.abc.com:25): mail.neexistuje.cz
Mail server checking, may need some time, please wait …
Mail server ‘mail.neexistuje.cz’ check failed, enter Y to change the name and retry or N to keep hostname and continue(Y|n)?N
Setting the SMTP server to mail.neexistuje.cz …
Done

Please enter an e-mail address for account ‘admin’: admin@oracledba.cz
Confirm the e-mail address : admin@oracledba.cz
Unable to send an email to ‘admin@oracledba.cz’, would you like to change the email address(Y|n)?n
Updating e-mail address for account ‘admin’ to ‘admin@oracledba.cz’ …
Done

The console feature is not enabled by default.
For detailed setup, refer to Oracle VM Manager User’s Guide

Installation of Oracle VM Manager completed successfully.

To access the Oracle VM Manager 2.2 home page go to:
https://127.0.0.1:4443/OVS

To access the Oracle VM Manager web services WSDL page go to:
https://127.0.0.1:4443/OVSWS/LifecycleService.wsdl
https://127.0.0.1:4443/OVSWS/ResourceService.wsdl
https://127.0.0.1:4443/OVSWS/PluginService.wsdl
https://127.0.0.1:4443/OVSWS/ServerPoolService.wsdl
https://127.0.0.1:4443/OVSWS/VirtualMachineService.wsdl
https://127.0.0.1:4443/OVSWS/AdminService.wsdl

To access the Oracle VM Manager help page go to:
https://127.0.0.1:4443/help/help

Regards,

Tom