Raj Kiran's: 2013

Friday, September 13, 2013

Strage behavior on renaming an IOT table - oracle 11g - 11.2.0.2.0 "truncating (as requested) before column"

I have created a heap table,
then an IOT with CTAS from above table
and then altered the IOT to rename it.

as soon as i ran a select on dba_tables, i noticed the Truncating commands and was little scared.
Since the issue is not reproducible, didn't open any SR with Oracle and still wonder why that strange output was shown. If anybody noticed the similar behavior and got the reason, please let me know.

19:56:51 SQL> conn raj/***
Connected.
19:56:54 SQL> CREATE TABLE test123
19:56:55 2 ( asd NUMBER(6)
19:56:55 3 , first_name VARCHAR2(20)
19:56:55 4 , CONSTRAINT test123_pk
19:56:55 5 PRIMARY KEY (asd)
19:56:55 6 );

Table created.

Elapsed: 00:00:00.60

19:57:09 SQL> create table test321 (asd, first_name,
19:57:09 2 constraint new_pk
19:57:09 3 primary key (asd))
19:57:09 4 organization index
19:57:09 5 as select * from test123;

Table created.

Elapsed: 00:00:00.03
19:57:49 SQL>
19:57:54 SQL> alter table test321 rename to testraj;

Table altered.

Elapsed: 00:00:00.96
19:59:31 SQL> select * from dba_tables where table_name ='TESTRAJ';
truncating (as requested) before column MAX_TRANS

truncating (as requested) before column INITIAL_EXTENT

truncating (as requested) before column NEXT_EXTENT

truncating (as requested) before column MIN_EXTENTS

truncating (as requested) before column MAX_EXTENTS

truncating (as requested) before column PCT_INCREASE

truncating (as requested) before column FREELISTS

truncating (as requested) before column FREELIST_GROUPS

truncating (as requested) before column NUM_ROWS

truncating (as requested) before column BLOCKS

truncating (as requested) before column EMPTY_BLOCKS

truncating (as requested) before column AVG_SPACE

truncating (as requested) before column CHAIN_CNT

truncating (as requested) before column AVG_ROW_LEN

truncating (as requested) before column AVG_SPACE_FREELIST_BLOCKS

truncating (as requested) before column NUM_FREELIST_BLOCKS

rows will be truncated

rows will be truncated

rows will be truncated

rows will be truncated

rows will be truncated

rows will be truncated

rows will be truncated

rows will be truncated

rows will be truncated

rows will be truncated

rows will be truncated

rows will be truncated

rows will be truncated

rows will be truncated

rows will be truncated

rows will be truncated

rows will be truncated

rows will be truncated

rows will be truncated

rows will be truncated

rows will be truncated

rows will be truncated

rows will be truncated

rows will be truncated

rows will be truncated

rows will be truncated

rows will be truncated

OWNER TABLE_NAME TABLESPACE_NAME CLUSTER_NAME IOT_NAME STATUS PCT_FREE PCT_USED INI_TRANS LOG B D
---------- ------------------------------ --------------- ------------------------------ ------------------------------ -------- -------------------- -------------------- -------------------- --- - -
RAJ TESTRAJ VALID 0 0 0 N

Elapsed: 00:00:00.36
20:00:25 SQL>

Tuesday, September 10, 2013

ORA-00600 when using EXPDP & IMPDP on a RAC Database.

When exporting metadata (without data) using EXPDP, things often proceed smoothly. However, when performing an IMPDP using the sqlfile mode, some Oracle RAC environments may trigger an ORA-00600 internal error. This is recognized by Oracle Support as a bug (no patch may yet exist), so caution is needed before running IMPDP in production.

The Scenario & Symptoms

EXPDP command (metadata-only export) completes without issues.

IMPDP with sqlfile mode fails with an internal error:


ORA-00600: internal error code, arguments: [15851], [4], [4], [1], [3], …

The alert logs show that Oracle issues “ALTER SYSTEM SET SERVICE_NAMES” during the import attempt, introducing a generated SYS$SYS service name, e.g., SYS$SYS.KUPC$C_....
The jobs DM00/ DW00 (Data Pump processes) may attempt operations that lead to the error trace.
No lasting impact to the database is typically observed, but the import fails and the sqlfile is not created.

Sample Log Extract (from alert log)


ALTER SYSTEM SET service_names='SRV_JOB','SRV_ORCL','ORCL','SYS$SYS.KUPC$C_4_20130826105315.ORCL' SCOPE=MEMORY SID='ORCL_4';
ALTER SYSTEM SET service_names='SYS$SYS.KUPC$C_4_20130826105315.ORCL','SRV_JOB','SRV_ORCL','ORCL',... SCOPE=MEMORY SID='ORCL_4';
DM00 started ...
DW00 started ...
ORA-00600: internal error code, arguments: [15851], [4], [4], [1], [3], …

It’s noted that this may be triggered specifically when running IMPDP in a RAC context, due to internal handling of services and metadata injection.

Possible Root Causes (RCA) & Mechanisms

Dynamic Service Registration / Modification
Data Pump (especially in RAC) may issue or adjust SERVICE_NAMES entries to manage worker processes across instances. The generation of internal service names (SYS$SYS.*) might cause inconsistencies or unexpected internal state transitions in the process.
Bug in Data Pump / RAC Interaction
The presence of [15851] in the ORA-00600 arguments suggests a known issue in the Oracle kernel or Data Pump internals, where a corner-case in metadata import on RAC nodes triggers an undesired internal assertion or state.
Incomplete Statistics / Missing Fixed Object Stats
As you observed, running DBMS_STATS.GATHER_FIXED_OBJECTS_STATS() is sometimes proposed as a workaround, but that alone may not fully mask the underlying bug or prevent the failure in all environments.

Workaround & Mitigation Strategies

Execute:
```
EXEC DBMS_STATS.GATHER_FIXED_OBJECTS_STATS;
```
This collects statistics on fixed dictionary objects, which might prevent certain internal errors. However, in your tests, this did not reliably mitigate the issue.
Use metadata-only EXPDP / IMPDP without sqlfile mode when feasible.
Instead of sqlfile, use DIRECT import of metadata (i.e. let IMPDP apply changes rather than generating script), while monitoring carefully in lower environments first.
Validate that all RAC instances are stable, with consistent service configurations, before initiating the import.
If possible, run the import on a single instance (non-RAC) environment, generate the SQL file there, and then apply it in the RAC environment manually after validation.
Contact Oracle Support, referencing the internal error arguments [15851] and your database version/RAC configuration, to see if they have a patch or workaround for your specific version.

Best Practices & Considerations

Always test Data Pump operations in lower environments before running in production, especially on RAC architectures.
Maintain up-to-date Oracle patches and PSU bundles, because some internal bugs may be fixed in patch sets.
Collect full diagnostics: run ADRCTL or ADRCI to collect the incident dump, trace files, and metadata, and provide them to Oracle Support:
```
Use ADRCI or Support Workbench to package the incident (see Note 411.1 on MOS).
```
Monitor your trace directory size limits—errors like ORA-48913 (writing to trace file failed due to size limit) suggest your trace file quotas may have been exceeded.
Archive trace files and incidents promptly to avoid file system overflow.
Validate service name consistency across RAC nodes, and avoid unnecessary dynamic service additions unless absolutely needed.

Summary

The ORA-00600 [15851] error during IMPDP … SQLFILE in a RAC environment is a known internal issue triggered by service modifications in Data Pump.
While GATHER_FIXED_OBJECTS_STATS may sometimes alleviate the issue, it is not a guaranteed fix.
Use alternative import strategies (direct metadata import, non-RAC staging, careful scripting) when possible, and involve Oracle Support with full diagnostics if needed.

Saturday, May 18, 2013

Definition of a Table Using defgen Utility (Oracle GoldenGate)

Definition of a table using defgen Utility (oracle golden gate) - simple script to automatically get your table definitions if you are using UserExits or if you are relying on the definition file rather than the replicat parameter file.. Do not forget to update your table definitions when the source table has been modified.

Important Note: Always update your definition files (DEFSFILE) when the source table structure changes, to avoid replicat failures. Test in non-production environments first.
Btw, edit the home, golden gate locations accordingly to suit your environment..

Why Use `defgen`?

In certain GoldenGate replication setups, especially when using DEFSFILE or UserExits, the replicat process expects table definitions externally instead of deriving them from the parameter file.
defgen helps you generate those definitions (metadata) automatically from your Oracle source database (via queries on DBA_TABLES) into a .def file.
This approach helps ensure consistency, reduce manual errors, and support dynamic table changes.

Script: def_gen.sh

#!/bin/bash

# ---------------------------------------------------------------------

# def_gen.sh — Generate GoldenGate DEFSFILE (table definitions) automatically

# Usage: ./def_gen.sh

# Author: Raj

# Adjust below variables to your environment (Oracle home, GoldenGate paths, owners)

# ---------------------------------------------------------------------

# Adjust these to suit your system

ORACLE_BASE="/u01/orcl"

GG_HOME="/u01/orcl/goldengate/111"

# Source your Oracle environment (ORACLE_HOME, PATH, etc.)

. ${ORACLE_BASE}/.profile

cd ${ORACLE_BASE}

cd ${ORACLE_BASE}/gg

# Move old .obey files to logs directory (backup/archive)

if [ ! -d logs ]; then

mkdir logs

mv *.obey logs/ 2>/dev/null

TIMESTAMP=$(date +"%m-%d-%y-%H-%M-%S")

OBEY_FILE="${ORACLE_BASE}/gg/defgen_${TIMESTAMP}.obey"

DEFINITION_FILE="${ORACLE_BASE}/gg/defgen_${TIMESTAMP}.def"

# Use SQL*Plus to generate the .obey file (instructions for defgen)

sqlplus -s / as sysdba <<EOF

SET ECHO OFF

SET HEAD OFF

SET TRIMSPOOL ON

SET FEEDBACK OFF

SPOOL ${OBEY_FILE}

PROMPT --DEFSFILE

PROMPT DEFSFILE ${DEFINITION_FILE},PURGE

PROMPT USERID ggs, PASSWORD <your_password_here>

SELECT 'TABLE ' || OWNER || '.' || TABLE_NAME || ';'

FROM DBA_TABLES

WHERE OWNER IN (

'SCOTT',

'HR'

-- Add your schemas here; you can also filter by TABLE_NAME if desired

);

SPOOL OFF

EOF

# Change directory to GoldenGate home

cd ${GG_HOME}

# Execute defgen with the generated obey file

# Alternatively: echo "obey ${OBEY_FILE}" | ./defgen

./defgen PARAMFILE ${OBEY_FILE}

# List the new definition files

ls -ltr ${ORACLE_BASE}/gg

Sample Output: `.def` File

When you run the script successfully, your .def output file will look something like this:

raj@localhost > cat defgen_05-18-13-02-24-59.def

* Definitions created/modified 2013-05-18 02:25
*
* Field descriptions for each column entry:
*
* 1 Name
* 2 Data Type
* 3 External Length
* 4 Fetch Offset
* 5 Scale
* 6 Level
* 7 Null
* 8 Bump if Odd
* 9 Internal Length
* 10 Binary Length
* 11 Table Length
* 12 Most Significant DT
* 13 Least Significant DT
* 14 High Precision
* 15 Low Precision
* 16 Elementary Item
* 17 Occurs
* 18 Key Column
* 19 Sub Data Type
*
*
Definition for table SCOTT.VALUES_TAB
Record length: 430
Syskey: 0
Columns: 5
ID 64 50 0 0 0 1 0 50 50 50 0 0 0 0 1 0 1 2
NAME 64 200 56 0 0 1 0 200 200 0 0 0 0 0 1 0 0 0
VALUE1 64 50 262 0 0 1 0 50 50 50 0 0 0 0 1 0 0 2
VALUE2 64 50 318 0 0 1 0 50 50 50 0 0 0 0 1 0 0 2
VALUE3 64 50 374 0 0 1 0 50 50 50 0 0 0 0 1 0 0 2
End of definition

Each line in the table describes a column’s metadata, with positional fields (Name, Data Type, Nullability, etc.) required by GoldenGate.

Best Practices (Based on Experience)

Dynamic Schema Lists
Instead of hardcoding OWNER IN ( … ), you can generate the list of schemas dynamically (or via a control table) so you don’t need to edit the script when schemas change.
Filter by Table Name or Last DDL Time
Optionally filter your SELECT by TABLE_NAME or by recent LAST_DDL_TIME to regenerate definitions only for recently modified tables.
Parameterize Passwords Securely
Avoid putting plain-text passwords in the script. Use encrypted wallets, environment variables, or Oracle OS authentication for security.
Dry-Run Mode
Introduce a -n or --dry-run flag to echo commands instead of executing defgen, for validation before production runs.
Logging & Alerts
After running the script, capture return codes and send alerts (email) if defgen fails or if the .def file is empty.
Backup Existing Definition Files
Before overwriting, archive prior .def files or maintain a version control system (e.g. Git) to track changes.
Schedule via Cron / Orchestration Engine
Automate this script (e.g. once daily or before batch runs) using cron or orchestration tools like Ansible, making sure only one instance runs at a time.
Validation Post-Run
After generating .def, run a validation check:

Ensure non-empty .def file.
Validate that it includes all expected tables.
Optionally execute a test replicat process in a dev/test cluster.

Tuesday, May 14, 2013

Oracle Golden gate - Long running transactions while stopping an extract ?

Below is how you can find it out and kill if needed.

GGSCI (ggnode1) 7>send extract EXRAJ, showtrans duration 20 MIN

Sending showtrans request to EXTRACT EXRAJ ...

Oldest redo log files necessary to restart Extract are:

Redo Thread 1, Redo Log Sequence Number 74058, SCN 1586.3900894393 (6815719025849), RBA 104066064
Redo Thread 2, Redo Log Sequence Number 79546, SCN 1586.3894494112 (6815712625568), RBA 1458358288

------------------------------------------------------------
XID: 1630.17.201166
Items: 1
Extract: EXRAJ
Redo Thread: 1
Start Time: 2013-05-10:21:43:50
SCN: 1586.3900894393 (6815719025849)
Redo Seq: 74058
Redo RBA: 104066064
Status: Running

------------------------------------------------------------
XID: 9068.29.296116
Items: 1
Extract: EXRAJ
Redo Thread: 2
Start Time: 2013-05-10:21:13:50
SCN: 1586.3894494112 (6815712625568)
Redo Seq: 79546
Redo RBA: 1458358288
Status: Running

------------------------------------------------------------
XID: 8805.6.296139
Items: 1
Extract: EXRAJ
Redo Thread: 2
Start Time: 2013-05-10:21:24:33
SCN: 1586.3896755063 (6815714886519)
Redo Seq: 79547
Redo RBA: 791874576
Status: Running

22:09:08 SQL> select * from gv$transaction where xidusn=8805;

INST_ID ADDR XIDUSN XIDSLOT XIDSQN UBAFIL UBABLK UBASQN UBAREC STATUS START_TIME START_SCNB START_SCNW START_UEXT START_UBAFIL
---------- ---------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------------- -------------------- ---------- ---------- ---------- ------------
START_UBABLK START_UBASQN START_UBAREC SES_ADDR FLAG SPA REC NOU PTX NAME PRV_XIDUSN PRV_XIDSLT PRV_XIDSQN PTX_XIDUSN
------------ ------------ ------------ ---------------- ---------- --- --- --- --- ---------------------------------------------------------------------- ---------- ---------- ---------- ----------
PTX_XIDSLT PTX_XIDSQN DSCN-B DSCN-W USED_UBLK USED_UREC LOG_IO PHY_IO CR_GET CR_CHANGE START_DATE DSCN_BASE DSCN_WRAP START_SCN DEPENDENT_SCN XID
---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- --------------- ---------- ---------- ---------- ------------- ----------------
PRV_XID PTX_XID
---------------- ----------------
2 0000001BFF3DEBD8 8805 6 296139 856 125452 27952 5 ACTIVE 05/10/13 21:24:33 3896755063 1586 4 856
125452 27952 5 0000001C84587F40 7683 NO NO NO NO 0 0 0 0
0 0 0 0 1 1 5 0 0 0 10-MAY-13 0 0 6.8157E+12 0 22650006000484CB
0000000000000000 0000000000000000

22:09:38 SQL> select sid,serial#,event,machine,sql_id,seconds_in_wait,prev_sql_id,module,program,action from gv$session where taddr='0000001BFF3DEBD8';

SID SERIAL# EVENT MACHINE SQL_ID SECONDS_IN_WAIT PREV_SQL_ID MODULE PROGRAM
----- ---------- ------------------------------ --------------- ------------- --------------- ------------- -------------- ------------------------------------------------
ACTION
----------------------------------------------------------------
9871 167 SQL*Net message from client client07 2710 7zwu0n8myp5vn occ-raj-jar occworker@client07 (TNS V1-V3)

20f669b057722

22:09:43 SQL> select
hash_value, address,
executions,buffer_gets, disk_reads,
round(buffer_gets/decode(executions, 0, 1, executions), 1) avg_gets,
round(disk_reads/decode(executions, 0, 1, executions), 1) avg_disk,
last_load_time,
module,
sql_fulltext
from v$sqlarea
where sql_id='&sql_id';

Enter value for sql_id: 7zwu0n8myp5vn

HASH_VALUE ADDRESS EXECUTIONS BUFFER_GETS DISK_READS AVG_GETS AVG_DISK LAST_LOAD_TIME MODULE
---------- ---------------- ---------- ----------- ---------- ---------- ---------- ------------------- -------------------
SQL_FULLTEXT
--------------------------------------------------------------------------------
669685620 0000001A4E4E8840 16774570 43243144 5728 2.6 0 10-MAY-13 occ-raj-jarers
INSERT INTO user_info (uid, part_key, t_id, uname) VALUES (:uid, :part_key, :t_id) /*Truncated the sql*/

