Showing posts with label 12c. Show all posts
Showing posts with label 12c. Show all posts

Sunday, September 20, 2020

ORA-15234: target RDBMS compatibility (12.1.0.2.0) exceeds ASM compatibility (10.1.0.0.0)


New Disks are provisioned , which is greater than 2TB but unable to create disk group using those disks
 
devhost:NOTSET:/home/oracle $ oracleasm listdisks  | grep -i CBDEV
CBDEV_DATA1
CBDEV_RECO1
 
devhost:NOTSET:/home/oracle $ oracleasm querydisk CBDEV_DATA1
Disk "CBDEV_DATA1" is a valid ASM disk
 
devhost:NOTSET:/home/oracle $ oracleasm querydisk CBDEV_RECO1
Disk "CBDEV_RECO1" is a valid ASM disk
 
devhost:NOTSET:/home/oracle $ oracleasm querydisk /dev/asm/asm_CBDEV_DATA1
Device "/dev/asm/asm_cbdev_DATA1" is marked an ASM disk with the label "CBDEV_DATA1"
 
devhost:NOTSET:/home/oracle $  oracleasm querydisk /dev/asm/asm_CBDEV_RECO1
Device "/dev/asm/asm_cbdev_RECO1" is marked an ASM disk with the label "CBDEV_RECO1"
 
 
devhost:+ASM:/home/oracle $ sqlplus / as sysasm
 
SQL*Plus: Release 12.1.0.2.0 Production on Fri Mar 27 11:34:48 2020
 
Copyright (c) 1982, 2014, Oracle.  All rights reserved.
 
 
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Automatic Storage Management option
 
SQL> col header for a22
SQL> set pages 999 lines 280
SQL> col path for a33
SQL>  select header_status "Header", mode_status  "Mode", path "Path", lpad(round(os_mb/1024),7)||'Gb' "Disk Size" from   v$asm_disk where path like ‘%CB%’;
 
Header                 Mode    Path                              Disk Size
---------------------- ------- --------------------------------- ---------
PROVISIONED            ONLINE  ORCL:CBDEV_DATA1                    4096Gb
PROVISIONED            ONLINE  ORCL:CBDEV_RECO1                    1024Gb
 
 
SQL> select GROUP_NUMBER,MOUNT_STATUS,STATE,REDUNDANCY,NAME,PATH from v$asm_disk where path like ‘%CB%’;
 
GROUP_NUMBER MOUNT_S STATE    REDUNDA NAME                           PATH
------------ ------- -------- ------- ------------------------------ ---------------------------------
           0 CLOSED  NORMAL   UNKNOWN                                ORCL:CBDEV_DATA1
           0 CLOSED  NORMAL   UNKNOWN                                ORCL:CBDEV_RECO1
 
SQL> select state, name, type from v$asm_diskgroup;
 
STATE       NAME                           TYPE
----------- ------------------------------ ------
MOUNTED     RECO1                        EXTERN
MOUNTED     DATA1                   EXTERN
 
 
SQL> create diskgroup CBDEVDATA1 external redundancy disk  'ORCL:CBDEV_DATA1' name CBDEVDATA1;
create diskgroup CBDEVDATA1 external redundancy disk  'ORCL:CBDEV_DATA1' name CBDEVDATA1
*
ERROR at line 1:
ORA-15018: diskgroup cannot be created
ORA-15099: disk 'ORCL:CBDEV_DATA1' is larger than maximum size of 2097152 MBs
 
 
SQL> select group_number,name,state,compatibility, database_compatibility from v$asm_diskgroup where name like ‘%CB%’ ;
 
GROUP_NUMBER NAME                STATE       COMPATIBILITY                                                DATABASE_COMPATIBILITY
------------ ------------------------------ ----------- ---------------------------------------------------    --------------------------------------------
          11 RECO1                        MOUNTED     10.1.0.0.0                                                   10.1.0.0.0
          13 DATA1                       MOUNTED     10.1.0.0.0                                                   10.1.0.0.0
          
 
 
SQL> col name for a28
SQL> col VALUE for a22
SQL> select name, value,GROUP_NUMBER from  v$asm_attribute where name like 'comp%';
 
 
NAME                         VALUE                  GROUP_NUMBER
---------------------------- ---------------------- ------------
compatible.asm               12.1.0.2.0                        3
compatible.rdbms             12.1.0.2.0                        3
compatible.asm               12.1.0.2.0                        8
compatible.rdbms             12.1.0.2.0                        8
compatible.asm               12.1.0.2.0                       14
compatible.rdbms             12.1.0.2.0                       14
compatible.asm               12.1.0.2.0                       18
compatible.rdbms             12.1.0.2.0                       18
 
