d-h-n.de » 2008

Grid Control

July 28th, 2008 . by admin

-combinates all the function of Database Control and Application Server Control into a single control.
-Grid Control manages other Oracle products such as Oracle Collarboration Suite
-maintains hardware and software configs for all member of grid
-automatic deploys patches and upgrades to keep configs consistent through enterprise

-OMA: Oracle Mannagement Agent
-OMS: Oracle Mannagement Service
-OMR: Oracle Mannagement Repository

Posted in Oracle | No Comments »

Turn off Debug VMWare Workstation 6.5 Beta 2

July 28th, 2008 . by admin

cd "C:\Program Files\VMware\VMware Workstation"

ren vmware-vmx-debug.exe vmware-vmx-debug-original.exe

copy vmware-vmx.exe vmware-vmx-debug.exe

Posted in VMWare | No Comments »

Install Ultra Search from Campanion CD

July 28th, 2008 . by admin

Dowload Campanion CD:

http://www.oracle.com/technology/software/products/database/oracle10g/htdocs/10201winsoft.html

Run \companion\setup.exe

Input: Oracle_Home and Path of the existing database, exm:
Choice: Oracle Database 10g Products 10.2.0.1.0
Choice Home: OraDb10g_home1
Path: C:\oracle\product\10.2.0\db_1

Result exm: End of Installation

The Ultra Search URL is:

http://pc2.mydom.com:5620/ultrasearch

The Ultra Search Administration Tool URL is:

http://pc2.mydom.com:5620/ultrasearch/admin

Post Installation
-Starting DBCA
-Select Configure Database Options (2.Radio Button)
-Choice Database: ORCL
-Check: Oracle Ultra Search
-Specify Password (Use the Same Password for All Accounts)
-Choice Default Dedicated Server Mode
-Click Finish
-Confirmation: OK

Posted in Oracle | No Comments »

Loading OracleAS Metadata Repository in an existing database

July 28th, 2008 . by admin

Using: REPCA – OracleAS Repository Creation Assistant

Download REPCA 10.1.2.0.3 – x86: size 393MB
from: http://www.oracle.com/technology/software/products/ias/htdocs/101202.html

Install REPCA:
-Repca should be install in separate Home, Path, exm
Home: REPCA
Path: c:\AS\repca

more Help see:

http://download-west.oracle.com/docs/cd/B14099_19/core.1012/b13998/security.htm#CDDFIEDF

After install, you can start REPCA, run:
C:\AS\repca\runRepca.bat
to load OracleAS Metadata Repository in your existing database

Welcome!
Click Next

Specify the Oracle Home Path of the existing database

Choice Load

Specify SYS Password, Hostname, Port, Service Name of the existing database

Validation!
This process required following:

Need Parameter:
aq_tmp_processes >=1

sga_target >= 600MB

db_cache_size >144MB

shared_pool_size >=175MB

jav_pool_size > 120MB

..and component Ultra Search
see Install Ultra Search

Default. Click Next

Choice Use Same Directory for All Tablespaces.
exm: C:\oracle\product\10.2.0\oradata\orcl\asrepos

Validation!

Requirements:

Undo and System Tablespace > 350MB

Also Resize Undo and System Tablespace:
ALTER DATABASE DATAFILE ‘C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\UNDOTBS01.DBF’ RESIZE 500M
ALTER DATABASE DATAFILE ‘C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM01.DBF’ RESIZE 1G

Install process …

Finish!

Posted in Oracle | No Comments »

AS Infrastructure Components

July 23rd, 2008 . by admin

Identity Management Components

Oracle Internet Directory (OID): is an LDAP directory service, storage infos. about users, applications..
Single Sign-On (SSO): validates user credentials against Oracle Internet Directory
Delegated Administration Service (DAS)
Certificate Authority (OCA): PKI authentication between AS and clients
Directory Integration and Provisioning

Metadata Repositories

Product metadata: used by middle-tier components, also OracleAS Portal, OracleAS Wireless
Identity Management: used by Oracle Identity Management components, also OID, SSO, OCA
Configuration Management: used by components such as DCM

Posted in Oracle | No Comments »

Resize disk on VMWare

July 6th, 2008 . by admin

-first use vmware-vdiskmanager.exe to resize