you will see the following error message in ggserr.log file

2013-05-10 22:15:15 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): send EXRAJ showtrans duration 45m.
2013-05-10 22:15:16 INFO OGG-01021 Oracle GoldenGate Capture for Oracle, EXRAJ.prm: Command received from GGSCI: showtrans duration 45m.
Long Running Transaction: XID 8805.6.296139, Items 1, Extract EXRAJ, Redo Thread 2, SCN 1586.3896755063 (6815714886519), Redo Seq #79547, Redo RBA 791874576.
2013-05-10 22:15:20 WARNING OGG-01027 Oracle GoldenGate Capture for Oracle, EXRAJ.prm: Long Running Transaction: XID 8805.6.296139, Items 1, Extract EXRAJ, Redo Thread 2, SCN 1586.3896755063 (6815714886519), Redo Seq #79547, Redo RBA 791874576.
2013-05-10 22:15:26 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): send EXRAJ showtrans duration 90m.
2013-05-10 22:15:28 INFO OGG-01021 Oracle GoldenGate Capture for Oracle, EXRAJ.prm: Command received from GGSCI: showtrans duration 90m.

select logon_time,status,LAST_CALL_ET from gv$session where sid=9871 and inst_id=2;

LOGON_TIME STATUS LAST_CALL_ET
------------------- -------- ------------
05/10/2013 19:26:36 INACTIVE 3226