8 rows selected.
 
 
SQL> create diskgroup CBRECO1 external redundancy disk  'ORCL:CBDEV_RECO1' name CBDEV_RECO1;
 
Diskgroup created.
 
SQL> select group_number,name,state,compatibility, database_compatibility from v$asm_diskgroup;
 
GROUP_NUMBER NAME                         STATE       COMPATIBILITY                                                DATABASE_COMPATIBILITY
------------ ---------------------------- ----------- ------------------------------------------------------------ -------------------------------------------------
          11 RECO1                      MOUNTED     10.1.0.0.0                                                   10.1.0.0.0
          13 DATA1                     MOUNTED     10.1.0.0.0                                                   10.1.0.0.0
          15 CBRECO1                     MOUNTED     10.1.0.0.0                                                   10.1.0.0.0
 
16 rows selected.
 
Note:
Starting with Oracle ASM version 12.2.0.1, the minimum and default settings for Oracle ASM disk group attributes are:
COMPATIBLE.ASM = 11.2.0.2 and COMPATIBLE.RDBMS = 10.1 for EXTERNAL, NORMAL, and HIGH redundancy disk groups
 
COMPATIBLE.ASM = 12.2.0.1 and COMPATIBLE.RDBMS = 12.2.0.1 for FLEX and EXTENDED disk groups
 
 
SQL> create diskgroup CBDEVDATA1 external redundancy disk  'ORCL:CBDEV_DATA1' name CBDEVDATA1 attribute  'compatible.rdbms'='12.1.0.2.0';
create diskgroup CBDEVDATA1 external redundancy disk  'ORCL:CBDEV_DATA1' name CBDEVDATA1 attribute  'compatible.rdbms'='12.1.0.2.0'
*
ERROR at line 1:
ORA-15018: diskgroup cannot be created
ORA-15234: target RDBMS compatibility (12.1.0.2.0) exceeds ASM compatibility (10.1.0.0.0)
 
SQL>  create diskgroup CBDEVDATA1 external redundancy disk  'ORCL:CBDEV_DATA1' name CBDEVDATA1 attribute  'compatible.asm'='12.1.0.2.0' ,  'compatible.rdbms'='12.1.0.2.0';
 
Diskgroup created.
 
SQL>  select group_number,name,state,compatibility, database_compatibility from v$asm_diskgroup where name like '%CB%';
 
GROUP_NUMBER NAME                         STATE       COMPATIBILITY                                                DATABASE_COMPATIBILITY
------------ ---------------------------- --------------------------------- ---------------------------------
          16 CBDEVDATA1                  MOUNTED     12.1.0.2.0                                                   12.1.0.2.0
          15 CBRECO1                     MOUNTED     10.1.0.0.0                                                   10.1.0.0.0
 
SQL> select GROUP_NUMBER,MOUNT_STATUS,STATE,REDUNDANCY,NAME,PATH from v$asm_disk where name like '%CB%';
 
GROUP_NUMBER MOUNT_S STATE    REDUNDA NAME                         PATH
------------ ------- -------- ------- ---------------------------- ---------------------------------
          16 CACHED  NORMAL   UNKNOWN CBDEVDATA1                  ORCL:CBDEV_DATA1
          15 CACHED  NORMAL   UNKNOWN CBDEV_RECO1                 ORCL:CBDEV_RECO1
 
SQL> select header_status "Header", mode_status  "Mode", path "Path", lpad(round(os_mb/1024),7)||'Gb' "Disk Size" from   v$asm_disk where path like '%CB%';
 
Header                 Mode    Path                              Disk Size
---------------------- ------- --------------------------------- ---------
MEMBER                 ONLINE  ORCL:CBDEV_DATA1                    4096Gb
MEMBER                 ONLINE  ORCL:CBDEV_RECO1                    1024Gb
 
So finally, I have successfully created DG with 4TB disk
 

Friday, November 8, 2019

expdp ORA-01775: looping chain of synonyms



While doing export on my 12.1 database i get below error

oracledev.domain.com:REPODB:/home/oracle $ expdp directory=STATSDIR dumpfile=REPODB_Triggers.dmp logfile=exp_REPODB_Triggers.log include=TRIGGER metrics=y schemas= Workers

Export: Release 12.1.0.2.0 - Production on Wed Oct 23 10:48:44 2019

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

Username: / as sysdba

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
ORA-39001: invalid argument value
ORA-01775: looping chain of synonyms



FIX:


SQL> Select owner, object_name, object_type, status   from dba_objects  where object_name like '%SYS_EXPORT%';

OWNER
--------------------------------------------------------------------------------
OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE             STATUS
----------------------- -------
PUBLIC
SYS_EXPORT_SCHEMA_01
SYNONYM                 VALID

SYSTEM
SYS_EXPORT_TABLE_01
TABLE                   VALID




