My Oracle Blog @myoracleblog - Tumblr Blog

DB Control Not Starting due to Incorrect Timezone

Cause

The Agent does not start because of incorrect time zone.

Solution

check ORACLE_HOME/sysman/admin/supportedtzs.lst and ORACLE_HOME/sysman/admin/nsupportedtzs.lst for a correct value on TZ

Comment the line AgentTZRegion="<some value>" in ORACLE_HOME/<hostname>_<SID>/sysman/config/emd.properties

export TZ=<chosen time zone from step 1>

emctl config agent getTZ

emctl config agent updateTZ

emctl start dbconsole

Note: on 11.1 and higher DB Console, it is enough to run "emctl resettz agent" and then follow the instructions in the output (ie. running th mgmt_target.set_agent_tzrgn procedure) to change or set the correct timezone on the DB Console.

#grid control

•18+ Adults Only

Watch Anya Live on Cam

Anya is live and ready to show you everything. Watch her strip, dance, and perform exclusive shows just for you. Interact in real-time and make your fantasies come true.

✓ Live Streaming✓ Interactive Chat✓ Private Shows✓ HD Quality✓ Free Actions

Free to watch • No registration required • HD streaming

DB Control Not Starting due to Incorrect Timezone

Cause

The Agent does not start because of incorrect time zone.

Solution

check ORACLE_HOME/sysman/admin/supportedtzs.lst and ORACLE_HOME/sysman/admin/nsupportedtzs.lst for a correct value on TZ

Comment the line AgentTZRegion="<some value>" in ORACLE_HOME/<hostname>_<SID>/sysman/config/emd.properties

export TZ=<chosen time zone from step 1>

emctl config agent getTZ

emctl config agent updateTZ

emctl start dbconsole

Note: on 11.1 and higher DB Console, it is enough to run "emctl resettz agent" and then follow the instructions in the output (ie. running th mgmt_target.set_agent_tzrgn procedure) to change or set the correct timezone on the DB Console.

#grid control

DB Control Not Starting due to Incorrect Timezone

Cause

The Agent does not start because of incorrect time zone.

Solution

check ORACLE_HOME/sysman/admin/supportedtzs.lst and ORACLE_HOME/sysman/admin/nsupportedtzs.lst for a correct value on TZ

Comment the line AgentTZRegion="<some value>" in ORACLE_HOME/<hostname>_<SID>/sysman/config/emd.properties

export TZ=<chosen time zone from step 1>

emctl config agent getTZ

emctl config agent updateTZ

emctl start dbconsole

Note: on 11.1 and higher DB Console, it is enough to run "emctl resettz agent" and then follow the instructions in the output (ie. running th mgmt_target.set_agent_tzrgn procedure) to change or set the correct timezone on the DB Console.

#grid control

Manually trigger metric collection in Grid Control

Metric Collection errors are generally down to the following reasons:

Configuration Error as described above

Temporary Collection Errors

Oracle Bugs

Reevaluating Metric Collections

If you are running a Management Agent Release 10.2, then you can use the following command to perform an immediate reevaluation of a metric collection:

emctl control agent runCollection <targetName>:<targetType> <colletionItemName>

emctl control agent runCollection testdb.us.oracle.com:oracle_database oracle_dbconfig

Run "emctl config agent listtargets" to list all the targets in the agent

Run "emctl control agent runCollection"

Eg : To manually upgrade mgmt$tablespaces emctl control agent runCollection testdb.us.oracle.com:oracle_database oracle_dbconfig

Checking scheduler status

emctl status agent scheduler

#grid control

Manually trigger metric collection in Grid Control

Metric Collection errors are generally down to the following reasons:

Configuration Error as described above

Temporary Collection Errors

Oracle Bugs

Reevaluating Metric Collections

If you are running a Management Agent Release 10.2, then you can use the following command to perform an immediate reevaluation of a metric collection:

emctl control agent runCollection <targetName>:<targetType> <colletionItemName>

emctl control agent runCollection testdb.us.oracle.com:oracle_database oracle_dbconfig

Run "emctl config agent listtargets" to list all the targets in the agent

Run "emctl control agent runCollection"

Eg : To manually upgrade mgmt$tablespaces emctl control agent runCollection testdb.us.oracle.com:oracle_database oracle_dbconfig

Checking scheduler status

emctl status agent scheduler

#grid control

•18+ Adults Only

Watch Anya Live on Cam

Anya is live and ready to show you everything. Watch her strip, dance, and perform exclusive shows just for you. Interact in real-time and make your fantasies come true.

✓ Live Streaming✓ Interactive Chat✓ Private Shows✓ HD Quality✓ Free Actions

Free to watch • No registration required • HD streaming

Manually trigger metric collection in Grid Control

Metric Collection errors are generally down to the following reasons:

Configuration Error as described above

Temporary Collection Errors

Oracle Bugs

Reevaluating Metric Collections

If you are running a Management Agent Release 10.2, then you can use the following command to perform an immediate reevaluation of a metric collection:

emctl control agent runCollection <targetName>:<targetType> <colletionItemName>

emctl control agent runCollection testdb.us.oracle.com:oracle_database oracle_dbconfig

Run "emctl config agent listtargets" to list all the targets in the agent

Run "emctl control agent runCollection"

Eg : To manually upgrade mgmt$tablespaces emctl control agent runCollection testdb.us.oracle.com:oracle_database oracle_dbconfig

Checking scheduler status

emctl status agent scheduler

#grid control

How to Use a Windows Server 2003 Network File Share as Storage

dThis document describes how to enable and use a Windows Server 2003 Release 2 Server Network File Share (NFS) as the NFS storage repository

Install the Microsoft Services for NFS component using the Add/Remove Windows Components wizard

Select the Microsoft Services for NFS check box and click OK

After installing the Microsoft Services for NFS component, open the Properties page of the folder or drive that you want to share as NFS storage

Select the Share this folder option button.

Type the share name exactly .

Select the Allow anonymous access check box

Click the Permissions button.

On the Type of access, Change the Type of access to Read-Write.

Click OK.

Select the Security tab, add the ANONYMOUS LOGON account, and give it Full Control permission.

#windows

How to Use a Windows Server 2003 Network File Share as Storage

dThis document describes how to enable and use a Windows Server 2003 Release 2 Server Network File Share (NFS) as the NFS storage repository

Install the Microsoft Services for NFS component using the Add/Remove Windows Components wizard

Select the Microsoft Services for NFS check box and click OK

After installing the Microsoft Services for NFS component, open the Properties page of the folder or drive that you want to share as NFS storage

Select the Share this folder option button.

Type the share name exactly .

Select the Allow anonymous access check box

Click the Permissions button.

On the Type of access, Change the Type of access to Read-Write.

Click OK.

Select the Security tab, add the ANONYMOUS LOGON account, and give it Full Control permission.

#windows

How to Use a Windows Server 2003 Network File Share as Storage

dThis document describes how to enable and use a Windows Server 2003 Release 2 Server Network File Share (NFS) as the NFS storage repository

Install the Microsoft Services for NFS component using the Add/Remove Windows Components wizard

Select the Microsoft Services for NFS check box and click OK

After installing the Microsoft Services for NFS component, open the Properties page of the folder or drive that you want to share as NFS storage

Select the Share this folder option button.

Type the share name exactly .

Select the Allow anonymous access check box

Click the Permissions button.

On the Type of access, Change the Type of access to Read-Write.

Click OK.

Select the Security tab, add the ANONYMOUS LOGON account, and give it Full Control permission.

#windows

Active Database duplication

Oracle 11g introduced the ability to create duplicate databases directly without the need for a backup. This is known as active database duplication. The process is similar to the backup-based duplication

You don't need a backup of the source system, but it does have to be in archive mode

The passwords in the password files must match for both servers

Both the source and destination database servers require a "tnsnames.ora" entry for the destination database

The destination server requires static listener configuration in a "listener.ora" file SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = DB11G.WORLD) (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1) (SID_NAME = DB11G) ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ol5-112-dup2.localdomain)(PORT = 1521)) ) (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) )

The command are

RMAN > DUPLICATE DATABASE TO DB11G FROM ACTIVE DATABASE SPFILE NOFILENAMECHECK;

To create a standby database from active database files:

DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE DORECOVER SPFILE SET "db_unique_name"="foou" COMMENT ''Is a duplicate'' SET LOG_ARCHIVE_DEST_2="service=inst3 ASYNC REGISTER VALID_FOR=(online_logfile,primary_role)" SET FAL_CLIENT="inst3" COMMENT "Is standby" SET FAL_SERVER="inst1" COMMENT "Is primary" NOFILENAMECHECK

#dataguard

•18+ Adults Only

Watch Anya Live on Cam

Anya is live and ready to show you everything. Watch her strip, dance, and perform exclusive shows just for you. Interact in real-time and make your fantasies come true.

✓ Live Streaming✓ Interactive Chat✓ Private Shows✓ HD Quality✓ Free Actions

Free to watch • No registration required • HD streaming

Active Database duplication

Oracle 11g introduced the ability to create duplicate databases directly without the need for a backup. This is known as active database duplication. The process is similar to the backup-based duplication

You don't need a backup of the source system, but it does have to be in archive mode

The passwords in the password files must match for both servers

Both the source and destination database servers require a "tnsnames.ora" entry for the destination database

The destination server requires static listener configuration in a "listener.ora" file SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = DB11G.WORLD) (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1) (SID_NAME = DB11G) ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ol5-112-dup2.localdomain)(PORT = 1521)) ) (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) )

The command are

RMAN > DUPLICATE DATABASE TO DB11G FROM ACTIVE DATABASE SPFILE NOFILENAMECHECK;

To create a standby database from active database files:

DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE DORECOVER SPFILE SET "db_unique_name"="foou" COMMENT ''Is a duplicate'' SET LOG_ARCHIVE_DEST_2="service=inst3 ASYNC REGISTER VALID_FOR=(online_logfile,primary_role)" SET FAL_CLIENT="inst3" COMMENT "Is standby" SET FAL_SERVER="inst1" COMMENT "Is primary" NOFILENAMECHECK