or you can use:

set echo on
set timing on
col sid format 999999
col serial# format 999999
alter session set nls_date_format='MM/DD/YYYY HH24:MI:SS';
select t.start_time,t.status TSTATUS, s.status SSTATUS,s.sid, s.serial# ,s.machine , s.sql_id,s.prev_sql_id,s.process,t.XIDUSN||'.'||t.XIDSLOT||'.'||t.XIDSQN XID from gv$transaction t, gv$session s where t.addr=s.taddr and t.inst_id=s.inst_id and t.start_date < (sysdate-1/142) order by t.start_time;

-- if needed, you can go ahead and kill the sql (if it is not of a major impact)

alter system kill session '9871,167';

Saturday, May 4, 2013

Enabling Index Monitoring to find if the indexes are being used:

::::::::::::::
1.sql
::::::::::::::
select table_name, index_name, MONITORING, USED from v$object_usage where index_name in
(
'PUSER_IDX_3',
'PUSER_IDX_4',
'PUSER_IDX_6',
'PUSER_IDX_3',
'PUSER_IDX_4',
'USER_IDX'
)
/
::::::::::::::
2.sql
::::::::::::::
-- note not altering the session as i am identifying the index with schema name

--spool enable_monitoring.log
alter index RAJ.PUSER_IDX_3 monitoring usage;
alter index RAJ.PUSER_IDX_4 monitoring usage;
alter index RAJ.PUSER_IDX_6 monitoring usage;
alter index RAJ.PUSER_IDX_3 monitoring usage;
alter index RAJ.PUSER_IDX_4 monitoring usage;
alter index ORACLE.USER_IDX monitoring usage;
::::::::::::::
3.sql
::::::::::::::
select table_name, index_name, MONITORING, USED from v$object_usage where index_name in
(
'PUSER_IDX_3',
'PUSER_IDX_4',
'PUSER_IDX_6',
'PUSER_IDX_3',
'PUSER_IDX_4',
'USER_IDX'
)
/