connect / as sysdba
drop public synonym sys_export_schema_01;

Now rerun export again

(OR)

If you dont want to drop the table now then give some job name ( job_name=<JOB_NAME>" ) and run the export 



Referrence:
DataPump Import Results In ORA-39001 Invalid Argument Value ORA-1775 Looping Chain Of Synonyms (Doc ID 459151.1)


IMPDP Job Hanging On STATISTICS/MARKER


DB Version : 12.1
OS Version : RHEL 6

While doing import for one of the Env my impdp job just waiting at STATISTICS/MARKER step and taking very very long though i'm doing small set of data import, and if i check the JOB status and it shows job is 100% Done and there is no movement at all even in DB Alert log

Impdp job at “Processing object type SCHEMA_EXPORT/STATISTICS/MARKER”

After doing some research online and according to oracle looks like this is Due to the BUG and below is the work around/Solutions


Data pump Import Job Is Hanging On STATISTICS/MARKER (Doc ID 2135702.1)


Sunday, February 3, 2019

WARNING OGG-01932 Datastore already exists.


After Server Reboot where OGG is running my goldengate manager is unable to start and getting below error

GGSCI (oradev.domain.com) 1> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     STOPPED
JAGENT      STOPPED
EXTRACT     RUNNING     EXTDEVQ1    00:00:02      00:00:07
EXTRACT     RUNNING     EXTDEVQ1    00:00:04      00:00:09
EXTRACT     RUNNING     EXTDEVQ1    00:00:01      00:00:09
EXTRACT     RUNNING     EXTDEVQ1    00:00:02      00:00:03
EXTRACT     RUNNING     PXTDEVQ1    00:00:00      00:00:08
EXTRACT     RUNNING     PXTDEVQ1    00:00:00      00:00:03
EXTRACT     RUNNING     PXTDEVQ1    00:00:00      00:00:05
EXTRACT     RUNNING     PXTDEVQ1    00:00:00      00:00:02


GGSCI (oradev.domain.com) 1> start mgr
Manager started.
2019-01-17 10:37:29  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): start mgr.
2019-01-17 10:37:29  WARNING OGG-01877  Oracle GoldenGate Manager for Oracle, mgr.prm:  Missing explicit accessrule for server collector.
2019-01-17 10:37:29  INFO    OGG-00960  Oracle GoldenGate Manager for Oracle, mgr.prm:  Access granted (rule #7).
2019-01-17 10:37:29  INFO    OGG-00983  Oracle GoldenGate Manager for Oracle, mgr.prm:  Manager started (port 7809).
2019-01-17 10:37:29  WARNING OGG-01934  Oracle GoldenGate Manager for Oracle, mgr.prm:  Datastore repair failed.
2019-01-17 10:37:29  WARNING OGG-06530  Oracle GoldenGate Manager for Oracle, mgr.prm:  Berkeley Database encountered a Critical error.
2019-01-17 10:37:29  WARNING OGG-00543  Oracle GoldenGate Manager for Oracle, mgr.prm:  Unexpected threading library failure. Error code 16 (Device or resource busy).


GGSCI (oradev.domain.com) 13> delete datastore
Are you sure you want to delete the datastore? y
BDB0118 shmat: id 1679097930: unable to attach to shared system memory region: Invalid argument
BDB0118 shmat: id 1679097930: unable to attach to shared system memory region: Invalid argument
2019-01-17T15:37:57Z  INFO    OGG-06492  Datastore deleted
GGSCI (oradev.domain.com) 14>

GGSCI (oradev.domain.com) 14> info datastore
2019-01-17T15:38:03Z  WARNING OGG-06307  Datastore does not exist.

GGSCI (oradev.domain.com) 15> Create datastore mmap
2019-01-17T15:38:13Z  WARNING OGG-01933  Datastore create failed.

GGSCI (oradev.domain.com) 18> Create datastore
2019-01-17T15:39:44Z  WARNING OGG-01933  Datastore XTeate failed.

oradev:NOTSET:/home/oracle $ cd /goldengate/home/
oradev:NOTSET:/goldengate/home $ cd dirbdb
-bash: cd: dirbdb: No such file or directory

Looks like 'dirdbd' Directory is missing or Lost

oradev:NOTSET:/goldengate/home $ mkdir dirbdb

GGSCI (oradev.domain.com) 1> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     STOPPED
JAGENT      STOPPED
EXTRACT     STOPPED     EXTDEVQ1    00:00:46      00:17:59
EXTRACT     STOPPED     EXTDEVQ1    00:00:43      00:17:59
EXTRACT     STOPPED     EXTDEVQ1    00:00:44      00:17:58
EXTRACT     ABENDED     EXTDEVQ1    00:00:02      00:18:39
EXTRACT     STOPPED     PXTDEVQ1    00:00:00      00:17:57
EXTRACT     STOPPED     PXTDEVQ1    00:00:00      00:17:56
EXTRACT     STOPPED     PXTDEVQ1    00:00:00      00:17:55
EXTRACT     STOPPED     PXTDEVQ1    00:00:00      00:17:55


GGSCI (oradev.domain.com) 2> Create datastore mmap
2019-01-17T15:55:06Z  WARNING OGG-01932  Datastore already exists.

GGSCI (oradev.domain.com) 3> info datastore
2019-01-17T15:55:14Z  INFO    OGG-06308  Datastore uses memory mapped (MMAP) environment files.

GGSCI (oradev.domain.com) 5> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     STOPPED
JAGENT      STOPPED
EXTRACT     STOPPED     EXTDEVQ1    00:00:46      00:18:40
EXTRACT     STOPPED     EXTDEVQ1    00:00:43      00:18:39
EXTRACT     STOPPED     EXTDEVQ1    00:00:44      00:18:39
EXTRACT     ABENDED     EXTDEVQ1    00:00:02      00:19:20
EXTRACT     STOPPED     PXTDEVQ1    00:00:00      00:18:38
EXTRACT     STOPPED     PXTDEVQ1    00:00:00      00:18:37
EXTRACT     STOPPED     PXTDEVQ1    00:00:00      00:18:36
EXTRACT     STOPPED     PXTDEVQ1    00:00:00      00:18:35

GGSCI (oradev.domain.com) 6> start mgr
Manager started.

GGSCI (oradev.domain.com) 7> info mgr

Manager is running (IP port oradev.domain.com.7809, Process ID 139824).



Sunday, January 27, 2019

Goldengate Performance Metric Server OGG 12.3



The Performance Metrics Server (PMSRVR) introduced in OGG 12.3 version and uses the metrics service to collect and store instance deployment performance results

We can use Performance Metrics Server in both CLASSIC and MICROSERVICES Architecture modes

When PMSRVR is started for the first time, the sequence of commands must be:

START PMSRVR
START MANAGER
START *
START JAGENT

Command                                          Description 

INFO PMSRVR                        Returns information about the PMSRVR. 
START PMSRVR                    Starts the PMSRVR. 
STATUS PMSRVR                  Returns the state of the PMSRVR. 
STOP PMSRVR                      Stops the PMSRVR.
START PMSRVR                    Starts the PMSRVR.


GGSCI (prod01.domain.com) 4> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING
JAGENT       RUNNING
PMSRVR    STOPPED
EXTRACT    RUNNING     EXTPSTDB    00:00:00      00:00:00
EXTRACT    RUNNING     PMPUPDB    00:00:00      00:00:01
REPLICAT    RUNNING     REPTGDB      00:00:00      00:00:05

GGSCI (prod01.domain.com) 4> start pmsrvr
PMSRVR started

GGSCI (prod01.domain.com) 4> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING
JAGENT       RUNNING
PMSRVR    RUNNING
EXTRACT    RUNNING     EXTPSTDB    00:00:00      00:00:00
EXTRACT    RUNNING     PMPUPDB    00:00:00      00:00:00
REPLICAT    RUNNING     REPTGDB      00:00:00      00:00:01


ALL "datastore" commands are deprecated in Oracle GoldenGate 12.3.x and above.

If using GoldenGate 12.3.x and above then DO NOT execute delete datastore, create datastore commands if you do so you will
receive "command not found" type errors.


"start pmsrvr" will create and manage $OGG_HOME/dirbdb

Enable monitoring options are changed

ENABLEMONITORING [ UDP ]
ENABLEMONITORING [ UDP ] [ UDPPORT portnumber ] [ HTTPPORT portnumber ]

default port is 9004



Sunday, December 30, 2018

Oracle Golden Gate – Performance Toolkit Monitor

  
This PTM is new in 12c version and it gives users to view and monitor GG in real time GUI mode 
Download jar file from the below location and place it in some location 

https://www.oracle.com/technetwork/middleware/goldengate/oracle-goldengate-exchange-3805527.html 
  
Pre req’s : 

1.       Add  “ENABLEMONITORING” in GLOBALS file 
  
      edit params ./GLOBALS 
              add  ENABLEMONITORING 
  
2.       from your local open command prompt and check java is installed or not 
from your local pc: run--> cmd

 C:\Users\myuser> java -jar <complete_path_of_jarfile> 

Ex:    java -jar C:\Users\myuser\Desktop\ogg-performancetoolkit-3810657.jar 
  
  
Go to File à Connect à New Connection 
  
  
  FIill in the server loggin details and then you are all set to use it, Thanks

Auto Scroll Stop Scroll