C:\Program Files\VMware\VMware Workstation\vmware-vdiskmanager.exe
-x 16GB N:\WinAS\Windows2003-cl1.vmdk

-Add the resized disk to another machine
-Power on this machine, using diskpart to extend the volume

c:\diskpart

diskpart> list volume
Remember the (volume number #) of the disk

diskpart> select volume <#>
diskpart> extend
diskpart> exit

-Power off this machine
-Remove the disk from this machnine
-Power on the origin machine

note: Error in Windows Server 2003:
The volume you have selected may not be extended.
Please select another volume and try again.
see: http://support.microsoft.com/kb/841650

Workaround: Use diskpart of a XP machine. It works too!

Posted in VMWare | No Comments »

10g OCP

July 4th, 2008 . by admin

Today: Oracle Database 10g: New Features for Administrators
13h30 – the campus – Eschborn – 134EUR – zu teuer!
nur viel Lärm um nichts!

Posted in Else | No Comments »

RAC on Windows(10): Checks after Install

July 2nd, 2008 . by admin

Services on WRAC1

Services on WRAC2

Check RAC Status

C:\>srvctl config database -d RACDB
wrac1 RACDB1 C:\oracle\product\10.2.0\db_1
wrac2 RACDB2 C:\oracle\product\10.2.0\db_1

Display OCR (Oracle Cluster Registry) information

C:\>ocrcheck
Status of Oracle Cluster Registry is as follows :
Version                  :          2
Total space (kbytes)     :     113568
Used space (kbytes)      :       3784
Available space (kbytes) :     109784
ID                       : 1511685287
Device/File Name         : \\.\ocrcfg
Device/File integrity check succeeded
Device/File not configured
Cluster registry integrity check succeeded

Display status of all services

C:\>C:\oracle\product\10.2.0\crs\BIN\crs_stat -t
Name           Type           Target    State     Host
------------------------------------------------------------
ora....B1.inst application    ONLINE    ONLINE    wrac1
ora....B2.inst application    ONLINE    ONLINE    wrac2
ora.RACDB.db   application    ONLINE    ONLINE    wrac2
ora....SM1.asm application    ONLINE    ONLINE    wrac1
ora....C1.lsnr application    ONLINE    ONLINE    wrac1
ora.wrac1.gsd  application    ONLINE    ONLINE    wrac1
ora.wrac1.ons  application    ONLINE    ONLINE    wrac1
ora.wrac1.vip  application    ONLINE    ONLINE    wrac1
ora....SM2.asm application    ONLINE    ONLINE    wrac2
ora....C2.lsnr application    ONLINE    ONLINE    wrac2
ora.wrac2.gsd  application    ONLINE    ONLINE    wrac2
ora.wrac2.ons  application    ONLINE    ONLINE    wrac2
ora.wrac2.vip  application    ONLINE    ONLINE    wrac2

Check VIP, GSDm ONS, Listener

C:\>srvctl config nodeapps -h
Usage: srvctl config nodeapps -n <node_name> [-a] [-g] [-o] [-s] [-l]
-n <node>           Node name
-a                  Display VIP configuration
-g                  Display GSD configuration
-s                  Display ONS daemon configuration
-l                  Display listener configuration
-h                  Print usage

C:\>srvctl config nodeapps -n WRAC1 -a -g -s -l
VIP exists.: /wrac1-vip.localdomain/192.168.1.11/255.255.255.0/PUBLIC
GSD exists.
ONS daemon exists.
Listener exists.

Instance, nodes?

C:\>srvctl status instance -d racdb -i "racdb1,racdb2"
Instance racdb1 is running on node wrac1
Instance racdb2 is running on node wrac2

Instances?

Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.
C:\Documents and Settings\Administrator>sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Sun Jun 15 21:22:39 2008
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> SELECT * FROM v$active_instances;
INST_NUMBER INST_NAME
----------- ------------------------------------------------------------
  1 WRAC1:racdb1
  2 WRAC2:racdb2

CLUSTER_DATABASE

SQL> show parameter cluster_database
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
cluster_database                     boolean     TRUE
cluster_database_instances           integer     2

Diskgroups

SQL> col name format a20
SQL> select group_number, name, state, type, total_mb from v$asm_diskgroup;
GROUP_NUMBER NAME                 STATE       TYPE     TOTAL_MB
------------ -------------------- ----------- ------ ----------
  1          DATA                 CONNECTED   NORMAL       4062
  2          FLASH                CONNECTED   EXTERN       2031

Diskgroups and Disks

SQL> col Diskgroup format a10
SQL> col Diskname format a10
SQL> select g.name as Diskgroup , d.name as Diskname, d.path, d.mount_status
2  from v$asm_diskgroup G, v$asm_disk D
3  where G.group_number = D.group_number;
DISKGROUP  DISKNAME   PATH                           MOUNT_S
---------- ---------- ------------------------------ -------
  DATA     DATA_0000  \\.\ORCLDISKDATA0              OPENED
  DATA     DATA_0001  \\.\ORCLDISKDATA1              OPENED
  FLASH    FLASH_0000 \\.\ORCLDISKFLA0               OPENED

Posted in Oracle | No Comments »

RAC on Windows(09): Create Database

July 2nd, 2008 . by admin

On WRAC1 Machine run DBCA – Database Configuration Assistant.

DBCA. Welcome.
Accept default Oracle Real Application clusters database
-Click Next

Choice Configure Automatic Storage Management
-Click Next

note: we want first to config ASM for Flash Recovery Area

Dialog Node Selection
-Select all nodes
-Click Next

Dialog ASM credentials
-Input SYS ASM password
-Click OK

Dialog ASM Disk group
-Click Button Create New to create a new Diskgroup for Flash Recovery Area

Dialog Create Disk Group
-Diskgroup Name: FLASH (Flash Recovery Area)
-Redundancy: External
-Click Button Stamp Disks

Dialog asmtool operation
-Choice Add or change label
-Click Next

Dialog Select disk
-choice the last disk, disk with Status
-Input FLA in field Generate stamps with this prefix
-click Next

Stamp disks

Message ASM. Click Finish

Create Disk group
-Choice Redundany External
-Check Select the disk
-Click OK

ASM Diskgroups. Click Finish

-note: We have 2 diskgroups. DATA for database file, FLASH for Flash Recovery File
-click Finish

DBCA – Choice Create Database. Click Next

DBCA – Node Selection. Select all nodes. Click next

DBCA – Choice Custom Database. Click Next

DBCA – Database Identification.
Global Database Name: RACDB.mynet.net
SID Prefix: RACDB
Click Next

DBCA – Management Options.
Accept default.
Click Next

DBCA – Database Credentials
Input password
Click Next

DBCA – Storage Options
Choice Automatic Storage Management (ASM)
Click Next

DBCA – ASM Disk Groups
Default Check Diskgroup DATA
Click Next

DBCA – Database File Locations
Accept Default: Database Area: +DATA
Click Next

DBCA – Recovery Configuaration
-Check Specify Recovery Area
-Browse.. Diskgroup +FLASH for Flash Recovery Area
-Flash Recovery Area Size: 2048 (my disk size 1938MB is too small!)
-Check Enable Archiving

DBCA – Database contents
-Selection the components to installed components
-Why Sample Schemas disabled?
-Enterprise Management Repository option must ?
-Click Next

Standard Database Components
-Uncheck Oracle XML DB
-Click OK
-Click Next

Database Services. Click Next

Intializatiom Parameters. Choice Custom. Click Next

Database Storage. Click Next

Creation Options. Click Finish

Sumamry. Click OK

Creation process.Wait…

Complete. Click OK

Starting Cluster Database. Wait..

Posted in Oracle | No Comments »

RAC on Windows(08): Install Database Software and Create ASM

July 1st, 2008 . by admin

cd "Z:\OSource\oracle 10.2.0.1.0-windows\database"
Double click run setup.exe

Dialog Welcome. Click Next

Dialog Select Installation Type. Choice default Enterprise Edition. Click Next

Dialog Specify Home Details. Overwrite Name: db_1. Click Next

Dialog Specify Hardware Cluster Installation Mode.
-Cehck Checkbox WRAC2 or click Button ‘Select all’
-Click Next

Dialog Product-Specific Prequisite Checks. Click Next if no error

Dialog Select Configuration Option.
-Choice Configure Automatic Storage Management (ASM)
-Input password for ASM SYS

note: this method: You can config ASM before Install database softwate
other way: choice now Install database Software only
and use dbca to create db later. On this process you can config then ASM