-- Sql to check the index monitoring

select du.username, io.name index_name, t.name table_name,
decode(bitand(i.flags, 65536), 0, 'NO', 'YES') monitor,
decode(bitand(ou.flags, 1), 0, 'NO', 'YES') used,
ou.start_monitoring,
ou.end_monitoring
from sys.obj$ io, sys.obj$ t, sys.ind$ i, sys.object_usage ou, dba_users du
where io.owner# = du.USER_ID
and i.obj# = ou.obj#
and io.obj# = ou.obj#
and t.obj# = i.bo#
and io.name in (
'PUSER_IDX_3',
'PUSER_IDX_4',
'PUSER_IDX_6',
'PUSER_IDX_3',
'PUSER_IDX_4',
'USER_IDX'
)
/

USERNAME INDEX_NAME TABLE_NAME MONI USED START_MONITORING END_MONITORING
---------- ------------------------------ ------------------------------ ---- ---- ------------------- -------------------
RAJ PUSER_IDX_3 USER_INFO YES NO 02/21/2013 16:09:28
RAJ PUSER_IDX_4 USER_INFO YES NO 02/21/2013 16:09:28
RAJ PUSER_IDX_3 P_USER_INFO YES NO 02/21/2013 16:47:55
RAJ PUSER_IDX_4 P_USER_INFO YES NO 02/21/2013 16:10:52
RAJ PUSER_IDX_6 P_USER_INFO YES NO 02/21/2013 16:09:28
ORACLE USER_IDX USER_INFO YES NO 02/21/2013 16:09:28

6 rows selected.

Logdump: finding RBA using SCN, Timestamp, finding the records

Topics:
Finding RBA Using Timestamp
Finding RBA Using SCN
Finding records in a table using Filter

get either SCN or Timestamp from database and save it

22:18:53 SQL> select scn_to_timestamp(current_scn), current_scn from v$database;

SCN_TO_TIMESTAMP(CURRENT_SCN) CURRENT_SCN
--------------------------------------------------------------------------- --------------------
03-MAY-13 10.18.50.000000000 PM 6808061561351

1. Using sfts or scanfortimestamp

now: start logdump

Oracle GoldenGate Log File Dump Utility
Version 11.1.1.1.2_01 OGGCORE_11.1.1.1.3_PLATFORMS_111209.1035

Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved.

usertoken on
ggstoken on
ghdr on
detail on

Logdump 5 >open /goldengate/traildata/ORCL/zb001058
Current LogTrail is /goldengate/traildata/ORCL/zb001058
Logdump 6 >sfts 2013/05/03 10:18:50
Scan for timestamp >= 2013/05/03 17:18:50.000.000 GMT

2013/05/03 11:35:25.208.987 FileHeader Len 1284 RBA 0
Name: *FileHeader*
3000 01b5 3000 0008 4747 0d0a 544c 0a0d 3100 0002 | 0...0...GG..TL..1...
0002 3200 0004 2000 0000 3300 0008 02f2 0208 1205 | ..2... ...3.........
f59b 3400 001f 001d 7572 693a 736c 6373 6264 6231 | ..4.....uri:hostnode1
343a 3a67 6f6c 6465 6e67 6174 653a 3131 3136 0000 | 4::goldengate:1116..
2d00 2b2f 676f 6c64 656e 6761 7465 2f74 7261 696c | -.+/goldengate/trail
6461 7461 2f44 522f 434f 4e46 3243 544f 432f 7a62 | data/ORCL/zb
3030 3130 3538 3700 0001 0138 0000 0400 0004 2239 | 0010587....8......"9

Logdump 7 >n
___________________________________________________________________
Hdr-Ind : E (x45) Partition : . (x04)
UndoFlag : . (x00) BeforeAfter: A (x41)
RecLength : 33 (x0021) IO Time : 2013/05/03 11:31:15.000.000
IOType : 15 (x0f) OrigNode : 255 (xff)
TransInd : . (x01) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 6682 AuditPos : 1256873432
Continued : N (x00) RecCount : 1 (x01)

2013/05/03 11:31:15.000.000 FieldComp Len 33 RBA 1292
Name: RAJ.USER_INFO
After Image: Partition 4 GU m
0000 000b 0000 0007 3238 3133 3537 3100 0300 0e00 | ........2813571.....
0000 0a31 3336 3736 3035 3834 38 | ...1367605848
Column 0 (x0000), Len 11 (x000b)
Column 3 (x0003), Len 14 (x000e)

User tokens: 18 bytes
5343 4e00 3638 3037 3833 3738 3737 3832 3000 | SCN.6807837877820.

GGS tokens:
5200 0014 4141 434e 4464 4149 3641 4142 6331 6b41 | R...AACNDdAI6AABc1kA
4244 0001 | BD..

2) Using SCN

Logdump 14> filter usertoken scn >=6808061561351
Scan for timestamp >= 2013/05/04 05:18:50.000.000 GMT

2013/05/03 22:20:20.000.000 FieldComp Len 33 RBA 278541
Name: RAJ.USER_INFO
Before Image: Partition 4 GU b
0000 000b 0000 0007 3339 3634 3538 3300 0300 0e00 | ........3964583.....
0000 0a31 3336 3736 3434 3133 33 | ...1367644133

OR

3) filter using csn

Logdump 18 >filter usertoken csn >=6808061561351

logdump
ghdr on
usertoken on
detail on
ggstoken on

Logdump 19 >n
___________________________________________________________________
Hdr-Ind : E (x45) Partition : . (x04)
UndoFlag : . (x00) BeforeAfter: B (x42)
RecLength : 33 (x0021) IO Time : 2013/05/03 22:20:20.000.000
IOType : 15 (x0f) OrigNode : 255 (xff)
TransInd : . (x00) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 6726 AuditPos : 39170576
Continued : N (x00) RecCount : 1 (x01)

2013/05/03 22:20:20.000.000 FieldComp Len 33 RBA 278541
Name: RAJ.USER_INFO
Before Image: Partition 4 GU b
0000 000b 0000 0007 3339 3634 3538 3300 0300 0e00 | ........3964583.....
0000 0a31 3336 3736 3434 3133 33 | ...1367644133
Column 0 (x0000), Len 11 (x000b)
Column 3 (x0003), Len 14 (x000e)