#dataguard

Active Database duplication

Oracle 11g introduced the ability to create duplicate databases directly without the need for a backup. This is known as active database duplication. The process is similar to the backup-based duplication

You don't need a backup of the source system, but it does have to be in archive mode

The passwords in the password files must match for both servers

Both the source and destination database servers require a "tnsnames.ora" entry for the destination database

The destination server requires static listener configuration in a "listener.ora" file SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = DB11G.WORLD) (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1) (SID_NAME = DB11G) ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ol5-112-dup2.localdomain)(PORT = 1521)) ) (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) )

The command are

RMAN > DUPLICATE DATABASE TO DB11G FROM ACTIVE DATABASE SPFILE NOFILENAMECHECK;

To create a standby database from active database files:

DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE DORECOVER SPFILE SET "db_unique_name"="foou" COMMENT ''Is a duplicate'' SET LOG_ARCHIVE_DEST_2="service=inst3 ASYNC REGISTER VALID_FOR=(online_logfile,primary_role)" SET FAL_CLIENT="inst3" COMMENT "Is standby" SET FAL_SERVER="inst1" COMMENT "Is primary" NOFILENAMECHECK

#dataguard

Format Oracle OCFS Drive

Offline cfs drive. Need to offline the drive before you can format it

c:\> ocfsutil /c offlinevol /m X:

To format cfs on O drive

create a drive letter O in the windows

C:\oracle\1020\crs\cfs>ocfsformat /m o: /c 1024 /v data /f

Check ocr status

ocrcheck

To do a manual export ocr

ocrconfig -export <backup_file_name>

To import from the backup

stop crs service first

create an empty file data.ocr

ocrconfig -import <OCR export_filename>

Add ocr disk

create an empty file first

ocrconfig -replace mirror x:\cdata\orange_cluster\data.ocr

Remove ocr disk

ocrconfig -replace ocr

Query voting disk

C:\>crsctl query css votedisk 0. 0 J:\cdata\orange_cluster\votedsk

Add voting disk

create the directory first

c:\> crsctl add css votedisk J:\cdata\orange_cluster\votedsk -force

Delete voting disk

stop the crs service before deleting voting disk

crsctl delete css votedisk <VOTEDISK_LOCATION> -force

#rac

Format Oracle OCFS Drive

Offline cfs drive. Need to offline the drive before you can format it

c:\> ocfsutil /c offlinevol /m X:

To format cfs on O drive

create a drive letter O in the windows

C:\oracle\1020\crs\cfs>ocfsformat /m o: /c 1024 /v data /f

Check ocr status

ocrcheck

To do a manual export ocr

ocrconfig -export <backup_file_name>

To import from the backup

stop crs service first

create an empty file data.ocr

ocrconfig -import <OCR export_filename>

Add ocr disk

create an empty file first

ocrconfig -replace mirror x:\cdata\orange_cluster\data.ocr

Remove ocr disk

ocrconfig -replace ocr

Query voting disk

C:\>crsctl query css votedisk 0. 0 J:\cdata\orange_cluster\votedsk

Add voting disk

create the directory first

c:\> crsctl add css votedisk J:\cdata\orange_cluster\votedsk -force

Delete voting disk

stop the crs service before deleting voting disk

crsctl delete css votedisk <VOTEDISK_LOCATION> -force

#rac

Format Oracle OCFS Drive

Offline cfs drive. Need to offline the drive before you can format it

c:\> ocfsutil /c offlinevol /m X:

To format cfs on O drive

create a drive letter O in the windows

C:\oracle\1020\crs\cfs>ocfsformat /m o: /c 1024 /v data /f

Check ocr status

ocrcheck

To do a manual export ocr

ocrconfig -export <backup_file_name>

To import from the backup

stop crs service first

create an empty file data.ocr

ocrconfig -import <OCR export_filename>

Add ocr disk

create an empty file first

ocrconfig -replace mirror x:\cdata\orange_cluster\data.ocr

Remove ocr disk

ocrconfig -replace ocr

Query voting disk

C:\>crsctl query css votedisk 0. 0 J:\cdata\orange_cluster\votedsk

Add voting disk

create the directory first

c:\> crsctl add css votedisk J:\cdata\orange_cluster\votedsk -force

Delete voting disk

stop the crs service before deleting voting disk

crsctl delete css votedisk <VOTEDISK_LOCATION> -force

#rac

•18+ Adults Only

Watch Anya Live on Cam

Anya is live and ready to show you everything. Watch her strip, dance, and perform exclusive shows just for you. Interact in real-time and make your fantasies come true.

✓ Live Streaming✓ Interactive Chat✓ Private Shows✓ HD Quality✓ Free Actions

Free to watch • No registration required • HD streaming

Administration of OCFS (Format, Delete, Mirror)

Trending Blogs

Last Seen Blogs

My Oracle Blog