User tokens: 18 bytes
5343 4e00 3638 3038 3036 3136 3731 3436 3700 | SCN.6808061671467.

GGS tokens:
5200 0014 4141 434e 4464 4147 6541 4144 7a39 4141 | R...AACNDdAGeAADz9AA
4273 0001 4c00 000d 3638 3038 3036 3136 3731 3436 | Bs..L...680806167146
3736 0000 0c34 3434 342e 3130 2e39 3937 38 | 76...4444.10.9978

Filtering suppressed 1455 records

4. Finding Records in table using FILTER

Logdump 172 >open /tmp/yp032733
Current LogTrail is /tmp/yp032733
Logdump 173 >filter include filename RAJ.USER_LIST
Logdump 174 >N
Scanned 10000 records, RBA 19431038, 2013/02/11 17:01:24.010.061
Scanned 20000 records, RBA 39075232, 2013/02/11 17:01:49.005.345
<o/p truncated>
Scanned 240000 records, RBA 463168443, 2013/02/11 17:10:41.005.732
Scanned 250000 records, RBA 483308009, 2013/02/11 17:11:06.000.784
___________________________________________________________________
Hdr-Ind : E (x45) Partition : . (x04)
UndoFlag : . (x00) BeforeAfter: A (x41)
RecLength : 136 (x0088) IO Time : 2013/02/11 17:11:15.005.240
IOType : 5 (x05) OrigNode : 255 (xff)
TransInd : . (x00) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 19691 AuditPos : 2825134096
Continued : N (x00) RecCount : 1 (x01)

2013/02/11 17:11:15.005.240 Insert Len 136 RBA 490378100
Name: RAJ.USER_LIST
After Image: Partition 4 GU b
0000 0018 0000 0014 3133 3732 3331 3838 3236 3632 | ........137231882662
3738 3534 3735 3620 0001 000a 0000 0000 0000 0000 | 7854756 ............
0000 0002 0004 ffff 0000 0003 000a 0000 0000 0000 | ....................
0000 0001 0004 0004 ffff 0000 0005 000a 0000 0000 | ....................
0000 004c 311e 0006 000a 0000 0000 0000 0000 0001 | ...L1...............
0007 000e 0000 000a 3133 3630 3633 3134 3730 0008 | ........1360631470..
000e 0000 000a 3133 3630 3633 3134 3730 | ......1360631470
Column 0 (x0000), Len 24 (x0018)
Column 1 (x0001), Len 10 (x000a)
Column 2 (x0002), Len 4 (x0004)
Column 3 (x0003), Len 10 (x000a)
Column 4 (x0004), Len 4 (x0004)
Column 5 (x0005), Len 10 (x000a)
Column 6 (x0006), Len 10 (x000a)
Column 7 (x0007), Len 14 (x000e)
Column 8 (x0008), Len 14 (x000e)

User tokens: 22 bytes
746b 6e2d 7363 6e00 3637 3338 3530 3039 3832 3734 | tkn-scn.673850098274
3900 | 9.

Filtering suppressed 253736 records

Thursday, May 2, 2013

Reverse Replication Using Oracle Golden Gate
This is to set up upstream and downstream replication with in the same data base and test it out.

1. Replicat parameter file:

--replicat added by raj
--CHECKPARAMS

REPLICAT rkiran

SETENV (ORACLE_SID = "ORCL")
SETENV (ORACLE_HOME = "/u01/home/product/10.2.0.4")
SETENV (NLS_LANG = "AMERICAN_AMERICA.UTF8")
USERID ggs, PASSWORD, ENCRYPTKEY DEFAULT

ASSUMETARGETDEFS
GROUPTRANSOPS 3000
ALLOWNOOPUPDATES
--ALLOWNOOPUPDATES # Dont comment the above parameter.

-- DISCARDFILE LOCATION
DISCARDFILE /u01/goldengate//dirout/rkiran.dsc, MEGABYTES 100,APPEND

STATOPTIONS REPORTFETCH
REPORTCOUNT EVERY 10 MINUTES, RATE

-- use EOFDELAY to reduce the impact to the oracle redo log sync
-- EOFDELAY 2

--Uncomment the followings if there are truncate operations.
--GETTRUNCATES

DYNAMICRESOLUTION

--Uncomment the followings if handlecollisions required.
--HANDLECOLLISIONS
--RESTARTCOLLISIONS

--Table List

--Uncomment out the followings and enter the scn you would like.

MAP RAJ.raj_raj, TARGET test.raj_test;

==========

ggsci
add replicat rkiran, exttrail /u01/goldengate/traildata/local/tc
alter replicat rkiran, extseqno 0 extrba 0
info rkiran
start rkiran
info rkiran

========

-- test extract created by raj
NUMFILES 2000
ALLOCFILES 500

EXTRACT EKIRAN

TRANLOGOPTIONS BUFSIZE 32768

EXTTRAIL /u01/goldengate/traildata/local/tc

SETENV (ORACLE_SID = "ORCL")
SETENV (ORACLE_HOME = "/u01/home/product/10.2.0.4")
SETENV (NLS_LANG = "AMERICAN_AMERICA.UTF8")
USERID ggs, PASSWORD <encrypted password>, ENCRYPTKEY DEFAULT
--sqlexec "alter session set events '10046 trace name context forever, level 12'"

FLUSHSECS 60
CHECKPOINTSECS 120

CACHEMGR, CACHESIZE 32GB, CACHEDIRECTORY /tmp/ggtmp/

EOFDELAY 15

REPORTCOUNT EVERY 100 RECORDS

GETTRUNCATES

DYNAMICRESOLUTION
WILDCARDRESOLVE DYNAMIC
WARNLONGTRANS 5 MINUTES, CHECKINTERVAL 1M

TABLE RAJ.RAJ_RAJ, TOKENS ( SCN = @GETENV ("ORATRANSACTION","SCN"));

===

add extract EKIRAN tranlog begin now
add rmttrail /u01/goldengate/traildata/local/tc extract EKIRAN

make sure if the trail files are generated at the local dirdat directory

===============

-- test extract created by raj for reverse replication

NUMFILES 2000
ALLOCFILES 500

EXTRACT EREV

TRANLOGOPTIONS BUFSIZE 32768

EXTTRAIL /u01/goldengate/traildata/local/rev/bc

SETENV (ORACLE_SID = "ORCL")
SETENV (ORACLE_HOME = "/u01/home/product/10.2.0.4")
SETENV (NLS_LANG = "AMERICAN_AMERICA.UTF8")
USERID ggs, PASSWORD <encrypted password>, ENCRYPTKEY DEFAULT
--sqlexec "alter session set events '10046 trace name context forever, level 12'"

FLUSHSECS 60
CHECKPOINTSECS 120

CACHEMGR, CACHESIZE 32GB, CACHEDIRECTORY /tmp/ggtmp/

EOFDELAY 15

REPORTCOUNT EVERY 100 RECORDS

GETTRUNCATES

DYNAMICRESOLUTION
WILDCARDRESOLVE DYNAMIC
WARNLONGTRANS 5 MINUTES, CHECKINTERVAL 1M

TABLE TEST.RAJ_TEST, TOKENS ( SCN = @GETENV ("ORATRANSACTION","SCN"));

===

add extract EREV tranlog begin now
add rmttrail /u01/goldengate/traildata/local/rev/bc extract EREV

make sure if the trail files are generated at the local dirdat directory

=================
--replicat added by raj
--CHECKPARAMS

REPLICAT reverse

SETENV (ORACLE_SID = "ORCL")
SETENV (ORACLE_HOME = "/u01/home/product/10.2.0.4")
SETENV (NLS_LANG = "AMERICAN_AMERICA.UTF8")
USERID ggs, PASSWORD <encrypted password>, ENCRYPTKEY DEFAULT

ASSUMETARGETDEFS
GROUPTRANSOPS 3000
ALLOWNOOPUPDATES
--ALLOWNOOPUPDATES # Dont comment the above parameter.

-- DISCARDFILE LOCATION
DISCARDFILE /u01/goldengate//dirout/reverse.dsc, MEGABYTES 100,APPEND

STATOPTIONS REPORTFETCH
REPORTCOUNT EVERY 10 MINUTES, RATE

-- use EOFDELAY to reduce the impact to the oracle redo log sync
-- EOFDELAY 2

--Uncomment the followings if there are truncate operations.
--GETTRUNCATES

DYNAMICRESOLUTION

--Uncomment the followings if handlecollisions required.
--HANDLECOLLISIONS
--RESTARTCOLLISIONS

--Table List

--Uncomment out the followings and enter the scn you would like.
MAP test.raj_test, TARGET RAJ.raj_raj;

==

GGSCI (localhost) 1> dblogin userid ggs, password ****
Successfully logged into database.

GGSCI (localhost) 2> add trandata RAJ.raj_raj

Logging of supplemental redo data enabled for table RAJ.RAJ_RAJ.

GGSCI (localhost) 3> add trandata test.raj_test

Logging of supplemental redo data enabled for table TEST.RAJ_TEST.

oracle@localhost > ls /u01/goldengate/traildata/local/
oracle@localhost >
no files existing

GGSCI (localhost) 3> info all

Program Status Group Lag Time Since Chkpt

MANAGER RUNNING
EXTRACT STOPPED EKIRAN 00:00:00 00:00:03

GGSCI (localhost) 4> add rmttrail /u01/goldengate/traildata/local/tc extract EKIRAN
RMTTRAIL added.

GGSCI (localhost) 5> info EKIRAN
info EKIRAN

EXTRACT EKIRAN Last Started 2012-11-14 16:46 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:01:45 ago)
Log Read Checkpoint Oracle Redo Logs
2012-11-14 16:45:49 Seqno 31940, RBA 757264

oracle@localhost > ls -ltr /u01/goldengate/traildata/local/
total 16
-rw-rw-rw- 1 oracle dba 948 Nov 14 16:46 tc000000

====================================
====================================

GGSCI (localhost) 2> add replicat rkiran, exttrail /u01/goldengate/traildata/local/tc
REPLICAT added.

GGSCI (localhost) 3> alter replicat rkiran, extseqno 0 extrba 0
REPLICAT altered.

GGSCI (localhost) 4> info rkiran

REPLICAT RKIRAN Initialized 2012-11-14 17:01 Status STOPPED
Checkpoint Lag 00:00:00 (updated 00:00:06 ago)
Log Read Checkpoint File /u01/goldengate/traildata/local/tc000000
First Record RBA 0

GGSCI (localhost) 5> start rkiran

Sending START request to MANAGER ...
REPLICAT RKIRAN starting

GGSCI (localhost) 6> info rkiran

REPLICAT RKIRAN Last Started 2012-11-14 17:01 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:05 ago)
Log Read Checkpoint File /u01/goldengate/traildata/local/tc000000
First Record RBA 948

GGSCI (localhost) 7> !
info rkiran

REPLICAT RKIRAN Last Started 2012-11-14 17:01 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:01 ago)
Log Read Checkpoint File /u01/goldengate/traildata/local/tc000000
First Record RBA 948
====================================
====================================

set echo on
set serveroutput on
begin
for i in 1..300
loop
insert into raj_raj values (i,'jra','hyd',i,i);
dbms_output.put_line('value of i is '||i);
if (mod(i,200)=0) then
dbms_output.put_line('committing at the value of i='||i);
commit;
dbms_output.put_line('sleeping for 2 seconds');
dbms_lock.sleep(2);
DBMS_OUTPUT.put_line ('Time is ' || TO_CHAR (SYSDATE, 'HH:MI:SS'));
end if;
end loop;
end;

select count(*) from raj_raj;
select count(*) from raj_test;

INFERENCE: extract get lag = At EOF, no more records to process
+
extract logend = YES
+
Replicat status = 0 records in current transaction
+
Replicat lag and logend should be EOF, no more records to process and YES respectively.
===

== Testing reverse replication

CURRENT_SCN
--------------------
6669796442862
6669796442886 - from the logdump
rba 4580020
seq# 000021

set serveroutput on
begin
for i in 1000001..1050000
loop
insert into raj_test values (i,'jra','hyd',i,i);
dbms_output.put_line('value of i is '||i);
if (mod(i,1000)=0) then
dbms_output.put_line('committing at the value of i='||i);
commit;
dbms_output.put_line('sleeping for 2 seconds');
dbms_lock.sleep(2);
DBMS_OUTPUT.put_line ('Time is ' || TO_CHAR (SYSDATE, 'HH:MI:SS'));
end if;
end loop;
end;
/

add replicat reverse, exttrail /u01/goldengate/traildata/local/rev/bc

GGSCI (localhost) 2> alter replicat reverse, extseqno 000021 extrba 4580020
REPLICAT altered.

GGSCI (localhost) 3> info reverse

REPLICAT REVERSE Initialized 2012-11-16 10:50 Status STOPPED
Checkpoint Lag 00:00:00 (updated 00:00:05 ago)
Log Read Checkpoint File /u01/goldengate/traildata/local/rev/bc000021
First Record RBA 4580020

GGSCI (localhost) 4> start reverse

Sending START request to MANAGER ...
REPLICAT REVERSE starting

GGSCI (localhost) 5> info reverse

REPLICAT REVERSE Last Started 2012-11-16 10:50 Status RUNNING
Checkpoint Lag 00:10:26 (updated 00:00:00 ago)
Log Read Checkpoint File /u01/goldengate/traildata/local/rev/bc000021
2012-11-16 10:39:57.000000 RBA 5300143

GGSCI (localhost) 6> info reverse detail

REPLICAT REVERSE Last Started 2012-11-16 10:50 Status RUNNING
Checkpoint Lag 00:10:03 (updated 00:00:00 ago)
Log Read Checkpoint File /u01/goldengate/traildata/local/rev/bc000021
2012-11-16 10:40:27.000000 RBA 7460517

Extract Source Begin End

/u01/goldengate/traildata/local/rev/bc000021 * Initialized * 2012-11-16 10:40
/u01/goldengate/traildata/local/rev/bc000021 * Initialized * First Record
/u01/goldengate/traildata/local/rev/bc000000 * Initialized * First Record

-- some use ful sql

/*
Conn / as sysdba
Col used format a8
Prompt current_rba will show where redo is being written to

Select le.leseq log_sequence#, cp.cpodr_bno * le.lebsz current_rba,
le.lesiz * le.lebsz log_size,
substr(to_char(100 * cp.cpodr_bno / le.lesiz, '999.00'), 2) || '%' used
from sys.x$kcccp cp,
sys.x$kccle le
where le.inst_id = userenv('Instance') and
cp.inst_id = userenv('Instance') and
le.leseq = cp.cpodr_seq and le.leseq > 0
*/

Thursday, April 4, 2013

Mongo DB installation on MacOS

Prerequisites

Install “Command Line Tools for Xcode” (often required for compilation and homebrew)
Install or have access to Xcode (optional, but sometimes required when building from source)

You can obtain the command‑line tools from Apple’s developer site (e.g. https://developer.apple.com).

Step 1: Install Homebrew (if not already installed)

If brew command is missing:


# Check brew exists
brew update
# If not installed, run the installer script:
ruby -e "$(curl -fsSL https://raw.github.com/mxcl/homebrew/go)"

You’ll see messages like:


This script will install: /usr/local/bin/brew
...
Downloading and Installing Homebrew…

After installation, run:


brew doctor

to validate your installation environment. You might see a warning:

“You have only installed Xcode. If stuff is not building, try installing the ‘Command Line Tools for Xcode’ package …”

Make sure you have the command line tools installed so compilation and building from source work properly.

Step 2: Install MongoDB via Homebrew

Once Homebrew is ready:


brew update
brew install mongo

This should fetch the MongoDB package (in the example, version 2.2.3 was used) and install it. You may see a warning or “caveats” such as:

How to have mongod start automatically via launchd
That you can manually run mongod if you don’t use launchd

For example:


To have launchd start mongodb at login:
    mkdir -p ~/Library/LaunchAgents
    ln -sfv /usr/local/opt/mongodb/*.plist ~/Library/LaunchAgents
Then to load mongodb now:
    launchctl load ~/Library/LaunchAgents/homebrew.mxcl.mongodb.plist

Or you can simply run:


mongod

to start the server manually.

Additional Tips, Enhancements & Modern Context

Versions & Compatibility

MongoDB version 2.2.3 is quite old. Modern macOS and MongoDB versions differ; always check the official MongoDB compatibility matrix for your OS version.
Some installation steps may differ now (e.g., using brew tap mongodb/brew).

Data Directory & Permissions

By default, mongod uses /data/db or another configured directory for data. You may need to create it and set the appropriate permissions:
```
sudo mkdir -p /usr/local/var/mongodb
sudo chown -R $(whoami) /usr/local/var/mongodb
```
Ensure your mongod.conf is properly configured for your environment (port, bind address, storageOptions, logging).

Running MongoDB at Startup

Use launchd (macOS) or brew services (newer brew) to manage MongoDB daemon startup:
```
brew services start mongodb
```
Or with manual launchctl steps as described above.

Security & Authentication (Modern Considerations)

Enable authentication (create admin user) and bind to appropriate network interfaces (not 0.0.0.0) especially if your dev machine is network reachable.
Use TLS/SSL and enforce strong passwords in non‑local environments.

Monitoring & Logging

Tail mongod logs (e.g. /usr/local/var/log/mongodb/mongo.log) to monitor errors, connections, and replication (if applicable).
Monitor system metrics like memory, file descriptors, and storage I/O.

Here is a comprehensive Bash automation script to install MongoDB on macOS using Homebrew, including:

Pre-checks (Homebrew, Xcode tools, data dir, permissions)
MongoDB installation
Service configuration (launchd or brew services)
Kernel settings check (ulimits, sysctl)
Log monitoring
Post-checks (port listening, service status, Mongo shell test)

Compatible with Intel and Apple Silicon Macs. Tested with MongoDB 4.x – 6.x.

#!/bin/bash

# --------------------------------------------------------------

# MongoDB Full Automation Setup Script for macOS

# Author: Raj

# --------------------------------------------------------------

MONGO_DATA_DIR="/usr/local/var/mongodb"

MONGO_LOG="/usr/local/var/log/mongodb/mongo.log"

BREW_SERVICES=$(brew --prefix)/bin/brew

BIND_IP="127.0.0.1"

MONGO_PORT=27017

PROFILE_FILE="$HOME/.zprofile"

echo " Starting MongoDB installation and setup for macOS..."

#--------------------------------------------------

# 1. Pre-checks: Xcode Tools, Homebrew

#--------------------------------------------------

echo "🔧 Checking for Command Line Tools..."

xcode-select -p &>/dev/null

if [ $? -ne 0 ]; then

echo "Command Line Tools not installed. Installing..."

xcode-select --install

exit 1

else

echo "Command Line Tools are installed."

echo "🔧 Checking Homebrew..."

if ! command -v brew &>/dev/null; then

echo " Homebrew not found. Installing Homebrew..."

/bin/bash -c "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/HEAD/install.sh)"

else

echo " Homebrew found."

brew update

#--------------------------------------------------

# 2. Install MongoDB via Homebrew

#--------------------------------------------------

echo " Installing MongoDB Community Edition..."

brew tap mongodb/brew

brew install mongodb-community@7.0

if [ $? -ne 0 ]; then

echo " MongoDB installation failed."

exit 1

echo " MongoDB installed."

#--------------------------------------------------

# 3. Create MongoDB Data Directory and Set Permissions

#--------------------------------------------------

echo " Ensuring MongoDB data and log directories exist..."

sudo mkdir -p "$MONGO_DATA_DIR"

sudo mkdir -p "$(dirname $MONGO_LOG)"

sudo touch "$MONGO_LOG"

sudo chown -R $(whoami) "$MONGO_DATA_DIR" "$(dirname $MONGO_LOG)"

echo " Data and log directories created and owned by user."

#--------------------------------------------------

# 4. Check/Update Kernel Settings (ulimits/sysctl)

#--------------------------------------------------

echo " Checking kernel limits..."

ULIMIT_NOFILE=$(ulimit -n)

if [ "$ULIMIT_NOFILE" -lt 64000 ]; then

echo " Open file limit is low ($ULIMIT_NOFILE). Recommend setting to 64000."

echo "You can add this to $PROFILE_FILE:"

echo 'ulimit -n 64000'

else

echo " Open file limit is sufficient: $ULIMIT_NOFILE"

#--------------------------------------------------

# 5. Start MongoDB Service (brew services or launchctl)

#--------------------------------------------------

echo " Starting MongoDB service..."

brew services start mongodb-community@7.0

sleep 5

#--------------------------------------------------

# 6. Post-Checks: Port, Service Status, MongoDB Ping

#--------------------------------------------------

echo " Checking if MongoDB is running on port $MONGO_PORT..."

if lsof -iTCP:$MONGO_PORT -sTCP:LISTEN | grep -q mongod; then

echo " mongod is listening on port $MONGO_PORT."

else

echo " mongod not detected on port $MONGO_PORT."

exit 1

echo " Verifying MongoDB shell connectivity..."

if mongosh --eval "db.runCommand({ ping: 1 })" &>/dev/null; then

echo " Successfully connected to MongoDB."

else

echo " Unable to connect to MongoDB using mongosh."

#--------------------------------------------------

# 7. Monitor Log File

#--------------------------------------------------

echo " Last 20 lines of MongoDB log:"

tail -n 20 "$MONGO_LOG"

echo " MongoDB setup and verification complete!"

echo "--------------------------------------------"

echo " Data Directory: $MONGO_DATA_DIR"

echo " Log File: $MONGO_LOG"

echo " Port: $MONGO_PORT"

echo " Bind IP: $BIND_IP"

example:

requirement is: Command Line Tools for Xcode": http://connect.apple.com
go to apple.com and download Xcode.

Last login: Mon Feb 11 23:00:42 on ttys000

machost_01:~ raj$ brew update

-sh: brew: command not found

machost_01:~ raj$ brew

-sh: brew: command not found

machost_01:~ raj$ cd /usr/local/

machost_01:local raj$ find Cellar

find: Cellar: No such file or directory

machost_01:local raj$ gcc -v

-sh: gcc: command not found

machost_01:local raj$ ruby -v

ruby 1.8.7 (2012-02-08 patchlevel 358) [universal-darwin11.0]

machost_01:local raj$ ruby -e "$(curl -fsSL https://raw.github.com/mxcl/homebrew/go)"

==> This script will install:

/usr/local/bin/brew

/usr/local/Library/...

/usr/local/share/man/man1/brew.1

==> The following directories will be made group writable:

/usr/local/.

==> The following directories will have their group set to admin:

/usr/local/.

Press ENTER to continue or any other key to abort

==> /usr/bin/sudo /bin/chmod g+rwx /usr/local/.

WARNING: Improper use of the sudo command could lead to data loss

or the deletion of important system files. Please double-check your

typing when using sudo. Type "man sudo" for more information.

To proceed, enter your password, or type Ctrl-C to abort.

Password:

Sorry, try again.

Password:

==> /usr/bin/sudo /usr/bin/chgrp admin /usr/local/.

==> Downloading and Installing Homebrew...

Failed during: Error: /usr/bin/xcode-select returned unexpected error. init -q

machost_01:local raj$ gcc -v

-sh: gcc: command not found

machost_01:local raj$ ruby -e "$(curl -fsSL https://raw.github.com/mxcl/homebrew/go)"

==> This script will install:

/usr/local/bin/brew

/usr/local/Library/...

/usr/local/share/man/man1/brew.1

Press ENTER to continue or any other key to abort

==> Downloading and Installing Homebrew...

remote: Counting objects: 101297, done.

remote: Compressing objects: 100% (43460/43460), done.

remote: Total 101297 (delta 71564), reused 83861 (delta 56957)

Receiving objects: 100% (101297/101297), 15.12 MiB | 2.19 MiB/s, done.

Resolving deltas: 100% (71564/71564), done.

From https://github.com/mxcl/homebrew

* [new branch] master -> origin/master

Checking out files: 100% (2612/2612), done.

HEAD is now at 52b8be1 doctor: make brew link more clear

Warning: Install the "Command Line Tools for Xcode": http://connect.apple.com

==> Installation successful!

You should run `brew doctor' *before* you install anything.

Now type: brew help

machost_01:local raj$ brew doctor

Warning: Experimental support for using Xcode without the "Command Line Tools".

You have only installed Xcode. If stuff is not building, try installing the

"Command Line Tools for Xcode" package provided by Apple.

machost_01:local raj$

machost_01:local raj$ brew doctor

Warning: Experimental support for using Xcode without the "Command Line Tools".

You have only installed Xcode. If stuff is not building, try installing the

"Command Line Tools for Xcode" package provided by Apple.

machost_01:local raj$

machost_01:local raj$ ruby -e "$(curl -fsSL https://raw.github.com/mxcl/homebrew/go)"

It appears Homebrew is already installed. If your intent is to reinstall you

should do the following before running this installer again:

rm -rf /usr/local/Cellar /usr/local/.git && brew cleanup

machost_01:local raj$

machost_01:local raj$ brew update

Already up-to-date.

machost_01:local raj$

machost_01:local raj$ pwd

/usr/local

machost_01:local raj$ brew install mongo

==> Downloading http://fastdl.mongodb.org/osx/mongodb-osx-x86_64-2.2.3.tgz

######################################################################## 100.0%

==> Caveats

To have launchd start mongodb at login:

mkdir -p ~/Library/LaunchAgents

ln -sfv /usr/local/opt/mongodb/*.plist ~/Library/LaunchAgents

Then to load mongodb now:

launchctl load ~/Library/LaunchAgents/homebrew.mxcl.mongodb.plist

Or, if you don't want/need launchctl, you can just run:

mongod

==> Summary

🍺 /usr/local/Cellar/mongodb/2.2.3-x86_64: 20 files, 171M, built in 45 seconds

Friday, September 13, 2013

Strage behavior on renaming an IOT table - oracle 11g - 11.2.0.2.0 "truncating (as requested) before column"

Tuesday, September 10, 2013

ORA-00600 when using EXPDP & IMPDP on a RAC Database.

The Scenario & Symptoms

Sample Log Extract (from alert log)

Possible Root Causes (RCA) & Mechanisms

Workaround & Mitigation Strategies

Best Practices & Considerations

Summary

Saturday, May 18, 2013

Definition of a Table Using defgen Utility (Oracle GoldenGate)

Why Use defgen?

Script: def_gen.sh

Sample Output: .def File

Best Practices (Based on Experience)

Tuesday, May 14, 2013

Saturday, May 4, 2013

Thursday, May 2, 2013

Thursday, April 4, 2013

Mongo DB installation on MacOS

Prerequisites

Step 1: Install Homebrew (if not already installed)

Step 2: Install MongoDB via Homebrew

Additional Tips, Enhancements & Modern Context

Versions & Compatibility

Data Directory & Permissions

Running MongoDB at Startup

Security & Authentication (Modern Considerations)

Monitoring & Logging

Why Use `defgen`?

Sample Output: `.def` File