Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- telnet (srvlabaix)
- AIX Version 6
- Copyright IBM Corporation, 1982, 2011.
- login: root
- root's Password:
- *******************************************************************************
- * *
- * *
- * Welcome to AIX Version 6.1! *
- * *
- * *
- * Please see the README file in /usr/lpp/bos for information pertinent to *
- * this release of the AIX Operating System. *
- * *
- * *
- *******************************************************************************
- Last unsuccessful login: Thu Mar 16 09:37:13 EDT 2017 on /dev/pts/1 from atcis02 0l.atlanticgeneral.org
- Last login: Thu Mar 16 10:22:56 EDT 2017 on ssh from atcis020l.atlanticgeneral.o rg
- Environment 'common' set.
- root:common@(srvlabaix):/:
- # newgrp - d_cert
- Environment 'cert' set.
- root:cert@(srvlabaix):/:
- # ccl
- cclisam(ver:6 mode:0 multiuser:1, largefile:0)
- RDBEXPAND=1, RDBEXPANDGTTD=0
- Including ccl file login_default.ccl
- Connecting to RDBMS as V500* user
- Qual: 0 Len: 0
- Qual: 1 Len: 0
- Connect to RDBMS(Usr:V500 Lnk:@cert1 Pos:0 Con:1 Han:7259564 Opt:8 Lib:OCI9+ Ver :11.10 Sys:AIX End:1 Acc:1 Try:1 Ela:0.00 )
- Rec: 0, 0 Row: 0 Qual: 0 Sort: 0
- H
- ........10........20........30........40........50........60........70........80........90.......100.......110.......120......
- DATABASE_STATUS |STARTUP_TIME |INSTANCE_NAME |INSTANCE_ROLE |HOST_NAME
- ACTIVE |08-SEP-2016 18:33:50 |cert1 |PRIMARY_INSTANCE |srvlabaix
- Rows: 1 Cols: 152 Multi Down
- EXIT VIEW FIND PRINT HELP SCROLL BREAK DIRECTION WIDTH MARGIN
- Qual: 1 Len: 152
- *** Begin cclstartup script ***
- Version: Millennium 2010.02: JUL2010
- 37
- Declaring secrtl_def
- V500 UserName saydelotte
- V500 Domain cert
- V500 Password
- (Hit PF3 or RETURN to skip security login; this will disable Uar functions)
- V500 SECURITY LOGIN SUCCESS
- Enter Y to continue Y
- 170316:102723 CCLSTARTUP Cost 0.01 Cpu 0.01 Ela 0.00 Bio 0 Dio 0 O0M0R0 P1R38 S2,2
- *** End cclstartup script ***
- DISCERN EXPLORER (CCL Rev:8.7.2 Hnam:01OCT2011)
- %Banner %Display %Edit %Help %Include %Journ %Ledit %Out %Run %Show %Term %Ver
- BROWSE CALL CASE DECLARE DEFINE DELETE EXECUTE FOR FREE GENERATE GOTO GRANT IF
- INSERT MERGE RANGE RDB RECORD RESET REVOKE SELECT SET SUBROUTINE UPDATE WHILE
- CCLMENU CCLUSER DATABASE DDLRECORD EKMODULE GENLINK PROGRAM RECORD TABLE VIEW
- CclAssist CclCost CclGlos CclNews CclOraCons CclOraDef CclOraError CclOraIndex
- CclOraParam CclOraPlan CclOraSession CclOraVer CclProgSearch CclProt CclQuery
- CclRefLog CclReg CclServer CclSize CclSqlArea Cclsrv CclUaf RtlView Tableall
- Sys(AIX AIX)Utc(0)Isam(Disam 6)ORACLE(OCI9+ O8 V11.10 AIX)Grp(00) ROOT
- SecLogin(on) DMS(off) Ccledit(CCLUSERDIR) Ccldir(2W_63)
- 1)dep_dbimport_wrapper go
- 0)DM_INFO:DM_INFO(N#0#0)(Rng:0)Len<4417>Dim<1>KEY1<0>Rec<0>
- Rec: 0, 1 Row: 0 Qual: 0 Len: 12
- 0)DM_INFO:R(N#0#0)(Rng:0)Len<4417>Dim<1>KEY1<0>Rec<1>
- Rec: 1, 2 Row: 1 Qual: 1 Len: 19
- %CCL-E-284-DEP_DBIMPORT_WRAPPER(0,0)S0L2.1d6{}[ORA-28001]ORA-28001: the password has expired
- ORA-02063: preceding line from ADMIN1
- 0)DEP_ENV_ID_RELTN:EIR(N#0#0)(Rng:0)Len<34>Dim<1>KEY1<0>Rec<0>
- Rec: 0, 0 Row: 0 Qual: 0 Len: 19
- Failure during SELECT from dep_env_id_reltn:%CCL-E-284-DEP_DBIMPORT_WRAPPER(0,0) S0L2.1d6{}[ORA-28001]ORA-28001: the password has ex
- pired ORA-02063: preceding line from ADMIN1
- >>>Begin EchoRecord README_DATA ;README_DATA
- 1 OCD= I4 {0}
- 1 README_ID=F8 {0.0000000000 }
- 1 INSTANCE= I4 {0}
- 1 README_TYPE=VC0 {}
- 1 DESCRIPTION=VC0 {}
- 1 SCRIPT=VC0 {}
- 1 CHECK_SCRIPT=VC0 {}
- 1 DATA_FILE=VC0 {}
- 1 PAR_FILE=VC0 {}
- 1 BLOCKS= I4 {0}
- 1 LOG_ROWID=VC0 {}
- 1 STATUS=VC1 {F}
- 1 MESSAGE=C255 {Failure during SELECT from dep_env_id_reltn:%CCL-E-284-DEP_DB IMPORT_WRAPPER(0,0)}
- {S0L2.1d6{}[ORA-28001]ORA-28001: the password has expired ORA- 02063: preceding li}
- {ne from ADMIN1 }
- { }
- 1 OPTIONS=VC0 {}
- 1 DRIVER=VC0 {}
- 1 BATCH_DT_TM=DQ8 {0 (0000-00-00 00:00:00.00) utc(0)}
- >>>End EchoRecord README_DATA varchar=1, varlist=0, size(363,292)
- 0)PRODUCT_COMPONENT_VERSION:P(N#0#0)(Rng:0)Len<258>Dim<1>KEY1<0>Rec<1>
- Rec: 1, 2 Row: 1 Qual: 1 Len: 91
- 0)USER_TAB_COLUMNS:UTC(N#0#0)(Rng:0)Len<32466>Dim<1>KEY1<0>Rec<12>
- 1)DTABLE:DT(N#2#0)(Rng:1)Len<736>Dim<1>KEY1<36>Rec<12>
- Rec: 12, 37 Row: 24 Qual: 12 Len: 12
- 0)DM_INFO:D(N#0#0)(Rng:0)Len<4417>Dim<1>KEY1<0>Rec<0>
- Rec: 0, 1 Row: 0 Qual: 0 Len: 12
- %CCL-E-284-DM_README_STATUS(0,0)S0L3.2d6{}[ORA-28001]ORA-28001: the password has expired
- ORA-02063: preceding line from ADMIN1
- 0)DM_INFO:D(N#0#0)(Rng:0)Len<4417>Dim<1>KEY1<0>Rec<0>
- 1)DM_ENVIRONMENT:DE(N#5#0)(Rng:1)Len<868>Dim<1>Row<0>
- Rec: 0, 0 Row: 0 Qual: 0 Len: 19
- *
- *
- *
- ********************************************************************************
- *
- Component Name: DM_README_STATUS
- *
- Process Description: Check for DM_README_TOOLSET row.
- *
- Error Message: %CCL-E-284-DM_README_STATUS(0,0)S0L3.2d6{}[ORA-28001]ORA-28001: the password has expired ORA-02063: preceding line
- from ADMIN1
- *
- ********************************************************************************
- *
- *
- *
- 170316:102737 DEP_DBIMPORT_WRAPPER Cost 0.02 Cpu 0.01 Ela 0.20 Bio 0 Dio 0 O0M0R0 P2R43C1E2 S7,7
- Command executed!
- 1)set trace rdbdebug go
- Command executed!
- 1)set trace rdbbind go
- Command executed!
- 1)set dm2_debug_flag=10 go
- Command executed!
- 1)dep_dbimport_wrapper go
- RDB
- SELECT /*+ CCL<DEP_DBIMPORT_WRAPPER:S0000:O8:R000:Q01.1> */ 0 FROM DM_INFO X WHERE X.INFO_D OMAIN = 'DAT
- A MANAGEMENT' AND X.INFO_NAME = 'INHOUSE DOMAIN'
- GO
- RDBMS ReCompile Req:1 Inlen:164 Stat:0
- RDBMS Fetch Req:1 Outlen:1200 Array:200
- 0)DM_INFO:DM_INFO(N#0#0)(Rng:0)Len<4417>Dim<1>KEY1<0>Rec<0>
- Rec: 0, 1 Row: 0 Qual: 0 Len: 12
- RDB
- SELECT /*+ CCL<DEP_DBIMPORT_WRAPPER:S0000:O8:R000:Q02.1> */ R.INFO_NUMBER FROM DM_INFO R WHER E R.INFO_DOMAIN
- = 'DATA MANAGEMENT' AND R.INFO_NAME = 'DM_ENV_ID'
- GO
- RDBMS ReCompile Req:1 Inlen:169 Stat:0
- RDBMS Fetch Req:1 Outlen:2000 Array:200
- 0)DM_INFO:R(N#0#0)(Rng:0)Len<4417>Dim<1>KEY1<0>Rec<1>
- Rec: 1, 2 Row: 1 Qual: 1 Len: 19
- RDB
- SELECT /*+ CCL<DEP_DBIMPORT_WRAPPER:S0000:O8:R000:Q03.1> */ EIR.DEP_ENV_ID FROM DEP_ENV_ID_REL TN EIR WHERE E
- IR.ENVIRONMENT_ID = :1
- GO
- RDBMS ReCompile Req:1 Inlen:142 Stat:0
- RDBMS Fetch Req:1 Outlen:2000 Array:200
- BIND(Q1:1:1) FLOAT(11547620.00000 )
- ccldsri_err(E): error(28001) loc(2) state(0) qry(1.1) par(1) level(L2,P1) com(SELECT /*+ CCL<DEP _DBIMPORT_WRAPPER:S0000:O8:R00)
- %CCL-E-284-DEP_DBIMPORT_WRAPPER(0,0)S0L2.1d6{}[ORA-28001]ORA-28001: the password has expired
- ORA-02063: preceding line from ADMIN1
- 0)DEP_ENV_ID_RELTN:EIR(N#0#0)(Rng:0)Len<34>Dim<1>KEY1<0>Rec<0>
- Rec: 0, 0 Row: 0 Qual: 0 Len: 19
- Failure during SELECT from dep_env_id_reltn:%CCL-E-284-DEP_DBIMPORT_WRAPPER(0,0)S0L2.1d6{}[ORA-280 01]ORA-28001: the password has ex
- pired ORA-02063: preceding line from ADMIN1
- >>>Begin EchoRecord README_DATA ;README_DATA
- 1 OCD= I4 {0}
- 1 README_ID=F8 {0.0000000000 }
- 1 INSTANCE= I4 {0}
- 1 README_TYPE=VC0 {}
- 1 DESCRIPTION=VC0 {}
- 1 SCRIPT=VC0 {}
- 1 CHECK_SCRIPT=VC0 {}
- 1 DATA_FILE=VC0 {}
- 1 PAR_FILE=VC0 {}
- 1 BLOCKS= I4 {0}
- 1 LOG_ROWID=VC0 {}
- 1 STATUS=VC1 {F}
- 1 MESSAGE=C255 {Failure during SELECT from dep_env_id_reltn:%CCL-E-284-DEP_DBIMPORT_WRAPPER(0,0 )}
- {S0L2.1d6{}[ORA-28001]ORA-28001: the password has expired ORA-02063: preceding l i}
- {ne from ADMIN1 }
- { }
- 1 OPTIONS=VC0 {}
- 1 DRIVER=VC0 {}
- 1 BATCH_DT_TM=DQ8 {0 (0000-00-00 00:00:00.00) utc(0)}
- >>>End EchoRecord README_DATA varchar=1, varlist=0, size(363,292)
- RDB
- SELECT /*+ CCL<DM_README_STATUS:S0000:O8:R000:Q84.1> */ P.VERSION FROM PRODUCT_COMPONENT_VERSI ON P WHERE UP
- PER(P.PRODUCT) LIKE 'ORACLE%'
- GO
- RDBMS ReCompile Req:1 Inlen:142 Stat:0
- RDBMS Fetch Req:1 Outlen:16800 Array:200
- 0)PRODUCT_COMPONENT_VERSION:P(N#0#0)(Rng:0)Len<258>Dim<1>KEY1<0>Rec<1>
- Rec: 1, 2 Row: 1 Qual: 1 Len: 91
- *
- *
- *
- ********************************************************************************
- *
- Component Name: DM_README_STATUS
- *
- Process Description: Writing message to log file.
- *
- Error Message: Message couldn't write to log file since name passed in was invalid.
- *
- ********************************************************************************
- *
- *
- *
- *
- *
- *
- ********************************************************************************
- *
- Determining if DM_INFO exists.
- *
- ********************************************************************************
- *
- *
- *
- RDB
- SELECT /*+ CCL<DM_README_STATUS:S0000:O8:R000:Q87.1> */ UTC.TABLE_NAME FROM USER_TAB_COLUMNS U TC WHERE UTC.T
- ABLE_NAME = 'DM_INFO'
- GO
- RDBMS ReCompile Req:1 Inlen:137 Stat:0
- RDBMS Fetch Req:1 Outlen:6800 Array:200
- 0)USER_TAB_COLUMNS:UTC(N#0#0)(Rng:0)Len<32466>Dim<1>KEY1<0>Rec<12>
- 1)DTABLE:DT(N#2#0)(Rng:1)Len<736>Dim<1>KEY1<36>Rec<12>
- Rec: 12, 37 Row: 24 Qual: 12 Len: 12
- *
- *
- *
- ********************************************************************************
- *
- Component Name: DM_README_STATUS
- *
- Process Description: Writing message to log file.
- *
- Error Message: Message couldn't write to log file since name passed in was invalid.
- *
- ********************************************************************************
- *
- *
- *
- *
- *
- *
- ********************************************************************************
- *
- Check for DM_README_TOOLSET row.
- *
- ********************************************************************************
- *
- *
- *
- RDB
- SELECT /*+ CCL<DM_README_STATUS:S0000:O8:R000:Q88.1> */ 0 FROM DM_INFO D WHERE D.INFO_DOMAI N = 'DATA MA
- NAGEMENT' AND D.INFO_NAME = 'DM_README_TOOLSET'
- GO
- RDBMS ReCompile Req:1 Inlen:163 Stat:0
- RDBMS Fetch Req:1 Outlen:1200 Array:200
- 0)DM_INFO:D(N#0#0)(Rng:0)Len<4417>Dim<1>KEY1<0>Rec<0>
- Rec: 0, 1 Row: 0 Qual: 0 Len: 12
- RDB
- SELECT /*+ CCL<DM_README_STATUS:S0000:O8:R000:Q89.1> */ DE.ENVIRONMENT_ID FROM DM_ENVIRONMENT DE ,
- DM_INFO D WHERE D.INFO_DOMAIN = 'DATA MANAGEMENT' AND D.INFO_NAME = 'DM_ENV_ID' AND D.INFO _NUMBER = DE
- .ENVIRONMENT_ID
- GO
- RDBMS ReCompile Req:1 Inlen:229 Stat:0
- RDBMS Fetch Req:1 Outlen:2000 Array:200
- ccldsri_err(E): error(28001) loc(2) state(0) qry(1.1) par(0) level(L3,P2) com(SELECT /*+ CCL<DM_ README_STATUS:S0000:O8:R000:Q8)
- %CCL-E-284-DM_README_STATUS(0,0)S0L3.2d6{}[ORA-28001]ORA-28001: the password has expired
- ORA-02063: preceding line from ADMIN1
- 0)DM_INFO:D(N#0#0)(Rng:0)Len<4417>Dim<1>KEY1<0>Rec<0>
- 1)DM_ENVIRONMENT:DE(N#5#0)(Rng:1)Len<868>Dim<1>Row<0>
- Rec: 0, 0 Row: 0 Qual: 0 Len: 19
- *
- *
- *
- ********************************************************************************
- *
- Component Name: DM_README_STATUS
- *
- Process Description: Check for DM_README_TOOLSET row.
- *
- Error Message: %CCL-E-284-DM_README_STATUS(0,0)S0L3.2d6{}[ORA-28001]ORA-28001: the password has e xpired ORA-02063: preceding line
- from ADMIN1
- *
- ********************************************************************************
- *
- *
- *
- 170316:103543 DEP_DBIMPORT_WRAPPER Cost 0.02 Cpu 0.00 Ela 0.40 Bio 0 Dio 0 O0M0R0 P2R 43C1E2 S7,7
- Command executed!
- 1)select info_name=substring(1,12,info_name), info_number, info_char from dm_info
- 2)where info_name in ("DM_ENV_NAME","DM_ENV_ID") go
- RDB
- SELECT /*+ CCL<CCL:S0000:O8:R000:Q00.1> */ X.INFO_NUMBER,X.INFO_CHAR,
- X.INFO_NAME FROM DM_INFO X WHERE (X.INFO_NAME = :1 OR X.INFO_NAME = :2 )
- GO
- Rec: 0, 0 Row: 0 Qual: 0 Sort: 0
- BIND(Q1:1:1) CHAR[11](DM_ENV_NAME)
- BIND(Q1:2:2) CHAR[9](DM_ENV_ID) Array:25
- H
- ........10........20........30........40........50........60........70........80........90.......100.......110.......120......
- INFO_NAME INFO_NUMBER INFO_CHAR
- DM_ENV_ID 11547620.00 CERT
- DM_ENV_NAME 0.00 CERT
- Rows: 2 Cols: 2028 Multi Down
- EXIT VIEW FIND PRINT HELP SCROLL BREAK DIRECTION WIDTH MARGIN
- 0)DM_INFO:DM_INFO(N#0#0)(Rng:0)Len<4417>Dim<1>KEY1<0>Rec<2>
- Rec: 2, 3 Row: 2 Qual: 2 Len: 2029
- Command executed!
- 1)select * from dm_environment order by environment_id desc go
- RDB
- SELECT /*+ CCL<CCL:S0000:O8:R000:Q00.1> */ X.ENVIRONMENT_ID,X.DESCRIPTION,X.E NVIRONMENT_NAME,X.DATABASE_NAME,
- X.TOTAL_DATABASE_SIZE,X.TARGET_OPERATING_SYSTEM,X.DATABASE_DISK,X.DATABASE_ARCH IVE_DISK,
- X.DATA_FILE_PARTITION_SIZE,X.ADMIN_DBASE_LINK_NAME,X.SCHEMA_VERSION,X.FROM_SCHE MA_VERSION,X.CONTROL_FILE_COUNT,
- X.REDO_LOG_GROUPS,X.REDO_LOG_MEMBERS,X.DB_VERSION,X.VERSION_ID,X.TEMPORARY_TSPA CE_DISK,X.SYSTEM_TSPACE_DISK,
- X.ROOT_DIR_NAME,X.VOLUME_GROUP,X.V500_CONNECT_STRING,X.V500REF_CONNECT_STRING,X .UPDT_APPLCTX,X.UPDT_DT_TM,
- X.UPDT_CNT,X.UPDT_ID,X.UPDT_TASK,X.MONTH_CNT,X.CERNER_FS_MTPT,X.ORA_PRI_FS_MTPT ,X.ORA_SEC_FS_MTPT,
- X.ORACLE_VERSION,X.MAX_FILE_SIZE,X.ENVSET_STRING,
- X.PRODUCTION_IND FROM DM_ENVIRONMENT X ORDER BY X.ENVIRONMENT_ID DESC
- GO
- RDBMS ReCompile Req:1 Inlen:745 Stat:0
- Rec: 0, 0 Row: 0 Qual: 0 Sort: 0ccldsri_err(E): error(2 8001) loc(2) state(0) qry(1.1) par(0) level(L1,P0) com(SELECT /*+ CCL<CCL:S000 0:O8:R000:Q00.1> */ X.ENV)
- %CCL-E-284-CCL(0,0)S0L1.0d6{}[ORA-28001]ORA-28001: the password has expired
- ORA-02063: preceding line from ADMIN1
- H
- ........10........20........30........40........50........60........70........80........90.......100.......110.......120......
- ENVIRONMENT_ID DESCRIPTION ENVIRONMENT_NAME DATABASE_NAME TOTAL_DATABASE_
- BROWSER with 1064 Cols Multi Down
- EXIT VIEW FIND PRINT HELP SCROLL BREAK DIRECTION WIDTH MARGIN
- 0)DM_ENVIRONMENT:DM_ENVIRONMENT(N#0#0)(Rng:0)Len<868>Dim<1>KEY1<0>Rec<0>
- Rec: 0, 0 Row: 0 Qual: 0 Len: 1065
- Command not executed due to error!
- 1)select * from dm_environment order by environment_id desc go
- RDB
- SELECT /*+ CCL<CCL:S0000:O8:R000:Q00.1> */ X.ENVIRONMENT_ID,X.DESCRIPTION,X.E NVIRONMENT_NAME,X.DATABASE_NAME,
- X.TOTAL_DATABASE_SIZE,X.TARGET_OPERATING_SYSTEM,X.DATABASE_DISK,X.DATABASE_ARCH IVE_DISK,
- X.DATA_FILE_PARTITION_SIZE,X.ADMIN_DBASE_LINK_NAME,X.SCHEMA_VERSION,X.FROM_SCHE MA_VERSION,X.CONTROL_FILE_COUNT,
- X.REDO_LOG_GROUPS,X.REDO_LOG_MEMBERS,X.DB_VERSION,X.VERSION_ID,X.TEMPORARY_TSPA CE_DISK,X.SYSTEM_TSPACE_DISK,
- X.ROOT_DIR_NAME,X.VOLUME_GROUP,X.V500_CONNECT_STRING,X.V500REF_CONNECT_STRING,X .UPDT_APPLCTX,X.UPDT_DT_TM,
- X.UPDT_CNT,X.UPDT_ID,X.UPDT_TASK,X.MONTH_CNT,X.CERNER_FS_MTPT,X.ORA_PRI_FS_MTPT ,X.ORA_SEC_FS_MTPT,
- X.ORACLE_VERSION,X.MAX_FILE_SIZE,X.ENVSET_STRING,
- X.PRODUCTION_IND FROM DM_ENVIRONMENT X ORDER BY X.ENVIRONMENT_ID DESC
- GO
- RDBMS ReCompile Req:1 Inlen:745 Stat:0
- Rec: 0, 0 Row: 0 Qual: 0 Sort: 0ccldsri_err(E): error(2 8001) loc(2) state(0) qry(1.1) par(0) level(L1,P0) com(SELECT /*+ CCL<CCL:S000 0:O8:R000:Q00.1> */ X.ENV)
- %CCL-E-284-CCL(0,0)S0L1.0d6{}[ORA-28001]ORA-28001: the password has expired
- ORA-02063: preceding line from ADMIN1
- H
- ........10........20........30........40........50........60........70........80........90.......100.......110.......120......
- ENVIRONMENT_ID DESCRIPTION ENVIRONMENT_NAME DATABASE_NAME TOTAL_DATABASE_
- BROWSER with 1064 Cols Multi Down
- EXIT VIEW FIND PRINT HELP SCROLL BREAK DIRECTION WIDTH MARGIN
- 0)DM_ENVIRONMENT:DM_ENVIRONMENT(N#0#0)(Rng:0)Len<868>Dim<1>KEY1<0>Rec<0>
- Rec: 0, 0 Row: 0 Qual: 0 Len: 1065
- Command not executed due to error!
- 1)select * from v$database@admin1 go
- RDB
- SELECT /*+ CCL<CCL:S0000:O8:R000:Q00.1> */ X.DBID,X.NAME,X.CREATED,X.RESETLOG S_CHANGE#,X.RESETLOGS_TIME,
- X.PRIOR_RESETLOGS_CHANGE#,X.PRIOR_RESETLOGS_TIME,X.LOG_MODE,X.CHECKPOINT_CHANGE #,X.ARCHIVE_CHANGE#,
- X.CONTROLFILE_TYPE,X.CONTROLFILE_CREATED,X.CONTROLFILE_SEQUENCE#,X.CONTROLFILE_ CHANGE#,X.CONTROLFILE_TIME,
- X.OPEN_RESETLOGS,X.VERSION_TIME,X.OPEN_MODE,X.PROTECTION_MODE,X.PROTECTION_LEVE L,X.REMOTE_ARCHIVE,X.ACTIVATION#,
- X.SWITCHOVER#,X.DATABASE_ROLE,X.ARCHIVELOG_CHANGE#,X.ARCHIVELOG_COMPRESSION,X.S WITCHOVER_STATUS,
- X.DATAGUARD_BROKER,X.GUARD_STATUS,X.SUPPLEMENTAL_LOG_DATA_MIN,X.SUPPLEMENTAL_LO G_DATA_PK,
- X.SUPPLEMENTAL_LOG_DATA_UI,X.FORCE_LOGGING,X.PLATFORM_ID,X.PLATFORM_NAME,X.RECO VERY_TARGET_INCARNATION#,
- X.LAST_OPEN_INCARNATION#,X.CURRENT_SCN,X.FLASHBACK_ON,X.SUPPLEMENTAL_LOG_DATA_F K,X.SUPPLEMENTAL_LOG_DATA_ALL,
- X.DB_UNIQUE_NAME,X.STANDBY_BECAME_PRIMARY_SCN,X.FS_FAILOVER_STATUS,X.FS_FAILOVE R_CURRENT_TARGET,
- X.FS_FAILOVER_THRESHOLD,X.FS_FAILOVER_OBSERVER_PRESENT,X.FS_FAILOVER_OBSERVER_H OST,X.CONTROLFILE_CONVERTED,
- X.PRIMARY_DB_UNIQUE_NAME,X.SUPPLEMENTAL_LOG_DATA_PL,
- X.MIN_REQUIRED_CAPTURE_CHANGE# FROM V$DATABASE@ADMIN1 X
- GO
- Rec: 0, 0 Row: 0 Qual: 0 Sort: 0ccldsri_err(E): error(2 8001) loc(2) state(0) qry(1.1) par(0) level(L1,P0) com(SELECT /*+ CCL<CCL:S000 0:O8:R000:Q00.1> */ X.DBI)33250 Array:130
- %CCL-E-284-CCL(0,0)S0L1.0d6{}[ORA-28001]ORA-28001: the password has expired
- ORA-02063: preceding line from ADMIN1
- H
- ........10........20........30........40........50........60........70........80........90.......100.......110.......120......
- DBID NAME CREATED RESETLOGS_CHANGE# RESETLOGS_TIME PRIOR_RESETLOGS_CHANGE# PRIOR_RESETLOGS_TIME LOG_MODE C
- BROWSER with 1362 Cols Multi Down
- EXIT VIEW FIND PRINT HELP SCROLL BREAK DIRECTION WIDTH MARGIN
- 0)V$DATABASE@ADMIN1:V$DATABASE@ADMIN1(N#0#0)(Rng:0)Len<881>Dim<1>KEY1<0>Rec<0>
- Rec: 0, 0 Row: 0 Qual: 0 Len: 1363
- Command not executed due to error!
- 1)select * from dba_db_links go
- RDB
- SELECT /*+ CCL<CCL:S0000:O8:R000:Q00.1> */ X.OWNER,X.DB_LINK,X.USERNAME,X.HOS T,
- X.CREATED FROM DBA_DB_LINKS X
- GO
- RDBMS ReCompile Req:1 Inlen:113 Stat:0
- RDBMS Fetch Req:1 Outlen:110700 Array:50
- Rec: 0, 0 Row: 0 Qual: 0 Sort: 0
- H
- 570.......580.......590.......600.......610.......620.......630.......640.......650.......660.......670.......680.......690...
- Rows: 4 Cols: 2200 Multi Down
- EXIT VIEW FIND PRINT HELP SCROLL BREAK DIRECTION WIDTH MARGIN
- 0)DBA_DB_LINKS:DBA_DB_LINKS(N#0#0)(Rng:0)Len<2214>Dim<1>KEY1<0>Rec<4>
- Rec: 4, 5 Row: 4 Qual: 4 Len: 2201
- Command executed!
- 1)exit
- CCL LOG(03/16/17 10:38) Pool(405) Sym(ms1066,ls1066) Rdbms(253250)
- CCL CACHE Rng(Max:200 Hit:16 Mis:11 Ful:0) Prg(Max:200 Siz:125 Hit:1 Mis:16 Ful: 0 Ovr:14)
- ccldsri_close prg(CCL) level(L0,P0)
- RDBMS tran(ROLLBACK,R0,F1,C0,S0,CCL)
- Removing CCL temp files for session...
- Ccldir(2W_63) Stat(Reopen:0,Par:3)
- CclExit(File:0 Beg:402 End:0 Blk:14) <Dcl:0 Work:0 Prg:2 Rng:18 Var:77 Sub:286 E ks:0 Misc:19>
- SESSION COMPLETE(CCL Rev:8.7.2 Hnam:01OCT2011).
- root:cert@(srvlabaix):/:
- # sqlplus cdba/cdba@admin1
- SQL*Plus: Release 11.1.0.7.0 - Production on Thu Mar 16 10:39:05 2017
- Copyright (c) 1982, 2008, Oracle. All rights reserved.
- ERROR:
- ORA-28001: the password has expired
- Changing password for cdba
- New password:
- Retype new password:
- ERROR:
- ORA-00988: missing or invalid password(s)
- Password unchanged
- Enter user-name: exit
- Enter password:
- ERROR:
- ORA-01005: null password given; logon denied
- Enter user-name:
- ERROR:
- ORA-01017: invalid username/password; logon denied
- SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
- root:cert@(srvlabaix):/:
- # ps -ef | grep pmon
- oracle 8257544 1 0 Dec 27 - 119:36 asm_pmon_+ASM
- oracle 8978570 1 0 Dec 27 - 268:56 ora_pmon_prod1
- oracle 11010132 1 0 Dec 27 - 130:45 ora_pmon_gcat1
- oracle 13107380 1 0 Dec 27 - 150:55 ora_pmon_admin1
- oracle 34144528 1 0 Sep 08 - 42:51 ora_pmon_cert1
- root 33686270 25952702 0 10:40:46 pts/1 0:00 grep pmon
- root:cert@(srvlabaix):/:
- # su -
- Environment 'common' set.
- root:common@(srvlabaix):/:
- # su - oracle
- [YOU HAVE NEW MAIL]
- oracle@srvlabaix:/home/oracle>
- $ echo $ORACLE_HOME
- /u01/oracle/product/11.1.0.7/db
- oracle@srvlabaix:/home/oracle>
- $ echo $ORACLE_SID
- oracle@srvlabaix:/home/oracle>
- $ export ORACLE_SID=admin1
- oracle@srvlabaix:/home/oracle>
- $ sqlplus '/as sysdba'
- SQL*Plus: Release 11.1.0.7.0 - Production on Thu Mar 16 10:42:06 2017
- Copyright (c) 1982, 2008, Oracle. All rights reserved.
- ERROR:
- ORA-09817: Write to audit file failed.
- IBM AIX RISC System/6000 Error: 28: No space left on device
- ORA-01075: you are currently logged on
- Enter user-name:
- ERROR:
- ORA-01017: invalid username/password; logon denied
- Enter user-name:
- ERROR:
- ORA-01017: invalid username/password; logon denied
- SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
- oracle@srvlabaix:/home/oracle>
- $ df -P
- Filesystem 512-blocks Used Available Capacity Mounted on
- /dev/hd4 2621440 1944016 677424 75% /
- /dev/hd2 8912896 5775448 3137448 65% /usr
- /dev/hd9var 4194304 3791040 403264 91% /var
- /dev/hd3 8388608 1988496 6400112 24% /tmp
- /dev/hd1 2097152 203296 1893856 10% /home
- /proc - - - - /proc
- /dev/hd10opt 2097152 419328 1677824 20% /opt
- /dev/oracle01lv 26607616 11645104 14962512 44% /u01
- /dev/oracle02lv 12288000 12288000 0 100% /u02
- /dev/cerner01lv 524288 160712 363576 31% /cerner
- /dev/cerner02lv 2097152 1040 2096112 1% /cerner/w_standard
- /dev/cerner03lv 1048576 804456 244120 77% /cerner/d_admin
- /dev/cerner06lv 1048576 826680 221896 79% /cerner/b_common
- /dev/mq01lv 524288 36456 487832 7% /var/mqm
- /dev/mq02lv 10485760 8196280 2289480 79% /var/mqm/log
- /dev/cerner09lv 6291456 3201560 3089896 51% /cerner/d_prod
- /dev/cerner10lv 4194304 2038264 2156040 49% /cerner/d_prod/ccldir
- /dev/cerner11lv 10485760 7819000 2666760 75% /cerner/d_prod/ccluserdi r
- /dev/cerner12lv 720896 28176 692720 4% /cerner/d_prod/print
- /dev/cerner13lv 1048576 901208 147368 86% /cerner/d_prod/log
- /dev/cerner14lv 16777216 13223456 3553760 79% /cerner/w_standard/prod_ wh
- /dev/cerner15lv 23068672 2641808 20426864 12% /cerner/d_prod/ocd
- /dev/cernernmonlv 1572864 51456 1521408 4% /cerner/nmon
- /dev/prodarchlv 83492864 13744 83479120 1% /u02/oracle/admin/mock/a rch
- /dev/backuplv 905641984 658287760 247354224 73% /backup
- /dev/atglv 20971520 7659848 13311672 37% /atg
- /dev/stagelv 52428800 45878040 6550760 88% /stage
- /dev/oracle04lv 33488896 33058808 430088 99% /u01/oracle/product/11.1 .0.7/asm
- /dev/oracle03lv 33488896 30726296 2762600 92% /u01/oracle/product/11.1 .0.7/db
- /dev/cerner17lv 4194304 2036152 2158152 49% /cerner/d_prod/ccldir2
- /dev/cerner18lv 4194304 353840 3840464 9% /cerner/d_prod/temp
- /dev/cerner19lv 10485760 2264 10483496 1% /cerner/d_prod/cclscratc h
- /dev/livedump 524288 736 523552 1% /var/adm/ras/livedump
- /dev/cerner2lv01 6291456 125912 6165544 3% /cerner/d_cert
- /dev/cerner2lv02 4194304 1334128 2860176 32% /cerner/d_cert/ccldir
- /dev/cerner2lv03 4194304 1335952 2858352 32% /cerner/d_cert/ccldir2
- /dev/cerner2lv04 10485760 1120120 9365640 11% /cerner/d_cert/ccluserd ir
- /dev/cerner2lv05 524288 128576 395712 25% /cerner/d_cert/log
- /dev/cerner2lv06 4194304 7312 4186992 1% /cerner/d_cert/temp
- /dev/cerner2lv07 10485760 1096712 9389048 11% /cerner/d_cert/ocd
- /dev/cerner2lv11 10485760 2264 10483496 1% /cerner/d_cert/cclscrat ch
- /dev/cerner2lv08 14680064 14234392 445672 97% /cerner/w_standard/cert _wh
- oracle@srvlabaix:/home/oracle>
- $
- oracle@srvlabaix:/home/oracle>
- $ ls -ltr /u02
- total 0
- drwxr-xr-x 2 oracle dba 256 Jan 11 2012 lost+found
- drwxr-xr-x 3 oracle dba 256 Jan 11 2012 oracle
- drwxr-x--- 3 oracle oinstall 256 Jan 31 2012 cfgtoollogs
- drwxr-xr-x 3 oracle oinstall 256 Jan 31 2012 oradiag_oracle
- drwxrwxr-x 5 oracle oinstall 256 Jan 31 2012 diag
- drwxrwxr-x 3 root d_prod 256 Feb 03 2012 oradiag_root
- drwxr-xr-x 4 oracle oinstall 256 Feb 10 2012 admin
- oracle@srvlabaix:/home/oracle>
- $ cd oracle
- ksh: oracle: not found.
- oracle@srvlabaix:/home/oracle>
- $ ls
- 04apr12from9amto10am.lst awrrpt_1_29439_29446.txt rman_assessment-06-FEB-2017.html
- CERT_stats.dmp check_archive_space_mock.ksh rman_healthcheck_html.sql
- addmrpt9amto10am.lst core smit.log
- addmrpt_1_29415_29421.txt db_assessment_report-16-APR-2012.html smit.script
- admin_db_assessment_report-07-FEB-2017.html db_assessment_report-22-JUN-2015.html smit.transaction
- ashrpt_1_1227_0915.html db_health_check_html.sql source_io.out
- ashrpt_1_1227_1225.txt db_health_check_html.sql_06222015 source_oc.out
- atl_md_awr_4-4-12_8-9am.html diff_awr.lst sqlnet.log
- atlmd_4-4-12_7-8am.html dm_stat_table.par target_io.out
- awrrpt_1_16432_16433.txt oracle11.1 target_oc.out
- awrrpt_1_16433_16434.txt oradiag_oracle txt
- awrrpt_1_29415_29419.txt prod_db_assessment_report-06-FEB-2017.html update_idx.sql
- oracle@srvlabaix:/home/oracle>
- $ cd ..
- oracle@srvlabaix:/home>
- $ cd diag
- ksh: diag: not found.
- oracle@srvlabaix:/home>
- $ ls
- autolog d_prod olympus zabbix
- b_common guest oracle
- d_admin lightson post_migration.120202135922
- d_cert lost+found post_migration.120202145059
- oracle@srvlabaix:/home>
- $ cd /u02
- oracle@srvlabaix:/u02>
- $ ls
- admin cfgtoollogs diag lost+found oracle oradiag_oracle oradiag_root
- oracle@srvlabaix:/u02>
- $ cd diag
- oracle@srvlabaix:/u02/diag>
- $ ls
- asm rdbms tnslsnr
- oracle@srvlabaix:/u02/diag>
- $ cd rdbms
- oracle@srvlabaix:/u02/diag/rdbms>
- $ ls -ltr
- total 0
- drwxr-x--- 3 oracle oinstall 256 Jan 31 2012 cert
- drwxr-x--- 3 oracle oinstall 256 Feb 10 2012 prod
- drwxr-xr-x 3 oracle oinstall 256 Feb 22 2012 gcat
- drwxr-xr-x 3 oracle oinstall 256 Apr 17 2012 admin
- oracle@srvlabaix:/u02/diag/rdbms>
- $ cd prod
- oracle@srvlabaix:/u02/diag/rdbms/prod>
- $ ls -ltr
- total 0
- drwxr-x--- 13 oracle oinstall 4096 Feb 10 2012 prod1
- -rw-r----- 1 oracle oinstall 0 Feb 10 2012 i_1.mif
- oracle@srvlabaix:/u02/diag/rdbms/prod>
- $ ls -ltR
- total 0
- -rw-r----- 1 oracle oinstall 0 Feb 10 2012 i_1.mif
- drwxr-x--- 13 oracle oinstall 4096 Feb 10 2012 prod1
- ./prod1:
- total 0
- drwxr-x--- 2 oracle oinstall 65536 Mar 16 09:27 trace
- drwxr-x--- 2 oracle oinstall 256 Aug 20 2016 cdump
- drwxr-x--- 2 oracle oinstall 4096 Aug 05 2016 lck
- drwxr-x--- 2 oracle oinstall 256 Aug 05 2016 sweep
- drwxr-x--- 3 oracle oinstall 256 Aug 05 2016 incident
- drwxr-x--- 2 oracle oinstall 256 Aug 05 2016 stage
- drwxr-x--- 2 oracle oinstall 256 May 10 2016 alert
- drwxr-x--- 2 oracle oinstall 256 Feb 14 2012 ir
- drwxr-x--- 2 oracle oinstall 4096 Feb 10 2012 metadata
- drwxr-x--- 2 oracle oinstall 256 Feb 10 2012 hm
- drwxr-x--- 2 oracle oinstall 256 Feb 10 2012 incpkg
- ./prod1/trace:
- total 0
- -rw-r----- 1 oracle oinstall 6831124 Mar 16 10:20 alert_prod1.log
- -rw-r----- 1 oracle oinstall 0 Mar 16 09:27 prod1_ora_30933270.trc
- -rw-r----- 1 oracle oinstall 0 Mar 16 08:49 prod1_ora_19005506.trc
- -rw-r----- 1 oracle oinstall 0 Mar 16 06:00 prod1_ora_37421654.trc
- -rw-r----- 1 oracle oinstall 0 Mar 16 03:15 prod1_ora_37421640.trc
- -rw-r----- 1 oracle oinstall 751 Mar 16 02:00 prod1_m000_12059168.trc
- -rw-r----- 1 oracle oinstall 64 Mar 16 02:00 prod1_m000_12059168.trm
- -rw-r----- 1 oracle oinstall 0 Mar 16 01:01 prod1_ora_16515534.trc
- -rw-r----- 1 oracle oinstall 0 Mar 16 00:15 prod1_ora_30736790.trc
- -rw-r----- 1 oracle oinstall 0 Mar 15 22:45 prod1_ora_25756358.trc
- -rw-r----- 1 oracle oinstall 0 Mar 15 22:00 prod1_j000_62718130.trc
- -rw-r----- 1 oracle oinstall 0 Mar 15 21:34 prod1_cjq0_2687680.trc
- -rw-r----- 1 oracle oinstall 0 Mar 15 19:00 prod1_ora_15401544.trc
- -rw-r----- 1 oracle oinstall 0 Mar 15 17:09 prod1_ora_60293130.trc
- -rw-r----- 1 oracle oinstall 0 Mar 15 15:00 prod1_ora_15859726.trc
- -rw-r----- 1 oracle oinstall 0 Mar 15 15:00 prod1_ora_17105186.trc
- -rw-r----- 1 oracle oinstall 0 Mar 15 09:08 prod1_ora_28574340.trc
- -rw-r----- 1 oracle oinstall 0 Mar 15 09:06 prod1_ora_2097880.trc
- -rw-r----- 1 oracle oinstall 0 Mar 15 06:00 prod1_ora_25297312.trc
- -rw-r----- 1 oracle oinstall 0 Mar 15 05:45 prod1_ora_22413936.trc
- -rw-r----- 1 oracle oinstall 0 Mar 15 02:00 prod1_m000_34669192.trc
- -rw-r----- 1 oracle oinstall 0 Mar 15 00:15 prod1_ora_65274066.trc
- -rw-r----- 1 oracle oinstall 0 Mar 14 22:00 prod1_j000_44892668.trc
- -rw-r----- 1 oracle oinstall 0 Mar 14 21:34 prod1_cjq0_44565224.trc
- -rw-r----- 1 oracle oinstall 0 Mar 14 19:15 prod1_ora_37421778.trc
- -rw-r----- 1 oracle oinstall 0 Mar 14 06:00 prod1_ora_50069900.trc
- -rw-r----- 1 oracle oinstall 0 Mar 14 03:15 prod1_ora_37421684.trc
- -rw-r----- 1 oracle oinstall 0 Mar 14 02:00 prod1_m000_22544586.trc
- -rw-r----- 1 oracle oinstall 0 Mar 13 23:45 prod1_ora_47251500.trc
- -rw-r----- 1 oracle oinstall 0 Mar 13 22:45 prod1_ora_41746532.trc
- -rw-r----- 1 oracle oinstall 0 Mar 13 22:00 prod1_j000_54788218.trc
- -rw-r----- 1 oracle oinstall 0 Mar 13 21:33 prod1_cjq0_63504780.trc
- -rw-r----- 1 oracle oinstall 0 Mar 13 13:00 prod1_ora_29295322.trc
- -rw-r----- 1 oracle oinstall 0 Mar 13 13:00 prod1_ora_56754294.trc
- -rw-r----- 1 oracle oinstall 0 Mar 13 12:00 prod1_ora_25100614.trc
- -rw-r----- 1 oracle oinstall 0 Mar 13 06:00 prod1_ora_16974080.trc
- -rw-r----- 1 oracle oinstall 0 Mar 13 02:00 prod1_m000_62587180.trc
- -rw-r----- 1 oracle oinstall 0 Mar 12 07:45 prod1_ora_39977404.trc
- -rw-r----- 1 oracle oinstall 0 Mar 12 06:15 prod1_ora_39256084.trc
- -rw-r----- 1 oracle oinstall 0 Mar 12 06:01 prod1_ora_54264044.trc
- -rw-r----- 1 oracle oinstall 0 Mar 12 06:00 prod1_j000_28508482.trc
- -rw-r----- 1 oracle oinstall 0 Mar 12 05:32 prod1_cjq0_16974300.trc
- -rw-r----- 1 oracle oinstall 0 Mar 12 03:00 prod1_m000_20709626.trc
- -rw-r----- 1 oracle oinstall 0 Mar 11 22:15 prod1_ora_39125396.trc
- -rw-r----- 1 oracle oinstall 0 Mar 11 18:15 prod1_ora_8847850.trc
- -rw-r----- 1 oracle oinstall 0 Mar 11 17:45 prod1_ora_10682710.trc
- -rw-r----- 1 oracle oinstall 0 Mar 11 17:15 prod1_ora_25756246.trc
- -rw-r----- 1 oracle oinstall 0 Mar 11 14:15 prod1_ora_30736802.trc
- -rw-r----- 1 oracle oinstall 0 Mar 11 11:19 prod1_ora_24117544.trc
- -rw-r----- 1 oracle oinstall 0 Mar 11 11:15 prod1_ora_16515414.trc
- -rw-r----- 1 oracle oinstall 0 Mar 11 10:45 prod1_ora_64290878.trc
- -rw-r----- 1 oracle oinstall 0 Mar 11 06:00 prod1_ora_7864752.trc
- -rw-r----- 1 oracle oinstall 0 Mar 11 06:00 prod1_j000_42401830.trc
- -rw-r----- 1 oracle oinstall 0 Mar 11 05:31 prod1_cjq0_3801402.trc
- -rw-r----- 1 oracle oinstall 0 Mar 11 02:00 prod1_m000_7996030.trc
- -rw-r----- 1 oracle oinstall 0 Mar 11 01:01 prod1_ora_39977264.trc
- -rw-r----- 1 oracle oinstall 0 Mar 11 01:00 prod1_m000_36962714.trc
- -rw-r----- 1 oracle oinstall 0 Mar 10 22:00 prod1_j000_60424474.trc
- -rw-r----- 1 oracle oinstall 0 Mar 10 21:31 prod1_cjq0_44565164.trc
- -rw-r----- 1 oracle oinstall 0 Mar 10 17:16 prod1_ora_30736760.trc
- -rw-r----- 1 oracle oinstall 0 Mar 10 14:45 prod1_ora_30736732.trc
- -rw-r----- 1 oracle oinstall 0 Mar 10 06:00 prod1_ora_6750596.trc
- -rw-r----- 1 oracle oinstall 0 Mar 10 02:45 prod1_ora_36503858.trc
- -rw-r----- 1 oracle oinstall 0 Mar 10 02:00 prod1_m000_10551726.trc
- -rw-r----- 1 oracle oinstall 0 Mar 10 01:15 prod1_ora_37421732.trc
- -rw-r----- 1 oracle oinstall 0 Mar 10 01:01 prod1_ora_59965606.trc
- -rw-r----- 1 oracle oinstall 0 Mar 09 22:00 prod1_j000_45810134.trc
- -rw-r----- 1 oracle oinstall 0 Mar 09 21:31 prod1_cjq0_13304084.trc
- -rw-r----- 1 oracle oinstall 0 Mar 09 20:15 prod1_ora_57278878.trc
- -rw-r----- 1 oracle oinstall 0 Mar 09 19:45 prod1_ora_25756198.trc
- -rw-r----- 1 oracle oinstall 0 Mar 09 16:04 prod1_ora_24379522.trc
- -rw-r----- 1 oracle oinstall 0 Mar 09 16:04 prod1_ora_49021218.trc
- -rw-r----- 1 oracle oinstall 0 Mar 09 15:46 prod1_ora_26870384.trc
- -rw-r----- 1 oracle oinstall 861444 Mar 09 10:29 prod1_ora_62783562.trc
- -rw-r----- 1 oracle oinstall 22017 Mar 09 10:29 prod1_ora_62783562.trm
- -rw-r----- 1 oracle oinstall 879 Mar 09 06:00 prod1_ora_37028206.trc
- -rw-r----- 1 oracle oinstall 75 Mar 09 06:00 prod1_ora_37028206.trm
- -rw-r----- 1 oracle oinstall 1070 Mar 09 02:23 prod1_ora_28508850.trc
- -rw-r----- 1 oracle oinstall 82 Mar 09 02:23 prod1_ora_28508850.trm
- -rw-r----- 1 oracle oinstall 1500 Mar 09 02:20 prod1_ora_35717270.trc
- -rw-r----- 1 oracle oinstall 111 Mar 09 02:20 prod1_ora_35717270.trm
- -rw-r----- 1 oracle oinstall 1557 Mar 09 02:20 prod1_ora_28508834.trc
- -rw-r----- 1 oracle oinstall 118 Mar 09 02:20 prod1_ora_28508834.trm
- -rw-r----- 1 oracle oinstall 751 Mar 09 02:00 prod1_m000_33686264.trc
- -rw-r----- 1 oracle oinstall 64 Mar 09 02:00 prod1_m000_33686264.trm
- -rw-r----- 1 oracle oinstall 0 Mar 08 22:00 prod1_j000_16908680.trc
- -rw-r----- 1 oracle oinstall 0 Mar 08 21:30 prod1_cjq0_51446244.trc
- -rw-r----- 1 oracle oinstall 0 Mar 08 18:45 prod1_ora_45416640.trc
- -rw-r----- 1 oracle oinstall 0 Mar 08 17:45 prod1_ora_59572334.trc
- -rw-r----- 1 oracle oinstall 0 Mar 08 13:45 prod1_ora_8716712.trc
- -rw-r----- 1 oracle oinstall 0 Mar 08 06:00 prod1_ora_63504878.trc
- -rw-r----- 1 oracle oinstall 0 Mar 08 02:00 prod1_m000_44367894.trc
- -rw-r----- 1 oracle oinstall 0 Mar 07 22:45 prod1_ora_25756388.trc
- -rw-r----- 1 oracle oinstall 0 Mar 07 22:00 prod1_j000_36700602.trc
- -rw-r----- 1 oracle oinstall 0 Mar 07 21:34 prod1_cjq0_24969506.trc
- -rw-r----- 1 oracle oinstall 0 Mar 07 18:45 prod1_ora_9044594.trc
- -rw-r----- 1 oracle oinstall 0 Mar 07 16:15 prod1_ora_9044696.trc
- -rw-r----- 1 oracle oinstall 0 Mar 07 15:45 prod1_ora_3277244.trc
- -rw-r----- 1 oracle oinstall 0 Mar 07 11:15 prod1_ora_3277142.trc
- -rw-r----- 1 oracle oinstall 0 Mar 07 10:45 prod1_ora_3277238.trc
- -rw-r----- 1 oracle oinstall 0 Mar 07 09:45 prod1_ora_25756208.trc
- -rw-r----- 1 oracle oinstall 0 Mar 07 06:00 prod1_ora_54329618.trc
- -rw-r----- 1 oracle oinstall 0 Mar 07 02:00 prod1_m000_58982896.trc
- -rw-r----- 1 oracle oinstall 0 Mar 06 22:45 prod1_ora_15139538.trc
- -rw-r----- 1 oracle oinstall 0 Mar 06 22:00 prod1_j000_25297380.trc
- -rw-r----- 1 oracle oinstall 0 Mar 06 21:34 prod1_cjq0_23462590.trc
- -rw-r----- 1 oracle oinstall 0 Mar 06 15:39 prod1_ora_25559522.trc
- -rw-r----- 1 oracle oinstall 0 Mar 06 15:35 prod1_ora_6881540.trc
- -rw-r----- 1 oracle oinstall 0 Mar 06 15:26 prod1_ora_10683130.trc
- -rw-r----- 1 oracle oinstall 0 Mar 06 15:24 prod1_ora_19005500.trc
- -rw-r----- 1 oracle oinstall 0 Mar 06 15:00 prod1_ora_25100610.trc
- -rw-r----- 1 oracle oinstall 0 Mar 06 15:00 prod1_ora_59179398.trc
- -rw-r----- 1 oracle oinstall 0 Mar 06 07:45 prod1_ora_38535180.trc
- -rw-r----- 1 oracle oinstall 0 Mar 06 07:15 prod1_ora_38535186.trc
- -rw-r----- 1 oracle oinstall 0 Mar 06 06:00 prod1_ora_28312056.trc
- -rw-r----- 1 oracle oinstall 0 Mar 06 02:00 prod1_m000_41746618.trc
- -rw-r----- 1 oracle oinstall 0 Mar 05 14:45 prod1_ora_5964278.trc
- -rw-r----- 1 oracle oinstall 0 Mar 05 13:45 prod1_ora_57344286.trc
- -rw-r----- 1 oracle oinstall 0 Mar 05 12:15 prod1_ora_8847750.trc
- -rw-r----- 1 oracle oinstall 0 Mar 05 06:00 prod1_ora_15204422.trc
- -rw-r----- 1 oracle oinstall 0 Mar 05 06:00 prod1_j000_57213096.trc
- -rw-r----- 1 oracle oinstall 0 Mar 05 05:33 prod1_cjq0_57409898.trc
- -rw-r----- 1 oracle oinstall 0 Mar 05 04:15 prod1_ora_62718180.trc
- -rw-r----- 1 oracle oinstall 0 Mar 05 02:00 prod1_m000_2228702.trc
- -rw-r----- 1 oracle oinstall 0 Mar 04 21:45 prod1_ora_38535278.trc
- -rw-r----- 1 oracle oinstall 0 Mar 04 19:45 prod1_ora_38535328.trc
- -rw-r----- 1 oracle oinstall 0 Mar 04 18:45 prod1_ora_37421652.trc
- -rw-r----- 1 oracle oinstall 0 Mar 04 15:45 prod1_ora_36503932.trc
- -rw-r----- 1 oracle oinstall 0 Mar 04 06:00 prod1_ora_31129996.trc
- -rw-r----- 1 oracle oinstall 0 Mar 04 06:00 prod1_j000_27459832.trc
- -rw-r----- 1 oracle oinstall 0 Mar 04 05:32 prod1_cjq0_45547660.trc
- -rw-r----- 1 oracle oinstall 0 Mar 04 05:15 prod1_ora_8847624.trc
- -rw-r----- 1 oracle oinstall 0 Mar 04 02:00 prod1_m000_44761172.trc
- -rw-r----- 1 oracle oinstall 0 Mar 04 01:01 prod1_ora_34538120.trc
- -rw-r----- 1 oracle oinstall 0 Mar 04 00:55 prod1_m000_11469166.trc
- -rw-r----- 1 oracle oinstall 0 Mar 03 22:00 prod1_j000_12649116.trc
- -rw-r----- 1 oracle oinstall 0 Mar 03 21:32 prod1_cjq0_37618422.trc
- -rw-r----- 1 oracle oinstall 0 Mar 03 19:15 prod1_ora_5964218.trc
- -rw-r----- 1 oracle oinstall 0 Mar 03 14:45 prod1_ora_42533312.trc
- -rw-r----- 1 oracle oinstall 0 Mar 03 14:15 prod1_ora_8847698.trc
- -rw-r----- 1 oracle oinstall 0 Mar 03 13:45 prod1_ora_8847782.trc
- -rw-r----- 1 oracle oinstall 0 Mar 03 11:15 prod1_ora_42533212.trc
- -rw-r----- 1 oracle oinstall 1712 Mar 03 09:31 prod1_ora_59179372.trc
- -rw-r----- 1 oracle oinstall 199 Mar 03 09:31 prod1_ora_59179372.trm
- -rw-r----- 1 oracle oinstall 0 Mar 03 06:00 prod1_ora_38273160.trc
- -rw-r----- 1 oracle oinstall 0 Mar 03 04:45 prod1_ora_41746446.trc
- -rw-r----- 1 oracle oinstall 0 Mar 03 03:45 prod1_ora_41746682.trc
- -rw-r----- 1 oracle oinstall 0 Mar 03 02:00 prod1_m000_42270926.trc
- -rw-r----- 1 oracle oinstall 0 Mar 03 01:02 prod1_ora_42533226.trc
- -rw-r----- 1 oracle oinstall 0 Mar 02 22:00 prod1_j000_49283520.trc
- -rw-r----- 1 oracle oinstall 0 Mar 02 21:31 prod1_cjq0_37618312.trc
- -rw-r----- 1 oracle oinstall 0 Mar 02 16:15 prod1_ora_57803208.trc
- -rw-r----- 1 oracle oinstall 0 Mar 02 14:45 prod1_ora_5964266.trc
- -rw-r----- 1 oracle oinstall 0 Mar 02 09:33 prod1_ora_18940470.trc
- -rw-r----- 1 oracle oinstall 0 Mar 02 06:00 prod1_ora_10813814.trc
- -rw-r----- 1 oracle oinstall 0 Mar 02 02:00 prod1_m000_23003554.trc
- -rw-r----- 1 oracle oinstall 0 Mar 02 01:15 prod1_ora_64290968.trc
- -rw-r----- 1 oracle oinstall 0 Mar 01 22:00 prod1_j000_34603410.trc
- -rw-r----- 1 oracle oinstall 0 Mar 01 21:30 prod1_cjq0_54853710.trc
- -rw-r----- 1 oracle oinstall 0 Mar 01 18:15 prod1_ora_8847644.trc
- -rw-r----- 1 oracle oinstall 0 Mar 01 06:00 prod1_ora_36831632.trc
- -rw-r----- 1 oracle oinstall 1068 Mar 01 02:22 prod1_ora_6292124.trc
- -rw-r----- 1 oracle oinstall 81 Mar 01 02:22 prod1_ora_6292124.trm
- -rw-r----- 1 oracle oinstall 1498 Mar 01 02:20 prod1_ora_6292122.trc
- -rw-r----- 1 oracle oinstall 110 Mar 01 02:20 prod1_ora_6292122.trm
- -rw-r----- 1 oracle oinstall 1558 Mar 01 02:20 prod1_ora_23790282.trc
- -rw-r----- 1 oracle oinstall 118 Mar 01 02:20 prod1_ora_23790282.trm
- -rw-r----- 1 oracle oinstall 751 Mar 01 02:00 prod1_m000_42992328.trc
- -rw-r----- 1 oracle oinstall 64 Mar 01 02:00 prod1_m000_42992328.trm
- -rw-r----- 1 oracle oinstall 0 Mar 01 00:15 prod1_ora_36503946.trc
- -rw-r----- 1 oracle oinstall 0 Feb 28 22:00 prod1_j000_35979774.trc
- -rw-r----- 1 oracle oinstall 0 Feb 28 21:30 prod1_cjq0_6029634.trc
- -rw-r----- 1 oracle oinstall 0 Feb 28 15:15 prod1_ora_36503936.trc
- -rw-r----- 1 oracle oinstall 0 Feb 28 12:46 prod1_ora_48300032.trc
- -rw-r----- 1 oracle oinstall 0 Feb 28 06:00 prod1_ora_35979618.trc
- -rw-r----- 1 oracle oinstall 0 Feb 28 05:15 prod1_ora_36503864.trc
- -rw-r----- 1 oracle oinstall 0 Feb 28 02:00 prod1_m000_25625148.trc
- -rw-r----- 1 oracle oinstall 0 Feb 27 22:45 prod1_ora_47251638.trc
- -rw-r----- 1 oracle oinstall 0 Feb 27 22:15 prod1_ora_64290936.trc
- -rw-r----- 1 oracle oinstall 0 Feb 27 22:00 prod1_j000_37486608.trc
- -rw-r----- 1 oracle oinstall 0 Feb 27 21:34 prod1_cjq0_6029646.trc
- -rw-r----- 1 oracle oinstall 0 Feb 27 17:17 prod1_ora_5702248.trc
- -rw-r----- 1 oracle oinstall 4096 Feb 27 15:00 prod1_ora_46596160.trc
- -rw-r----- 1 oracle oinstall 603 Feb 27 14:00 prod1_ora_46596160.trm
- -rw-r----- 1 oracle oinstall 0 Feb 27 09:45 prod1_ora_37487316.trc
- -rw-r----- 1 oracle oinstall 0 Feb 27 07:15 prod1_ora_49021424.trc
- -rw-r----- 1 oracle oinstall 0 Feb 27 06:00 prod1_ora_13042396.trc
- -rw-r----- 1 oracle oinstall 0 Feb 27 02:00 prod1_m000_131678.trc
- -rw-r----- 1 oracle oinstall 0 Feb 26 09:15 prod1_ora_41746608.trc
- -rw-r----- 1 oracle oinstall 0 Feb 26 08:45 prod1_ora_64290834.trc
- -rw-r----- 1 oracle oinstall 0 Feb 26 06:45 prod1_ora_37552280.trc
- -rw-r----- 1 oracle oinstall 0 Feb 26 06:00 prod1_ora_19202788.trc
- -rw-r----- 1 oracle oinstall 0 Feb 26 06:00 prod1_j000_35389584.trc
- -rw-r----- 1 oracle oinstall 0 Feb 26 05:33 prod1_cjq0_13042192.trc
- -rw-r----- 1 oracle oinstall 0 Feb 26 02:00 prod1_m000_19923284.trc
- -rw-r----- 1 oracle oinstall 0 Feb 25 22:45 prod1_ora_31195208.trc
- -rw-r----- 1 oracle oinstall 0 Feb 25 22:15 prod1_ora_15139452.trc
- -rw-r----- 1 oracle oinstall 0 Feb 25 19:15 prod1_ora_62718086.trc
- -rw-r----- 1 oracle oinstall 0 Feb 25 17:45 prod1_ora_15204532.trc
- -rw-r----- 1 oracle oinstall 0 Feb 25 16:45 prod1_ora_15204366.trc
- -rw-r----- 1 oracle oinstall 0 Feb 25 14:45 prod1_ora_47251600.trc
- -rw-r----- 1 oracle oinstall 0 Feb 25 06:00 prod1_ora_38404202.trc
- -rw-r----- 1 oracle oinstall 0 Feb 25 06:00 prod1_j000_15401624.trc
- -rw-r----- 1 oracle oinstall 0 Feb 25 05:32 prod1_cjq0_3801558.trc
- -rw-r----- 1 oracle oinstall 0 Feb 25 03:45 prod1_ora_57344272.trc
- -rw-r----- 1 oracle oinstall 0 Feb 25 02:00 prod1_m000_4260192.trc
- -rw-r----- 1 oracle oinstall 0 Feb 25 01:15 prod1_ora_31195140.trc
- -rw-r----- 1 oracle oinstall 0 Feb 25 00:52 prod1_m000_33161532.trc
- -rw-r----- 1 oracle oinstall 0 Feb 24 22:00 prod1_j000_11272944.trc
- -rw-r----- 1 oracle oinstall 0 Feb 24 21:32 prod1_cjq0_32703080.trc
- -rw-r----- 1 oracle oinstall 778240 Feb 24 18:25 prod1_ora_41288414.trc
- -rw-r----- 1 oracle oinstall 21769 Feb 24 18:25 prod1_ora_41288414.trm
- -rw-r----- 1 oracle oinstall 0 Feb 24 14:13 prod1_ora_21627462.trc
- -rw-r----- 1 oracle oinstall 0 Feb 24 10:53 prod1_ora_18612406.trc
- -rw-r----- 1 oracle oinstall 0 Feb 24 06:00 prod1_ora_37748750.trc
- -rw-r----- 1 oracle oinstall 0 Feb 24 02:00 prod1_m000_63832268.trc
- -rw-r----- 1 oracle oinstall 0 Feb 23 22:00 prod1_j000_31195294.trc
- -rw-r----- 1 oracle oinstall 0 Feb 23 21:31 prod1_cjq0_60096560.trc
- -rw-r----- 1 oracle oinstall 0 Feb 23 18:45 prod1_ora_31195258.trc
- -rw-r----- 1 oracle oinstall 0 Feb 23 15:45 prod1_ora_31195178.trc
- -rw-r----- 1 oracle oinstall 0 Feb 23 15:15 prod1_ora_37552358.trc
- -rw-r----- 1 oracle oinstall 0 Feb 23 06:00 prod1_ora_42205526.trc
- -rw-r----- 1 oracle oinstall 0 Feb 23 02:00 prod1_m000_8651502.trc
- -rw-r----- 1 oracle oinstall 0 Feb 23 01:02 prod1_ora_15532454.trc
- -rw-r----- 1 oracle oinstall 0 Feb 22 22:00 prod1_j000_42664300.trc
- -rw-r----- 1 oracle oinstall 0 Feb 22 21:30 prod1_ora_10683126.trc
- -rw-r----- 1 oracle oinstall 0 Feb 22 21:30 prod1_cjq0_34734326.trc
- -rw-r----- 1 oracle oinstall 0 Feb 22 13:07 prod1_ora_3539476.trc
- -rw-r----- 1 oracle oinstall 0 Feb 22 08:45 prod1_ora_45089382.trc
- -rw-r----- 1 oracle oinstall 0 Feb 22 06:00 prod1_ora_63504860.trc
- -rw-r----- 1 oracle oinstall 0 Feb 22 02:00 prod1_m000_7996142.trc
- -rw-r----- 1 oracle oinstall 0 Feb 21 22:00 prod1_j000_37683400.trc
- -rw-r----- 1 oracle oinstall 0 Feb 21 21:34 prod1_cjq0_3539676.trc
- -rw-r----- 1 oracle oinstall 0 Feb 21 21:30 prod1_ora_14156516.trc
- -rw-r----- 1 oracle oinstall 0 Feb 21 21:15 prod1_ora_41746602.trc
- -rw-r----- 1 oracle oinstall 0 Feb 21 14:15 prod1_ora_62718068.trc
- -rw-r----- 1 oracle oinstall 0 Feb 21 13:45 prod1_ora_41746596.trc
- -rw-r----- 1 oracle oinstall 0 Feb 21 06:00 prod1_ora_23265526.trc
- -rw-r----- 1 oracle oinstall 0 Feb 21 02:00 prod1_m000_42139772.trc
- -rw-r----- 1 oracle oinstall 0 Feb 21 01:02 prod1_ora_41746568.trc
- -rw-r----- 1 oracle oinstall 0 Feb 21 01:02 prod1_ora_41746566.trc
- -rw-r----- 1 oracle oinstall 0 Feb 20 22:00 prod1_j000_52167106.trc
- -rw-r----- 1 oracle oinstall 0 Feb 20 21:33 prod1_cjq0_65273882.trc
- -rw-r----- 1 oracle oinstall 0 Feb 20 17:26 prod1_ora_23789932.trc
- -rw-r----- 1 oracle oinstall 0 Feb 20 06:00 prod1_ora_59900312.trc
- -rw-r----- 1 oracle oinstall 0 Feb 20 02:00 prod1_m000_30670960.trc
- -rw-r----- 1 oracle oinstall 0 Feb 19 20:45 prod1_ora_41746644.trc
- -rw-r----- 1 oracle oinstall 0 Feb 19 13:15 prod1_ora_16908716.trc
- -rw-r----- 1 oracle oinstall 0 Feb 19 06:00 prod1_ora_35455178.trc
- -rw-r----- 1 oracle oinstall 0 Feb 19 06:00 prod1_j002_17957076.trc
- -rw-r----- 1 oracle oinstall 0 Feb 19 05:32 prod1_cjq0_42926484.trc
- -rw-r----- 1 oracle oinstall 0 Feb 19 02:00 prod1_m000_44826986.trc
- -rw-r----- 1 oracle oinstall 0 Feb 18 07:15 prod1_ora_15532524.trc
- -rw-r----- 1 oracle oinstall 0 Feb 18 06:00 prod1_ora_45678834.trc
- -rw-r----- 1 oracle oinstall 0 Feb 18 06:00 prod1_j000_44761248.trc
- -rw-r----- 1 oracle oinstall 0 Feb 18 05:31 prod1_cjq0_28574310.trc
- -rw-r----- 1 oracle oinstall 0 Feb 18 02:00 prod1_m000_32834288.trc
- -rw-r----- 1 oracle oinstall 0 Feb 18 00:46 prod1_m000_5440142.trc
- -rw-r----- 1 oracle oinstall 0 Feb 17 22:00 prod1_j000_35192862.trc
- -rw-r----- 1 oracle oinstall 0 Feb 17 21:31 prod1_cjq0_54329634.trc
- -rw-r----- 1 oracle oinstall 0 Feb 17 10:43 prod1_ora_25559494.trc
- -rw-r----- 1 oracle oinstall 0 Feb 17 06:00 prod1_ora_19202564.trc
- -rw-r----- 1 oracle oinstall 0 Feb 17 02:00 prod1_m000_39846172.trc
- -rw-r----- 1 oracle oinstall 0 Feb 17 00:00 prod1_ora_34734696.trc
- -rw-r----- 1 oracle oinstall 0 Feb 16 22:00 prod1_j000_63832190.trc
- -rw-r----- 1 oracle oinstall 0 Feb 16 21:30 prod1_cjq0_37683406.trc
- -rw-r----- 1 oracle oinstall 0 Feb 16 09:46 prod1_ora_44761730.trc
- -rw-r----- 1 oracle oinstall 0 Feb 16 06:00 prod1_ora_53805256.trc
- -rw-r----- 1 oracle oinstall 0 Feb 16 05:15 prod1_ora_3277280.trc
- -rw-r----- 1 oracle oinstall 0 Feb 16 02:00 prod1_m000_52167080.trc
- -rw-r----- 1 oracle oinstall 0 Feb 15 22:00 prod1_j000_47513796.trc
- -rw-r----- 1 oracle oinstall 0 Feb 15 21:34 prod1_cjq0_6750770.trc
- -rw-r----- 1 oracle oinstall 0 Feb 15 21:15 prod1_ora_48497002.trc
- -rw-r----- 1 oracle oinstall 0 Feb 15 08:41 prod1_ora_24642062.trc
- -rw-r----- 1 oracle oinstall 0 Feb 15 07:15 prod1_ora_62718098.trc
- -rw-r----- 1 oracle oinstall 0 Feb 15 06:00 prod1_ora_45809788.trc
- -rw-r----- 1 oracle oinstall 0 Feb 15 02:00 prod1_m000_37486634.trc
- -rw-r----- 1 oracle oinstall 0 Feb 14 22:00 prod1_j000_37552224.trc
- -rw-r----- 1 oracle oinstall 0 Feb 14 21:33 prod1_cjq0_21954910.trc
- -rw-r----- 1 oracle oinstall 0 Feb 14 18:15 prod1_ora_45089500.trc
- -rw-r----- 1 oracle oinstall 0 Feb 14 17:19 prod1_ora_38797454.trc
- -rw-r----- 1 oracle oinstall 0 Feb 14 16:15 prod1_ora_45089388.trc
- -rw-r----- 1 oracle oinstall 881 Feb 14 06:00 prod1_ora_38404226.trc
- -rw-r----- 1 oracle oinstall 75 Feb 14 06:00 prod1_ora_38404226.trm
- -rw-r----- 1 oracle oinstall 1070 Feb 14 02:16 prod1_ora_22020104.trc
- -rw-r----- 1 oracle oinstall 82 Feb 14 02:16 prod1_ora_22020104.trm
- -rw-r----- 1 oracle oinstall 1499 Feb 14 02:15 prod1_ora_17957032.trc
- -rw-r----- 1 oracle oinstall 111 Feb 14 02:15 prod1_ora_17957032.trm
- -rw-r----- 1 oracle oinstall 1557 Feb 14 02:15 prod1_ora_17957030.trc
- -rw-r----- 1 oracle oinstall 136 Feb 14 02:15 prod1_ora_17957030.trm
- -rw-r----- 1 oracle oinstall 749 Feb 14 02:00 prod1_m000_7995658.trc
- -rw-r----- 1 oracle oinstall 63 Feb 14 02:00 prod1_m000_7995658.trm
- -rw-r--r-- 1 oracle oinstall 3223 Apr 10 2015 free.lis
- -rw-r--r-- 1 root d_prod 219043840 Mar 26 2015 prod_tracefiles_20150326.tar
- -rw-r--r-- 1 oracle oinstall 3297280 Jun 26 2013 alert_prod1.tar_20130626
- ./prod1/cdump:
- total 0
- ./prod1/lck:
- total 0
- -rw-r----- 1 oracle oinstall 0 Feb 10 2012 AM_117463809_1252689677.lck
- -rw-r----- 1 oracle oinstall 0 Feb 10 2012 AM_1477507928_3848095858.lck
- -rw-r----- 1 oracle oinstall 0 Feb 10 2012 AM_1479503217_1058909787.lck
- -rw-r----- 1 oracle oinstall 0 Feb 10 2012 AM_1506961005_3222638125.lck
- -rw-r----- 1 oracle oinstall 0 Feb 10 2012 AM_1521063874_363843526.lck
- -rw-r----- 1 oracle oinstall 0 Feb 10 2012 AM_1618_3044626670.lck
- -rw-r----- 1 oracle oinstall 0 Feb 10 2012 AM_1737460353_941080040.lck
- -rw-r----- 1 oracle oinstall 0 Feb 10 2012 AM_1762783_4031814035.lck
- -rw-r----- 1 oracle oinstall 0 Feb 10 2012 AM_1762885_3826749810.lck
- -rw-r----- 1 oracle oinstall 0 Feb 10 2012 AM_1919660852_3200803573.lck
- -rw-r----- 1 oracle oinstall 0 Feb 10 2012 AM_1919660852_3403801080.lck
- -rw-r----- 1 oracle oinstall 0 Feb 10 2012 AM_1919660854_3704060414.lck
- -rw-r----- 1 oracle oinstall 0 Feb 10 2012 AM_2020575435_1685934094.lck
- -rw-r----- 1 oracle oinstall 0 Feb 10 2012 AM_2087871662_4269132395.lck
- -rw-r----- 1 oracle oinstall 0 Feb 10 2012 AM_2087871759_1054152112.lck
- -rw-r----- 1 oracle oinstall 0 Feb 10 2012 AM_2099277876_66242055.lck
- -rw-r----- 1 oracle oinstall 0 Feb 10 2012 AM_2485072945_164397129.lck
- -rw-r----- 1 oracle oinstall 0 Feb 10 2012 AM_2569157681_2857696958.lck
- -rw-r----- 1 oracle oinstall 0 Feb 10 2012 AM_2876149918_855262320.lck
- -rw-r----- 1 oracle oinstall 0 Feb 10 2012 AM_2904361128_3186785985.lck
- -rw-r----- 1 oracle oinstall 0 Feb 10 2012 AM_3063883707_458774509.lck
- -rw-r----- 1 oracle oinstall 0 Feb 10 2012 AM_3172236303_1050790107.lck
- -rw-r----- 1 oracle oinstall 0 Feb 10 2012 AM_3216766131_2188903675.lck
- -rw-r----- 1 oracle oinstall 0 Feb 10 2012 AM_3218196182_2691928421.lck
- -rw-r----- 1 oracle oinstall 0 Feb 10 2012 AM_3219651335_1369860572.lck
- -rw-r----- 1 oracle oinstall 0 Feb 10 2012 AM_4123867812_464947195.lck
- -rw-r----- 1 oracle oinstall 0 Feb 10 2012 AM_423666793_1876373544.lck
- -rw-r----- 1 oracle oinstall 0 Feb 10 2012 AM_4294531585_3603614071.lck
- -rw-r----- 1 oracle oinstall 0 Feb 10 2012 AM_53417_1688101061.lck
- -rw-r----- 1 oracle oinstall 0 Feb 10 2012 AM_53417_2985279723.lck
- -rw-r----- 1 oracle oinstall 0 Feb 10 2012 AM_53419_3606358678.lck
- -rw-r----- 1 oracle oinstall 0 Feb 10 2012 AM_994187642_3287667720.lck
- -rw-r----- 1 oracle oinstall 0 Feb 10 2012 AM_1096102193_3488045378.lck
- -rw-r----- 1 oracle oinstall 0 Feb 10 2012 AM_1096102262_3454819329.lck
- -rw-r----- 1 oracle oinstall 0 Feb 10 2012 AM_1744845641_3861997533.lck
- -rw-r----- 1 oracle oinstall 0 Feb 10 2012 AM_3216668543_3129272988.lck
- ./prod1/sweep:
- total 0
- ./prod1/incident:
- total 0
- drwxr-xr-x 2 oracle oinstall 256 Aug 05 2016 incdir_240167
- ./prod1/incident/incdir_240167:
- total 0
- -rw-r----- 1 oracle oinstall 430850 Aug 05 2016 prod1_ora_18023090_i240167.trc
- -rw-r----- 1 oracle oinstall 18034 Aug 05 2016 prod1_ora_18023090_i240167.trm
- ./prod1/stage:
- total 0
- -rw-r----- 1 oracle oinstall 2598 Aug 05 2016 stg_240167.stg
- ./prod1/alert:
- total 0
- -rw-r----- 1 oracle oinstall 4665344 Mar 16 03:15 log.xml
- -rw-r----- 1 oracle oinstall 10485863 May 10 2016 log_1.xml
- ./prod1/ir:
- total 0
- -rw-r----- 1 oracle oinstall 13 Dec 27 2013 recovery_history.ir
- ./prod1/metadata:
- total 0
- -rw-r----- 1 oracle oinstall 65536 Mar 16 09:58 INC_METER_CONFIG.ams
- -rw-r----- 1 oracle oinstall 65536 Mar 16 09:58 INC_METER_INFO.ams
- -rw-r----- 1 oracle oinstall 65536 Mar 16 09:58 INC_METER_SUMMARY.ams
- -rw-r----- 1 oracle oinstall 65536 Mar 16 01:07 ADR_CONTROL.ams
- -rw-r----- 1 oracle oinstall 65536 Mar 16 01:07 HM_FINDING.ams
- -rw-r----- 1 oracle oinstall 65536 Mar 16 01:07 HM_RECOMMENDATION.ams
- -rw-r----- 1 oracle oinstall 884736 Mar 16 01:07 HM_RUN.ams
- -rw-r----- 1 oracle oinstall 475136 Mar 16 01:07 INCIDENT.ams
- -rw-r----- 1 oracle oinstall 475136 Aug 05 2016 INCCKEY.ams
- -rw-r----- 1 oracle oinstall 65536 Aug 05 2016 INCIDENT_FILE.ams
- -rw-r----- 1 oracle oinstall 65536 Aug 05 2016 PROBLEM.ams
- -rw-r----- 1 oracle oinstall 65536 Sep 21 2015 HM_INFO.ams
- -rw-r----- 1 oracle oinstall 65536 Jan 02 2015 HM_MESSAGE.ams
- -rw-r----- 1 oracle oinstall 65536 Feb 10 2012 AMS_XACTION.ams
- -rw-r----- 1 oracle oinstall 65536 Feb 10 2012 DDE_USER_ACTION.ams
- -rw-r----- 1 oracle oinstall 65536 Feb 10 2012 DDE_USER_ACTION_DEF.ams
- -rw-r----- 1 oracle oinstall 65536 Feb 10 2012 DDE_USER_ACTION_PARAMETER.ams
- -rw-r----- 1 oracle oinstall 65536 Feb 10 2012 DDE_USER_ACTION_PARAMETER_DEF.ams
- -rw-r----- 1 oracle oinstall 65536 Feb 10 2012 DDE_USER_INCIDENT_ACTION_MAP.ams
- -rw-r----- 1 oracle oinstall 65536 Feb 10 2012 DDE_USER_INCIDENT_TYPE.ams
- -rw-r----- 1 oracle oinstall 65536 Feb 10 2012 EM_DIAG_JOB.ams
- -rw-r----- 1 oracle oinstall 65536 Feb 10 2012 EM_TARGET_INFO.ams
- -rw-r----- 1 oracle oinstall 65536 Feb 10 2012 EM_USER_ACTIVITY.ams
- -rw-r----- 1 oracle oinstall 65536 Feb 10 2012 HM_FDG_SET.ams
- -rw-r----- 1 oracle oinstall 65536 Feb 10 2012 INC_METER_PK_IMPTS.ams
- -rw-r----- 1 oracle oinstall 65536 Feb 10 2012 IPS_CONFIGURATION.ams
- -rw-r----- 1 oracle oinstall 65536 Feb 10 2012 IPS_FILE_COPY_LOG.ams
- -rw-r----- 1 oracle oinstall 65536 Feb 10 2012 IPS_FILE_METADATA.ams
- -rw-r----- 1 oracle oinstall 65536 Feb 10 2012 IPS_PACKAGE.ams
- -rw-r----- 1 oracle oinstall 65536 Feb 10 2012 IPS_PACKAGE_FILE.ams
- -rw-r----- 1 oracle oinstall 65536 Feb 10 2012 IPS_PACKAGE_HISTORY.ams
- -rw-r----- 1 oracle oinstall 65536 Feb 10 2012 IPS_PACKAGE_INCIDENT.ams
- -rw-r----- 1 oracle oinstall 65536 Feb 10 2012 IPS_REMOTE_PACKAGE.ams
- -rw-r----- 1 oracle oinstall 65536 Feb 10 2012 SWEEPERR.ams
- -rw-r----- 1 oracle oinstall 40960 Feb 10 2012 ADR_INTERNAL.mif
- -rw-r----- 1 oracle oinstall 65536 Feb 10 2012 ADR_INVALIDATION.ams
- -rw-r----- 1 oracle oinstall 65536 Feb 10 2012 INC_METER_IMPT_DEF.ams
- ./prod1/hm:
- total 0
- ./prod1/incpkg:
- total 0
- oracle@srvlabaix:/u02/diag/rdbms/prod>
- $ pwd
- /u02/diag/rdbms/prod
- oracle@srvlabaix:/u02/diag/rdbms/prod>
- $ dior
- ksh: dior: not found.
- oracle@srvlabaix:/u02/diag/rdbms/prod>
- $ dir
- ksh: dir: not found.
- oracle@srvlabaix:/u02/diag/rdbms/prod>
- $ ls\
- >
- i_1.mif prod1
- oracle@srvlabaix:/u02/diag/rdbms/prod>
- $ cd prod1
- oracle@srvlabaix:/u02/diag/rdbms/prod/prod1>
- $ ls
- alert cdump hm incident incpkg ir lck metadata stage sweep trace
- oracle@srvlabaix:/u02/diag/rdbms/prod/prod1>
- $ cd trace
- oracle@srvlabaix:/u02/diag/rdbms/prod/prod1/trace>
- $ ls
- alert_prod1.log prod1_m000_30670960.trc prod1_ora_25559522.trc prod1_ora_41746608.trc
- alert_prod1.tar_20130626 prod1_m000_32834288.trc prod1_ora_25756198.trc prod1_ora_41746644.trc
- free.lis prod1_m000_33161532.trc prod1_ora_25756208.trc prod1_ora_41746682.trc
- prod1_cjq0_13042192.trc prod1_m000_33686264.trc prod1_ora_25756246.trc prod1_ora_42205526.trc
- prod1_cjq0_13304084.trc prod1_m000_33686264.trm prod1_ora_25756358.trc prod1_ora_42533212.trc
- prod1_cjq0_16974300.trc prod1_m000_34669192.trc prod1_ora_25756388.trc prod1_ora_42533226.trc
- prod1_cjq0_21954910.trc prod1_m000_36962714.trc prod1_ora_26870384.trc prod1_ora_42533312.trc
- prod1_cjq0_23462590.trc prod1_m000_37486634.trc prod1_ora_28312056.trc prod1_ora_44761730.trc
- prod1_cjq0_24969506.trc prod1_m000_39846172.trc prod1_ora_28508834.trc prod1_ora_45089382.trc
- prod1_cjq0_2687680.trc prod1_m000_41746618.trc prod1_ora_28508834.trm prod1_ora_45089388.trc
- prod1_cjq0_28574310.trc prod1_m000_42139772.trc prod1_ora_28508850.trc prod1_ora_45089500.trc
- prod1_cjq0_32703080.trc prod1_m000_42270926.trc prod1_ora_28508850.trm prod1_ora_45416640.trc
- prod1_cjq0_34734326.trc prod1_m000_4260192.trc prod1_ora_28574340.trc prod1_ora_45678834.trc
- prod1_cjq0_3539676.trc prod1_m000_42992328.trc prod1_ora_29295322.trc prod1_ora_45809788.trc
- prod1_cjq0_37618312.trc prod1_m000_42992328.trm prod1_ora_30736732.trc prod1_ora_46596160.trc
- prod1_cjq0_37618422.trc prod1_m000_44367894.trc prod1_ora_30736760.trc prod1_ora_46596160.trm
- prod1_cjq0_37683406.trc prod1_m000_44761172.trc prod1_ora_30736790.trc prod1_ora_47251500.trc
- prod1_cjq0_3801402.trc prod1_m000_44826986.trc prod1_ora_30736802.trc prod1_ora_47251600.trc
- prod1_cjq0_3801558.trc prod1_m000_52167080.trc prod1_ora_30933270.trc prod1_ora_47251638.trc
- prod1_cjq0_42926484.trc prod1_m000_5440142.trc prod1_ora_31129996.trc prod1_ora_48300032.trc
- prod1_cjq0_44565164.trc prod1_m000_58982896.trc prod1_ora_31195140.trc prod1_ora_48497002.trc
- prod1_cjq0_44565224.trc prod1_m000_62587180.trc prod1_ora_31195178.trc prod1_ora_49021218.trc
- prod1_cjq0_45547660.trc prod1_m000_63832268.trc prod1_ora_31195208.trc prod1_ora_49021424.trc
- prod1_cjq0_51446244.trc prod1_m000_7995658.trc prod1_ora_31195258.trc prod1_ora_50069900.trc
- prod1_cjq0_54329634.trc prod1_m000_7995658.trm prod1_ora_3277142.trc prod1_ora_53805256.trc
- prod1_cjq0_54853710.trc prod1_m000_7996030.trc prod1_ora_3277238.trc prod1_ora_54264044.trc
- prod1_cjq0_57409898.trc prod1_m000_7996142.trc prod1_ora_3277244.trc prod1_ora_54329618.trc
- prod1_cjq0_60096560.trc prod1_m000_8651502.trc prod1_ora_3277280.trc prod1_ora_56754294.trc
- prod1_cjq0_6029634.trc prod1_ora_10682710.trc prod1_ora_34538120.trc prod1_ora_5702248.trc
- prod1_cjq0_6029646.trc prod1_ora_10683126.trc prod1_ora_34734696.trc prod1_ora_57278878.trc
- prod1_cjq0_63504780.trc prod1_ora_10683130.trc prod1_ora_3539476.trc prod1_ora_57344272.trc
- prod1_cjq0_65273882.trc prod1_ora_10813814.trc prod1_ora_35455178.trc prod1_ora_57344286.trc
- prod1_cjq0_6750770.trc prod1_ora_13042396.trc prod1_ora_35717270.trc prod1_ora_57803208.trc
- prod1_j000_11272944.trc prod1_ora_14156516.trc prod1_ora_35717270.trm prod1_ora_59179372.trc
- prod1_j000_12649116.trc prod1_ora_15139452.trc prod1_ora_35979618.trc prod1_ora_59179372.trm
- prod1_j000_15401624.trc prod1_ora_15139538.trc prod1_ora_36503858.trc prod1_ora_59179398.trc
- prod1_j000_16908680.trc prod1_ora_15204366.trc prod1_ora_36503864.trc prod1_ora_59572334.trc
- prod1_j000_25297380.trc prod1_ora_15204422.trc prod1_ora_36503932.trc prod1_ora_5964218.trc
- prod1_j000_27459832.trc prod1_ora_15204532.trc prod1_ora_36503936.trc prod1_ora_5964266.trc
- prod1_j000_28508482.trc prod1_ora_15401544.trc prod1_ora_36503946.trc prod1_ora_5964278.trc
- prod1_j000_31195294.trc prod1_ora_15532454.trc prod1_ora_36831632.trc prod1_ora_59900312.trc
- prod1_j000_34603410.trc prod1_ora_15532524.trc prod1_ora_37028206.trc prod1_ora_59965606.trc
- prod1_j000_35192862.trc prod1_ora_15859726.trc prod1_ora_37028206.trm prod1_ora_60293130.trc
- prod1_j000_35389584.trc prod1_ora_16515414.trc prod1_ora_37421640.trc prod1_ora_62718068.trc
- prod1_j000_35979774.trc prod1_ora_16515534.trc prod1_ora_37421652.trc prod1_ora_62718086.trc
- prod1_j000_36700602.trc prod1_ora_16908716.trc prod1_ora_37421654.trc prod1_ora_62718098.trc
- prod1_j000_37486608.trc prod1_ora_16974080.trc prod1_ora_37421684.trc prod1_ora_62718180.trc
- prod1_j000_37552224.trc prod1_ora_17105186.trc prod1_ora_37421732.trc prod1_ora_62783562.trc
- prod1_j000_37683400.trc prod1_ora_17957030.trc prod1_ora_37421778.trc prod1_ora_62783562.trm
- prod1_j000_42401830.trc prod1_ora_17957030.trm prod1_ora_37487316.trc prod1_ora_6292122.trc
- prod1_j000_42664300.trc prod1_ora_17957032.trc prod1_ora_37552280.trc prod1_ora_6292122.trm
- prod1_j000_44761248.trc prod1_ora_17957032.trm prod1_ora_37552358.trc prod1_ora_6292124.trc
- prod1_j000_44892668.trc prod1_ora_18612406.trc prod1_ora_37748750.trc prod1_ora_6292124.trm
- prod1_j000_45810134.trc prod1_ora_18940470.trc prod1_ora_38273160.trc prod1_ora_63504860.trc
- prod1_j000_47513796.trc prod1_ora_19005500.trc prod1_ora_38404202.trc prod1_ora_63504878.trc
- prod1_j000_49283520.trc prod1_ora_19005506.trc prod1_ora_38404226.trc prod1_ora_64290834.trc
- prod1_j000_52167106.trc prod1_ora_19202564.trc prod1_ora_38404226.trm prod1_ora_64290878.trc
- prod1_j000_54788218.trc prod1_ora_19202788.trc prod1_ora_38535180.trc prod1_ora_64290936.trc
- prod1_j000_57213096.trc prod1_ora_2097880.trc prod1_ora_38535186.trc prod1_ora_64290968.trc
- prod1_j000_60424474.trc prod1_ora_21627462.trc prod1_ora_38535278.trc prod1_ora_65274066.trc
- prod1_j000_62718130.trc prod1_ora_22020104.trc prod1_ora_38535328.trc prod1_ora_6750596.trc
- prod1_j000_63832190.trc prod1_ora_22020104.trm prod1_ora_38797454.trc prod1_ora_6881540.trc
- prod1_j002_17957076.trc prod1_ora_22413936.trc prod1_ora_39125396.trc prod1_ora_7864752.trc
- prod1_m000_10551726.trc prod1_ora_23265526.trc prod1_ora_39256084.trc prod1_ora_8716712.trc
- prod1_m000_11469166.trc prod1_ora_23789932.trc prod1_ora_39977264.trc prod1_ora_8847624.trc
- prod1_m000_12059168.trc prod1_ora_23790282.trc prod1_ora_39977404.trc prod1_ora_8847644.trc
- prod1_m000_12059168.trm prod1_ora_23790282.trm prod1_ora_41288414.trc prod1_ora_8847698.trc
- prod1_m000_131678.trc prod1_ora_24117544.trc prod1_ora_41288414.trm prod1_ora_8847750.trc
- prod1_m000_19923284.trc prod1_ora_24379522.trc prod1_ora_41746446.trc prod1_ora_8847782.trc
- prod1_m000_20709626.trc prod1_ora_24642062.trc prod1_ora_41746532.trc prod1_ora_8847850.trc
- prod1_m000_2228702.trc prod1_ora_25100610.trc prod1_ora_41746566.trc prod1_ora_9044594.trc
- prod1_m000_22544586.trc prod1_ora_25100614.trc prod1_ora_41746568.trc prod1_ora_9044696.trc
- prod1_m000_23003554.trc prod1_ora_25297312.trc prod1_ora_41746596.trc prod_tracefiles_20150326.tar
- prod1_m000_25625148.trc prod1_ora_25559494.trc prod1_ora_41746602.trc
- oracle@srvlabaix:/u02/diag/rdbms/prod/prod1/trace>
- $ rm prod_tracefiles_20150326.tar
- rm: Remove prod_tracefiles_20150326.tar? y
- oracle@srvlabaix:/u02/diag/rdbms/prod/prod1/trace>
- $ df -P
- Filesystem 512-blocks Used Available Capacity Mounted on
- /dev/hd4 2621440 1944096 677344 75% /
- /dev/hd2 8912896 5775448 3137448 65% /usr
- /dev/hd9var 4194304 3791048 403256 91% /var
- /dev/hd3 8388608 1988496 6400112 24% /tmp
- /dev/hd1 2097152 203296 1893856 10% /home
- /proc - - - - /proc
- /dev/hd10opt 2097152 419328 1677824 20% /opt
- /dev/oracle01lv 26607616 11645104 14962512 44% /u01
- /dev/oracle02lv 12288000 11859224 428776 97% /u02
- /dev/cerner01lv 524288 160712 363576 31% /cerner
- /dev/cerner02lv 2097152 1040 2096112 1% /cerner/w_standard
- /dev/cerner03lv 1048576 804456 244120 77% /cerner/d_admin
- /dev/cerner06lv 1048576 826680 221896 79% /cerner/b_common
- /dev/mq01lv 524288 36464 487824 7% /var/mqm
- /dev/mq02lv 10485760 8196280 2289480 79% /var/mqm/log
- /dev/cerner09lv 6291456 3201560 3089896 51% /cerner/d_prod
- /dev/cerner10lv 4194304 2038264 2156040 49% /cerner/d_prod/ccldir
- /dev/cerner11lv 10485760 7819264 2666496 75% /cerner/d_prod/ccluserdir
- /dev/cerner12lv 720896 28304 692592 4% /cerner/d_prod/print
- /dev/cerner13lv 1048576 901208 147368 86% /cerner/d_prod/log
- /dev/cerner14lv 16777216 13223456 3553760 79% /cerner/w_standard/prod_wh
- /dev/cerner15lv 23068672 2641808 20426864 12% /cerner/d_prod/ocd
- /dev/cernernmonlv 1572864 51464 1521400 4% /cerner/nmon
- /dev/prodarchlv 83492864 13744 83479120 1% /u02/oracle/admin/mock/arch
- /dev/backuplv 905641984 658287760 247354224 73% /backup
- /dev/atglv 20971520 7659848 13311672 37% /atg
- /dev/stagelv 52428800 45878040 6550760 88% /stage
- /dev/oracle04lv 33488896 33058848 430048 99% /u01/oracle/product/11.1.0.7/asm
- /dev/oracle03lv 33488896 30726304 2762592 92% /u01/oracle/product/11.1.0.7/db
- /dev/cerner17lv 4194304 2036152 2158152 49% /cerner/d_prod/ccldir2
- /dev/cerner18lv 4194304 354568 3839736 9% /cerner/d_prod/temp
- /dev/cerner19lv 10485760 2264 10483496 1% /cerner/d_prod/cclscratch
- /dev/livedump 524288 736 523552 1% /var/adm/ras/livedump
- /dev/cerner2lv01 6291456 125912 6165544 3% /cerner/d_cert
- /dev/cerner2lv02 4194304 1334128 2860176 32% /cerner/d_cert/ccldir
- /dev/cerner2lv03 4194304 1335952 2858352 32% /cerner/d_cert/ccldir2
- /dev/cerner2lv04 10485760 1120120 9365640 11% /cerner/d_cert/ccluserdir
- /dev/cerner2lv05 524288 128576 395712 25% /cerner/d_cert/log
- /dev/cerner2lv06 4194304 7312 4186992 1% /cerner/d_cert/temp
- /dev/cerner2lv07 10485760 1096712 9389048 11% /cerner/d_cert/ocd
- /dev/cerner2lv11 10485760 2264 10483496 1% /cerner/d_cert/cclscratch
- /dev/cerner2lv08 14680064 14234392 445672 97% /cerner/w_standard/cert_wh
- oracle@srvlabaix:/u02/diag/rdbms/prod/prod1/trace>
- $
- oracle@srvlabaix:/u02/diag/rdbms/prod/prod1/trace>
- $
- oracle@srvlabaix:/u02/diag/rdbms/prod/prod1/trace>
- $ id
- uid=209(oracle) gid=209(oinstall) groups=1(staff),208(dba)
- oracle@srvlabaix:/u02/diag/rdbms/prod/prod1/trace>
- $ sqlplus '/as sysdba'
- SQL*Plus: Release 11.1.0.7.0 - Production on Thu Mar 16 10:50:19 2017
- Copyright (c) 1982, 2008, Oracle. All rights reserved.
- Connected to:
- Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
- SQL> alter user cdba identified by cdba account unlock ;
- User altered.
- SQL> exit
- Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
- oracle@srvlabaix:/u02/diag/rdbms/prod/prod1/trace>
- $ sqlplus cdba/cdba@admin1
- SQL*Plus: Release 11.1.0.7.0 - Production on Thu Mar 16 10:52:41 2017
- Copyright (c) 1982, 2008, Oracle. All rights reserved.
- Connected to:
- Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
- SQL> exit
- Rec: 0, 0 Row: 0 Qual: 0 Sort: 0Release 11.1.0.7.0 - 64bit Production
- oracle@srvlabaix:/u02/diag/rdbms/prod/prod1/trace>
- $ exit
- root:common@(srvlabaix):/:
- # id
- uid=0(root) gid=0(system) groups=2(bin),3(sys),7(security),8(cron),10(audit),11(lp),210(d_prod),14(mqm),201(regadmin)
- root:common@(srvlabaix):/:
- # exit
- root:cert@(srvlabaix):/:
- # ccl
- cclisam(ver:6 mode:0 multiuser:1, largefile:0)
- RDBEXPAND=1, RDBEXPANDGTTD=0
- Including ccl file login_default.ccl
- Connecting to RDBMS as V500* user
- Qual: 0 Len: 0
- Qual: 1 Len: 0
- Connect to RDBMS(Usr:V500 Lnk:@cert1 Pos:0 Con:1 Han:7259580 Opt:8 Lib:OCI9+ Ver:11.10 Sys:AIX End:1 Acc:1 Try:1 Ela:0.00 )
- H
- ........10........20........30........40........50........60........70........80........90.......100.......110.......120......
- DATABASE_STATUS |STARTUP_TIME |INSTANCE_NAME |INSTANCE_ROLE |HOST_NAME
- ACTIVE |08-SEP-2016 18:33:50 |cert1 |PRIMARY_INSTANCE |srvlabaix
- Rows: 1 Cols: 152 Multi Down
- EXIT VIEW FIND PRINT HELP SCROLL BREAK DIRECTION WIDTH MARGIN
- Qual: 1 Len: 152
- *** Begin cclstartup script ***
- Version: Millennium 2010.02: JUL2010
- 37
- Declaring secrtl_def
- V500 UserName
- 170316:105258 CCLSTARTUP Cost 0.01 Cpu 0.01 Ela 0.00 Bio 0 Dio 0 O0M0R0 P1R38 S2,2
- *** End cclstartup script ***
- (Hit PF3 or RETURN to skip security login; this will disable Uar functions)
- DISCERN EXPLORER (CCL Rev:8.7.2 Hnam:01OCT2011)
- %Banner %Display %Edit %Help %Include %Journ %Ledit %Out %Run %Show %Term %Ver
- BROWSE CALL CASE DECLARE DEFINE DELETE EXECUTE FOR FREE GENERATE GOTO GRANT IF
- INSERT MERGE RANGE RDB RECORD RESET REVOKE SELECT SET SUBROUTINE UPDATE WHILE
- CCLMENU CCLUSER DATABASE DDLRECORD EKMODULE GENLINK PROGRAM RECORD TABLE VIEW
- CclAssist CclCost CclGlos CclNews CclOraCons CclOraDef CclOraError CclOraIndex
- CclOraParam CclOraPlan CclOraSession CclOraVer CclProgSearch CclProt CclQuery
- CclRefLog CclReg CclServer CclSize CclSqlArea Cclsrv CclUaf RtlView Tableall
- Sys(AIX AIX)Utc(0)Isam(Disam 6)ORACLE(OCI9+ O8 V11.10 AIX)Grp(00) ROOT
- SecLogin(off) DMS(off) Ccledit(CCLUSERDIR) Ccldir(2W_63)
- 1)
- 2)select * from dm_environment go
- Rec: 0, 0 Row: 0 Qual: 0 Sort: 0
- H
- ........10........20........30........40........50........60........70........80........90.......100.......110.......120......
- ENVIRONMENT_ID DESCRIPTION ENVIRONMENT_NAME DATABASE_NAME TOTAL_DATABASE_
- 8602603.00 BUILD BUILD1
- 8603083.00 AIX 16M PP 16GB DB OLD <8603083> cert 1600
- 8605280.00 CERT OLD <8605280> cert 1600
- 11290396.00 DB MIGRATION DBMIG PROD
- 8607923.00 AIX 16M PP 16GB DB MOCK mock 1600
- 11290370.00 TEMP TEMP CERT
- 8603043.00 AIX 16M PP 16GB DB PROD PROD 1600
- 11290383.00 EXP-IMP MOCK DB OLD <11290383> CERT
- 11547620.00 EXP-IMP MOCK DB CERT CERT
- Rows: 9 Cols: 1064 Multi Down
- EXIT VIEW FIND PRINT HELP SCROLL BREAK DIRECTION WIDTH MARGIN
- 0)DM_ENVIRONMENT:DM_ENVIRONMENT(N#0#0)(Rng:0)Len<868>Dim<1>KEY1<0>Rec<9>
- Rec: 9, 10 Row: 9 Qual: 9 Len: 1065
- Command executed!
- 1)dep_dbimport_wrapper go
- 0)DM_INFO:DM_INFO(N#0#0)(Rng:0)Len<4417>Dim<1>KEY1<0>Rec<0>
- Rec: 0, 1 Row: 0 Qual: 0 Len: 12
- 0)DM_INFO:R(N#0#0)(Rng:0)Len<4417>Dim<1>KEY1<0>Rec<1>
- Rec: 1, 2 Row: 1 Qual: 1 Len: 19
- 0)DEP_ENV_ID_RELTN:EIR(N#0#0)(Rng:0)Len<34>Dim<1>KEY1<0>Rec<1>
- Rec: 1, 2 Row: 1 Qual: 1 Len: 19
- 0)DPROTECT:D(N#0#0)(Rng:0)Len<256>Dim<1>KEY1<38>Rec<1>
- Rec: 1, 2 Row: 1 Qual: 1 Len: 12
- Rec: 0, 0 Row: 0 Qual: 0 Sort: 0
- 0)RTL2T:T(N#0#0)(Rng:0)Len<2000>Dim<1>KEY1<0>Rec<1>
- Rec: 4, 5 Row: 4 Qual: 1 Len: 2011
- Rec: 1, 2 Row: 1 Qual: 1 Len: 2011
- Processing rows:1 to:1000
- Here is the csv file name: cer_install:dep_category.csv
- -----
- Rec: 4, 5 Row: 4 Qual: 1 Len: 2011
- 0)RTL2T:T(N#0#0)(Rng:0)Len<2000>Dim<1>KEY1<0>Rec<4>
- Rec: 4, 5 Row: 4 Qual: 1 Len: 2011
- 0)DUMMYT:D1(N#0#0)(Rng:1)Len<32>Dim<3>KEY1<0>Rec<3>
- 1)DEP_CATEGORY:EMC(N#2#0)(Rng:0)Len<289>Dim<1>KEY1<0>Rec<3>
- Rec: 3, 7 Row: 6 Qual: 1 Len: 15
- 0)DUMMYT:D1(N#0#0)(Rng:1)Len<32>Dim<3>KEY1<0>Rec<3>
- 1)DEP_CATEGORY:EMC(N#2#0)(Rng:0)Len<289>Dim<1>KEY1<0>Rec<0>
- Rec: 3, 1 Row: 3 Qual: 0 Dup: 0 Err: 0
- 0)DUMMYT:D1(N#0#0)(Rng:1)Len<32>Dim<3>KEY1<0>Rec<3>
- 1)DEP_CATEGORY:EMC(N#2#0)(Rng:0)Len<289>Dim<1>KEY1<0>Rec<0>
- Rec: 3, 3 Row: 3 Qual: 3 Dup: 0 Err: 0
- 0)DEP_PROFILE_DEV_RELTN:DPDR(N#0#0)(Rng:0)Len<2401>Dim<1>KEY1<0>Rec<0>
- Rec: 0, 0 Row: 0 Qual: 0 Dup: 0 Err: 0
- 0)DEP_PROFILE_DEV_RELTN:DPDR(N#0#0)(Rng:0)Len<2401>Dim<1>KEY1<0>Rec<0>
- Rec: 0, 0 Row: 0 Qual: 0 Dup: 0 Err: 0
- 0)DEP_PROFILE_DEV_RELTN:DPDR(N#0#0)(Rng:0)Len<2401>Dim<1>KEY1<0>Rec<0>
- Rec: 0, 0 Row: 0 Qual: 0 Dup: 0 Err: 0
- 0)DEP_PROFILE_DEV_RELTN:DPDR(N#0#0)(Rng:0)Len<2401>Dim<1>KEY1<0>Rec<0>
- Rec: 0, 0 Row: 0 Qual: 0 Dup: 0 Err: 0
- 0)DEP_PROFILE_DEV_RELTN:DPDR(N#0#0)(Rng:1)Len<2401>Dim<1>KEY1<0>Rec<0>
- 1)DEP_PROFILE:DP(N#5#0)(Rng:0)Len<309>Dim<1>Row<0>
- Rec: 0, 0 Row: 0 Qual: 0 Sort: 0
- 0)RTL2T:T(N#0#0)(Rng:0)Len<2000>Dim<1>KEY1<0>Rec<1>
- 0)DUMMYT:D1(N#0#0)(Rng:1)Len<32>Dim<1>KEY1<0>Rec<1>
- Rec: 1, 2 Row: 1 Qual: 1 Len: 2011m<1>KEY1<0>Rec<0>
- Processing rows:1 to:1000
- Here is the csv file name: cer_install:dep_phase.csv 0 Err: 0
- -----
- 0)DPROTECT:D(N#0#0)(Rng:0)Len<256>Dim<1>KEY1<38>Rec<1>
- 0)RTL2T:T(N#0#0)(Rng:0)Len<2000>Dim<1>KEY1<0>Rec<26>
- Rec: 1, 2 Row: 1 Qual: 1 Len: 12
- Rec: 26, 27 Row: 26 Qual: 1 Len: 2011
- 0)RTL2T:T(N#0#0)(Rng:0)Len<2000>Dim<1>KEY1<0>Rec<26>
- 0)DUMMYT:D1(N#0#0)(Rng:1)Len<32>Dim<25>KEY1<0>Rec<25>
- 1)DEP_PHASE:EMC(N#2#0)(Rng:0)Len<556>Dim<1>KEY1<0>Rec<25>
- Numbers of rows to process:25
- Rec: 25, 51 Row: 50 Qual: 1 Len: 15
- 0)RTL2T:T(N#0#0)(Rng:0)Len<2000>Dim<1>KEY1<0>Rec<26>
- 0)DUMMYT:D1(N#0#0)(Rng:1)Len<32>Dim<25>KEY1<0>Rec<25>
- 1)DEP_PHASE:EMC(N#2#0)(Rng:0)Len<556>Dim<1>KEY1<0>Rec<0>
- Rec: 0, 0 Row: 0 Qual: 0 Sort: 0Err: 0
- 0)RTL2T:T(N#0#0)(Rng:0)Len<2000>Dim<1>KEY1<0>Rec<1>
- 0)DUMMYT:D1(N#0#0)(Rng:1)Len<32>Dim<25>KEY1<0>Rec<25>
- Rec: 1, 2 Row: 1 Qual: 1 Len: 2011<0>
- Processing rows:1 to:1000
- Here is the csv file name: cer_install:dep_role.csv 0 Err: 0
- -----
- 0)DPROTECT:D(N#0#0)(Rng:0)Len<256>Dim<1>KEY1<38>Rec<1>
- 0)RTL2T:T(N#0#0)(Rng:0)Len<2000>Dim<1>KEY1<0>Rec<17>
- Rec: 1, 2 Row: 1 Qual: 1 Len: 12
- Rec: 17, 18 Row: 17 Qual: 1 Len: 2011
- 0)RTL2T:T(N#0#0)(Rng:0)Len<2000>Dim<1>KEY1<0>Rec<17>
- 0)DUMMYT:D1(N#0#0)(Rng:1)Len<32>Dim<16>KEY1<0>Rec<16>
- 1)DEP_ROLE:EMC(N#2#0)(Rng:0)Len<546>Dim<1>KEY1<0>Rec<16>
- Numbers of rows to process:16
- Rec: 16, 33 Row: 32 Qual: 1 Len: 15
- 0)RTL2T:T(N#0#0)(Rng:0)Len<2000>Dim<1>KEY1<0>Rec<17>
- 0)DUMMYT:D1(N#0#0)(Rng:1)Len<32>Dim<16>KEY1<0>Rec<16>
- 1)DEP_ROLE:EMC(N#2#0)(Rng:0)Len<546>Dim<1>KEY1<0>Rec<0>
- Rec: 0, 0 Row: 0 Qual: 0 Sort: 0Err: 0
- 0)RTL2T:T(N#0#0)(Rng:0)Len<2000>Dim<1>KEY1<0>Rec<1>
- 0)DUMMYT:D1(N#0#0)(Rng:1)Len<32>Dim<16>KEY1<0>Rec<16>
- Rec: 1, 2 Row: 1 Qual: 1 Len: 20110>
- Processing rows:1 to:1000
- Here is the csv file name: cer_install:dep_role_param.csvErr: 0
- -----
- 0)DPROTECT:D(N#0#0)(Rng:0)Len<256>Dim<1>KEY1<38>Rec<1>
- 0)RTL2T:T(N#0#0)(Rng:0)Len<2000>Dim<1>KEY1<0>Rec<131>
- Rec: 1, 2 Row: 1 Qual: 1 Len: 12
- Rec: 131, 132 Row: 131 Qual: 1 Len: 2011
- 0)RTL2T:T(N#0#0)(Rng:0)Len<2000>Dim<1>KEY1<0>Rec<131>
- 0)DUMMYT:D1(N#0#0)(Rng:1)Len<32>Dim<130>KEY1<0>Rec<130>
- 1)DEP_ROLE_PARAM:EMC(N#2#0)(Rng:0)Len<1585>Dim<1>KEY1<0>Rec<130>
- Numbers of rows to process:130
- Rec: 130, 261 Row: 260 Qual: 1 Len: 15
- 0)RTL2T:T(N#0#0)(Rng:0)Len<2000>Dim<1>KEY1<0>Rec<131>
- 0)DEP_PROFILE:DP(N#0#0)(Rng:0)Len<309>Dim<1>KEY1<0>Rec<2>
- Rec: 131, 132 Row: 131 Qual: 1 Len: 2011
- Rec: 2, 3 Row: 2 Qual: 1 Len: 11
- 0)DUMMYT:D1(N#0#0)(Rng:1)Len<32>Dim<130>KEY1<0>Rec<130>
- 1)DEP_ROLE_PARAM:EMC(N#2#0)(Rng:0)Len<1585>Dim<1>KEY1<0>Rec<0>
- Rec: 0, 0 Row: 0 Qual: 0 Sort: 0Err: 0
- 0)RTL2T:T(N#0#0)(Rng:0)Len<2000>Dim<1>KEY1<0>Rec<1>
- 0)DUMMYT:D1(N#0#0)(Rng:1)Len<32>Dim<130>KEY1<0>Rec<130>
- Rec: 1, 2 Row: 1 Qual: 1 Len: 2011<0>Rec<0>
- Processing rows:1 to:1000
- Here is the csv file name: cer_install:dep_role_param_reltn.csv 0
- -----
- 0)DPROTECT:D(N#0#0)(Rng:0)Len<256>Dim<1>KEY1<38>Rec<1>
- 0)RTL2T:T(N#0#0)(Rng:0)Len<2000>Dim<1>KEY1<0>Rec<481>
- Rec: 1, 2 Row: 1 Qual: 1 Len: 12
- Rec: 481, 482 Row: 481 Qual: 1 Len: 2011
- 0)RTL2T:T(N#0#0)(Rng:0)Len<2000>Dim<1>KEY1<0>Rec<481>
- 0)DEP_ROLE_PARAM_RELTN:DRPR(N#0#0)(Rng:0)Len<50>Dim<1>KEY1<0>Rec<0>
- Rec: 481, 482 Row: 481 Qual: 1 Len: 2011
- Rec: 0, 480 Row: 480 Qual: 480 Dup: 0 Err: 0
- 0)DUMMYT:D1(N#0#0)(Rng:1)Len<32>Dim<480>KEY1<0>Rec<480>
- 1)DEP_ROLE_PARAM_RELTN:EMC(N#2#0)(Rng:0)Len<50>Dim<1>KEY1<0>Rec<0>
- Rec: 481, 482 Row: 481 Qual: 1 Len: 2011
- Rec: 480, 480 Row: 480 Qual: 480 Dup: 0 Err: 0
- 0)DEP_PROFILE:EMC(N#0#0)(Rng:0)Len<309>Dim<1>KEY1<0>Rec<2>
- Rec: 2, 3 Row: 2 Qual: 1 Len: 19
- 0)DEP_PROFILE:DP(N#0#0)(Rng:3)Len<309>Dim<1>KEY1<0>Rec<0>
- 1)DEP_ROLE_PARAM:DRP(N#5#0)(Rng:2)Len<1585>Dim<1>Row<0>
- 2)DEP_ROLE_PROFILE_RELTN:DRPR2(N#5#0)(Rng:1)Len<34>Dim<1>Row<0>
- 3)DEP_ROLE_PARAM_RELTN:DRPR(N#5#0)(Rng:0)Len<50>Dim<1>Row<0>
- Rec: 0, 1 Row: 0 Qual: 0 Len: 19
- 0)DEP_PROFILE:DP(N#0#0)(Rng:2)Len<309>Dim<1>KEY1<0>Rec<0>
- 1)DEP_ROLE_PROFILE_RELTN:DRPR2(N#5#0)(Rng:1)Len<34>Dim<1>Row<0>
- 2)DEP_ROLE_PARAM_RELTN:DRPR(N#5#0)(Rng:0)Len<50>Dim<1>Row<0>
- Rec: 0, 1 Row: 0 Qual: 0 Len: 19
- 0)DEP_PROFILE:DP(N#0#0)(Rng:3)Len<309>Dim<1>KEY1<0>Rec<2>
- 1)DEP_ROLE_PARAM:DRP(N#5#0)(Rng:2)Len<1585>Dim<1>Row<2>
- 2)DEP_ROLE_PROFILE_RELTN:DRPR2(N#5#0)(Rng:1)Len<34>Dim<1>Row<2>
- 3)DEP_ROLE_PARAM_RELTN:DRPR(N#5#0)(Rng:0)Len<50>Dim<1>Row<2>
- Rec: 2, 3 Row: 8 Qual: 1 Len: 19
- 0)DEP_ROLE_PARAM:DRP(N#0#0)(Rng:0)Len<1585>Dim<1>KEY1<0>Rec<1>
- Rec: 1, 2 Row: 1 Qual: 1 Len: 266
- 0)DEP_PROFILE_PARAM_RELTN:DPPR(N#0#0)(Rng:0)Len<291>Dim<1>KEY1<0>Rec<0>
- Rec: 0, 2 Row: 2 Qual: 2 Dup: 0 Err: 0
- 0)DEP_ROLE_PARAM:DRP(N#0#0)(Rng:0)Len<1585>Dim<1>KEY1<0>Rec<1>
- Rec: 1, 2 Row: 1 Qual: 1 Len: 266
- 0)DEP_PROFILE_PARAM_RELTN:DPPR(N#0#0)(Rng:0)Len<291>Dim<1>KEY1<0>Rec<0>
- Rec: 0, 2 Row: 2 Qual: 2 Dup: 0 Err: 0
- 0)DEP_PROFILE:DP(N#0#0)(Rng:2)Len<309>Dim<1>KEY1<0>Rec<0>
- 1)DEP_ROLE_PROFILE_RELTN:DRPR2(N#5#0)(Rng:1)Len<34>Dim<1>Row<0>
- 2)DEP_ROLE_PARAM_RELTN:DRPR(N#5#0)(Rng:0)Len<50>Dim<1>Row<0>
- Rec: 0, 1 Row: 0 Qual: 0 Len: 19
- 0)DEP_ROLE_PARAM:DRP(N#0#0)(Rng:0)Len<1585>Dim<1>KEY1<0>Rec<15>
- Rec: 15, 16 Row: 15 Qual: 1 Len: 274
- 0)DUMMYT:D1(N#0#0)(Rng:1)Len<32>Dim<15>KEY1<0>Rec<15>
- 1)DEP_PROFILE_PARAM_RELTN:EMC(N#2#0)(Rng:0)Len<291>Dim<1>KEY1<0>Rec<30>
- Rec: 15, 46 Row: 45 Qual: 1 Len: 15
- 0)DEP_PROFILE_PARAM_RELTN:DPPR(N#0#0)(Rng:0)Len<291>Dim<1>KEY1<0>Rec<2>
- 1)DEP_PROFILE:DP(N#5#0)(Rng:1)Len<309>Dim<1>Row<2>
- 2)DEP_ROLE_PROFILE_RELTN:DRPR(N#5#0)(Rng:2)Len<34>Dim<1>Row<2>
- 3)DEP_PROFILE_DEV_RELTN:DPDR(N#5#0)(Rng:3)Len<2401>Dim<1>Row<2>
- Rec: 2, 3 Row: 8 Qual: 1 Len: 282
- 0)DEP_PROFILE_PARAM_RELTN:DPPR(N#0#0)(Rng:0)Len<291>Dim<1>KEY1<0>Rec<0>
- 1)DEP_PROFILE:DP(N#5#0)(Rng:1)Len<309>Dim<1>Row<0>
- 2)DEP_ROLE_PROFILE_RELTN:DRPR(N#5#0)(Rng:2)Len<34>Dim<1>Row<0>
- 3)DEP_PROFILE_DEV_RELTN:DPDR(N#5#0)(Rng:3)Len<2401>Dim<1>Row<0>
- Rec: 0, 1 Row: 0 Qual: 0 Len: 19
- 0)DEP_PROFILE_PARAM_RELTN:DPPR(N#0#0)(Rng:0)Len<291>Dim<1>KEY1<0>Rec<0>
- 1)DEP_PROFILE:DP(N#5#0)(Rng:1)Len<309>Dim<1>Row<0>
- 2)DEP_ROLE_PROFILE_RELTN:DRPR(N#5#0)(Rng:2)Len<34>Dim<1>Row<0>
- Rec: 0, 1 Row: 0 Qual: 0 Len: 19
- 0)DUMMYT:D1(N#0#0)(Rng:1)Len<32>Dim<15>KEY1<0>Rec<15>
- 1)DEP_PROFILE_PARAM_RELTN:DPPR(N#2#0)(Rng:0)Len<291>Dim<1>KEY1<0>Rec<0>
- Rec: 15, 1 Row: 15 Qual: 0 Dup: 0 Err: 0
- 0)DUMMYT:D1(N#0#0)(Rng:1)Len<32>Dim<15>KEY1<0>Rec<15>
- 1)DEP_PROFILE_PARAM_RELTN:DPPR(N#2#0)(Rng:0)Len<291>Dim<1>KEY1<0>Rec<0>
- Rec: 15, 1 Row: 15 Qual: 0 Dup: 0 Err: 0
- 0)DEP_PROFILE_PARAM_RELTN:DPPR(N#0#0)(Rng:0)Len<291>Dim<1>KEY1<0>Rec<0>
- Rec: 0, 1 Row: 0 Qual: 0 Len: 266
- 0)DEP_PROFILE_PARAM_RELTN:DEP_PROFILE_PARAM_RELTN(N#0#0)(Rng:0)Len<291>Dim<1>KEY1<0>Rec<0>
- Rec: 0, 0 Row: 0 Qual: 0 Dup: 0 Err: 0
- 0)DEP_ROLE_PARAM_RELTN:DEP_ROLE_PARAM_RELTN(N#0#0)(Rng:0)Len<50>Dim<1>KEY1<0>Rec<0>
- Rec: 0, 0 Row: 0 Qual: 0 Dup: 0 Err: 0
- 0)DEP_PROFILE_PARAM_RELTN:DEP_PROFILE_PARAM_RELTN(N#0#0)(Rng:0)Len<291>Dim<1>KEY1<0>Rec<0>
- Rec: 0, 0 Row: 0 Qual: 0 Dup: 0 Err: 0
- 0)DEP_ROLE_PARAM_RELTN:DEP_ROLE_PARAM_RELTN(N#0#0)(Rng:0)Len<50>Dim<1>KEY1<0>Rec<0>
- Rec: 0, 0 Row: 0 Qual: 0 Dup: 0 Err: 0
- 0)DEP_ROLE_PARAM:DRP(N#0#0)(Rng:2)Len<1585>Dim<1>KEY1<0>Rec<4>
- 1)DEP_PROFILE_PARAM_RELTN:DPPR(N#5#0)(Rng:1)Len<291>Dim<1>Row<4>
- 2)DEP_PROFILE:DP(N#5#0)(Rng:0)Len<309>Dim<1>Row<4>
- Rec: 4, 5 Row: 12 Qual: 1 Len: 282
- 0)DUMMYT:D1(N#0#0)(Rng:1)Len<32>Dim<4>KEY1<0>Rec<4>
- 1)DEP_PROFILE_PARAM_RELTN:DPPR(N#2#0)(Rng:0)Len<291>Dim<1>KEY1<0>Rec<0>
- Rec: 0, 0 Row: 0 Qual: 0 Sort: 0
- 0)RTL2T:T(N#0#0)(Rng:0)Len<2000>Dim<1>KEY1<0>Rec<1> 0 Err: 0
- Rec: 1, 2 Row: 1 Qual: 1 Len: 2011<0>Rec<0>
- Processing rows:1 to:1000
- Here is the csv file name: cer_install:dep_role_is_reltn.csv: 0
- -----
- 0)DPROTECT:D(N#0#0)(Rng:0)Len<256>Dim<1>KEY1<38>Rec<1>
- 0)RTL2T:T(N#0#0)(Rng:0)Len<2000>Dim<1>KEY1<0>Rec<17>
- Rec: 1, 2 Row: 1 Qual: 1 Len: 12
- Rec: 17, 18 Row: 17 Qual: 1 Len: 2011
- 0)RTL2T:T(N#0#0)(Rng:0)Len<2000>Dim<1>KEY1<0>Rec<17>
- 0)DUMMYT:D1(N#0#0)(Rng:1)Len<32>Dim<16>KEY1<0>Rec<16>
- 1)DEP_ROLE_IS_RELTN:EMC(N#2#0)(Rng:0)Len<44>Dim<1>KEY1<0>Rec<16>
- Numbers of rows to process:16
- Rec: 16, 33 Row: 32 Qual: 1 Len: 15
- 0)RTL2T:T(N#0#0)(Rng:0)Len<2000>Dim<1>KEY1<0>Rec<17>
- 0)DUMMYT:D1(N#0#0)(Rng:1)Len<32>Dim<16>KEY1<0>Rec<16>
- 1)DEP_ROLE_IS_RELTN:EMC(N#2#0)(Rng:0)Len<44>Dim<1>KEY1<0>Rec<0>
- Rec: 0, 0 Row: 0 Qual: 0 Sort: 0Err: 0
- 0)RTL2T:T(N#0#0)(Rng:0)Len<2000>Dim<1>KEY1<0>Rec<1>
- 0)DUMMYT:D1(N#0#0)(Rng:1)Len<32>Dim<16>KEY1<0>Rec<16>
- Rec: 1, 2 Row: 1 Qual: 1 Len: 20111<0>Rec<0>
- Processing rows:1 to:1000
- Here is the csv file name: cer_install:dep_solution.csv0 Err: 0
- -----
- 0)DPROTECT:D(N#0#0)(Rng:0)Len<256>Dim<1>KEY1<38>Rec<1>
- 0)RTL2T:T(N#0#0)(Rng:0)Len<2000>Dim<1>KEY1<0>Rec<88>
- Rec: 1, 2 Row: 1 Qual: 1 Len: 12
- Rec: 88, 89 Row: 88 Qual: 1 Len: 2011
- 0)RTL2T:T(N#0#0)(Rng:0)Len<2000>Dim<1>KEY1<0>Rec<88>
- 0)DUMMYT:D1(N#0#0)(Rng:1)Len<32>Dim<87>KEY1<0>Rec<87>
- 1)DEP_SOLUTION:EMC(N#2#0)(Rng:0)Len<293>Dim<1>KEY1<0>Rec<87>
- Numbers of rows to process:87
- Rec: 87, 175 Row: 174 Qual: 1 Len: 15
- 0)RTL2T:T(N#0#0)(Rng:0)Len<2000>Dim<1>KEY1<0>Rec<88>
- 0)DUMMYT:D1(N#0#0)(Rng:1)Len<32>Dim<87>KEY1<0>Rec<87>
- 1)DEP_SOLUTION:EMC(N#2#0)(Rng:0)Len<293>Dim<1>KEY1<0>Rec<0>
- Rec: 0, 0 Row: 0 Qual: 0 Sort: 0Err: 0
- 0)RTL2T:T(N#0#0)(Rng:0)Len<2000>Dim<1>KEY1<0>Rec<1>
- 0)DUMMYT:D1(N#0#0)(Rng:1)Len<32>Dim<87>KEY1<0>Rec<87>
- Rec: 1, 2 Row: 1 Qual: 1 Len: 2011Rec<0>
- Processing rows:1 to:1000
- Here is the csv file name: cer_install:dep_end_state.csv Err: 0
- -----
- 0)DPROTECT:D(N#0#0)(Rng:0)Len<256>Dim<1>KEY1<38>Rec<1>
- 0)RTL2T:T(N#0#0)(Rng:0)Len<2000>Dim<1>KEY1<0>Rec<27>
- Rec: 1, 2 Row: 1 Qual: 1 Len: 12
- Rec: 27, 28 Row: 27 Qual: 1 Len: 2011
- 0)RTL2T:T(N#0#0)(Rng:0)Len<2000>Dim<1>KEY1<0>Rec<27>
- 0)DUMMYT:D1(N#0#0)(Rng:1)Len<32>Dim<26>KEY1<0>Rec<26>
- 1)DEP_END_STATE:DES(N#2#0)(Rng:0)Len<325>Dim<1>KEY1<0>Rec<52>
- Numbers of rows to process:26
- Rec: 26, 79 Row: 78 Qual: 1 Len: 15
- 0)RTL2T:T(N#0#0)(Rng:0)Len<2000>Dim<1>KEY1<0>Rec<27>
- 0)DUMMYT:D1(N#0#0)(Rng:1)Len<32>Dim<26>KEY1<0>Rec<26>
- 1)DEP_END_STATE:DES(N#2#0)(Rng:0)Len<325>Dim<1>KEY1<0>Rec<0>
- Rec: 26, 1 Row: 26 Qual: 0 Dup: 0 Err: 0
- 0)DUMMYT:D1(N#0#0)(Rng:1)Len<32>Dim<26>KEY1<0>Rec<26>
- 1)DEP_END_STATE:DES(N#2#0)(Rng:0)Len<325>Dim<1>KEY1<0>Rec<0>
- Rec: 26, 1 Row: 26 Qual: 0 Dup: 0 Err: 0
- 0)DUMMYT:D1(N#0#0)(Rng:1)Len<32>Dim<26>KEY1<0>Rec<26>
- 1)DEP_END_STATE:DES(N#2#0)(Rng:0)Len<325>Dim<1>KEY1<0>Rec<0>
- Rec: 0, 0 Row: 0 Qual: 0 Sort: 0
- 0)RTL2T:T(N#0#0)(Rng:0)Len<2000>Dim<1>KEY1<0>Rec<1> 0 Err: 0
- Rec: 1, 2 Row: 1 Qual: 1 Len: 2011Rec<0>
- Processing rows:1 to:1000
- Here is the csv file name: cer_install:dep_obsoletion_is_id_reltn.csv
- -----
- 0)DPROTECT:D(N#0#0)(Rng:0)Len<256>Dim<1>KEY1<38>Rec<1>
- 0)RTL2T:T(N#0#0)(Rng:0)Len<2000>Dim<1>KEY1<0>Rec<29>
- Rec: 1, 2 Row: 1 Qual: 1 Len: 12
- Rec: 29, 30 Row: 29 Qual: 1 Len: 2011
- 0)RTL2T:T(N#0#0)(Rng:0)Len<2000>Dim<1>KEY1<0>Rec<29>
- 0)DUMMYT:D1(N#0#0)(Rng:1)Len<32>Dim<28>KEY1<0>Rec<28>
- 1)DEP_OBSOLETION_IS_ID_RELTN:EMC(N#2#0)(Rng:0)Len<44>Dim<1>KEY1<0>Rec<28>
- Numbers of rows to process:28
- Rec: 28, 57 Row: 56 Qual: 1 Len: 15
- 0)RTL2T:T(N#0#0)(Rng:0)Len<2000>Dim<1>KEY1<0>Rec<29>
- 0)DUMMYT:D1(N#0#0)(Rng:1)Len<32>Dim<28>KEY1<0>Rec<28>
- 1)DEP_OBSOLETION_IS_ID_RELTN:EMC(N#2#0)(Rng:0)Len<44>Dim<1>KEY1<0>Rec<0>
- Rec: 0, 0 Row: 0 Qual: 0 Sort: 0Err: 0
- 0)RTL2T:T(N#0#0)(Rng:0)Len<2000>Dim<1>KEY1<0>Rec<1>
- 0)DUMMYT:D1(N#0#0)(Rng:1)Len<32>Dim<28>KEY1<0>Rec<28>
- Rec: 1, 2 Row: 1 Qual: 1 Len: 2011Dim<1>KEY1<0>Rec<0>
- Processing rows:1 to:1000
- Here is the csv file name: cer_install:dep_platform.csv0 Err: 0
- -----
- 0)DPROTECT:D(N#0#0)(Rng:0)Len<256>Dim<1>KEY1<38>Rec<1>
- 0)RTL2T:T(N#0#0)(Rng:0)Len<2000>Dim<1>KEY1<0>Rec<4>
- Rec: 1, 2 Row: 1 Qual: 1 Len: 12
- Rec: 4, 5 Row: 4 Qual: 1 Len: 2011
- 0)RTL2T:T(N#0#0)(Rng:0)Len<2000>Dim<1>KEY1<0>Rec<4>
- 0)DUMMYT:D1(N#0#0)(Rng:1)Len<32>Dim<3>KEY1<0>Rec<3>
- 1)DEP_PLATFORM:EMC(N#2#0)(Rng:0)Len<289>Dim<1>KEY1<0>Rec<3>
- Numbers of rows to process:3
- Rec: 3, 7 Row: 6 Qual: 1 Len: 15
- 0)RTL2T:T(N#0#0)(Rng:0)Len<2000>Dim<1>KEY1<0>Rec<4>
- 0)DUMMYT:D1(N#0#0)(Rng:1)Len<32>Dim<3>KEY1<0>Rec<3>
- 1)DEP_PLATFORM:EMC(N#2#0)(Rng:0)Len<289>Dim<1>KEY1<0>Rec<0>
- Rec: 0, 0 Row: 0 Qual: 0 Sort: 0Err: 0
- 0)RTL2T:T(N#0#0)(Rng:0)Len<2000>Dim<1>KEY1<0>Rec<1>
- 0)DUMMYT:D1(N#0#0)(Rng:1)Len<32>Dim<3>KEY1<0>Rec<3>
- Rec: 1, 2 Row: 1 Qual: 1 Len: 2011Rec<0>
- Processing rows:1 to:1000
- Here is the csv file name: cer_install:dep_role_platform_reltn.csv 0
- -----
- 0)DPROTECT:D(N#0#0)(Rng:0)Len<256>Dim<1>KEY1<38>Rec<1>
- 0)RTL2T:T(N#0#0)(Rng:0)Len<2000>Dim<1>KEY1<0>Rec<19>
- Rec: 1, 2 Row: 1 Qual: 1 Len: 12
- Rec: 19, 20 Row: 19 Qual: 1 Len: 2011
- 0)RTL2T:T(N#0#0)(Rng:0)Len<2000>Dim<1>KEY1<0>Rec<19>
- 0)DUMMYT:D1(N#0#0)(Rng:1)Len<32>Dim<18>KEY1<0>Rec<18>
- 1)DEP_ROLE_PLATFORM_RELTN:EMC(N#2#0)(Rng:0)Len<42>Dim<1>KEY1<0>Rec<18>
- Numbers of rows to process:18
- Rec: 18, 37 Row: 36 Qual: 1 Len: 15
- 0)RTL2T:T(N#0#0)(Rng:0)Len<2000>Dim<1>KEY1<0>Rec<19>
- 0)DUMMYT:D1(N#0#0)(Rng:1)Len<32>Dim<18>KEY1<0>Rec<18>
- 1)DEP_ROLE_PLATFORM_RELTN:EMC(N#2#0)(Rng:0)Len<42>Dim<1>KEY1<0>Rec<0>
- Rec: 0, 0 Row: 0 Qual: 0 Sort: 0Err: 0
- 0)RTL2T:T(N#0#0)(Rng:0)Len<2000>Dim<1>KEY1<0>Rec<1>
- 0)DUMMYT:D1(N#0#0)(Rng:1)Len<32>Dim<18>KEY1<0>Rec<18>
- Rec: 1, 2 Row: 1 Qual: 1 Len: 2011<1>KEY1<0>Rec<0>
- Processing rows:1 to:1000
- Here is the csv file name: cer_install:dep_role_cat_restriction_reltn.csv
- -----
- 0)DPROTECT:D(N#0#0)(Rng:0)Len<256>Dim<1>KEY1<38>Rec<1>
- 0)RTL2T:T(N#0#0)(Rng:0)Len<2000>Dim<1>KEY1<0>Rec<6>
- Rec: 1, 2 Row: 1 Qual: 1 Len: 12
- Rec: 6, 7 Row: 6 Qual: 1 Len: 2011
- 0)RTL2T:T(N#0#0)(Rng:0)Len<2000>Dim<1>KEY1<0>Rec<6>
- 0)DUMMYT:D1(N#0#0)(Rng:1)Len<32>Dim<5>KEY1<0>Rec<5>
- 1)DEP_ROLE_CAT_RESTRICTION_RELTN:RCR(N#2#0)(Rng:0)Len<42>Dim<1>KEY1<0>Rec<5>
- Numbers of rows to process:5
- Rec: 5, 11 Row: 10 Qual: 1 Len: 15
- 0)RTL2T:T(N#0#0)(Rng:0)Len<2000>Dim<1>KEY1<0>Rec<6>
- 0)DUMMYT:D1(N#0#0)(Rng:1)Len<32>Dim<5>KEY1<0>Rec<5>
- 1)DEP_ROLE_CAT_RESTRICTION_RELTN:RCR(N#2#0)(Rng:0)Len<42>Dim<1>KEY1<0>Rec<0>
- Rec: 5, 1 Row: 5 Qual: 0 Dup: 0 Err: 0
- 0)DEP_PROFILE:DP(N#0#0)(Rng:3)Len<309>Dim<1>KEY1<0>Rec<0>
- 1)DEP_PROFILE_DEV_RELTN:DPDR(N#5#0)(Rng:2)Len<2401>Dim<1>Row<0>
- 2)DEP_VIRT_TARGET_RELTN:DVTR(N#5#0)(Rng:1)Len<34>Dim<1>Row<0>
- 3)DEP_VIRT_END_STATE_RELTN:DVESR(N#5#0)(Rng:0)Len<42>Dim<1>Row<0>
- Rec: 0, 1 Row: 0 Qual: 0 Len: 27
- 0)DEP_PROFILE:DP(N#0#0)(Rng:3)Len<309>Dim<1>KEY1<0>Rec<0>
- 1)DEP_PROFILE_DEV_RELTN:DPDR(N#5#0)(Rng:2)Len<2401>Dim<1>Row<0>
- 2)DEP_VIRT_TARGET_RELTN:DVTR(N#5#0)(Rng:1)Len<34>Dim<1>Row<0>
- 3)DEP_VIRT_END_STATE_RELTN:DVESR(N#5#0)(Rng:0)Len<42>Dim<1>Row<0>
- Rec: 0, 1 Row: 0 Qual: 0 Len: 35
- >>>Begin EchoRecord README_DATA ;README_DATA
- 1 OCD= I4 {0}
- 1 README_ID=F8 {0.0000000000 }
- 1 INSTANCE= I4 {0}
- 1 README_TYPE=VC0 {}
- 1 DESCRIPTION=VC0 {}
- 1 SCRIPT=VC0 {}
- 1 CHECK_SCRIPT=VC0 {}
- 1 DATA_FILE=VC0 {}
- 1 PAR_FILE=VC0 {}
- 1 BLOCKS= I4 {0}
- 1 LOG_ROWID=VC0 {}
- 1 STATUS=VC1 {S}
- 1 MESSAGE=C255 {Completed dep_dbimport_wrapper, all readme completed successfully. }
- { }
- { }
- { }
- 1 OPTIONS=VC0 {}
- 1 DRIVER=VC0 {}
- 1 BATCH_DT_TM=DQ8 {0 (0000-00-00 00:00:00.00) utc(0)}
- >>>End EchoRecord README_DATA varchar=1, varlist=0, size(363,292)
- 0)PRODUCT_COMPONENT_VERSION:P(N#0#0)(Rng:0)Len<258>Dim<1>KEY1<0>Rec<1>
- Rec: 1, 2 Row: 1 Qual: 1 Len: 91
- 0)USER_TAB_COLUMNS:UTC(N#0#0)(Rng:0)Len<32466>Dim<1>KEY1<0>Rec<12>
- 1)DTABLE:DT(N#2#0)(Rng:1)Len<736>Dim<1>KEY1<36>Rec<12>
- Rec: 12, 37 Row: 24 Qual: 12 Len: 12
- 0)DM_INFO:D(N#0#0)(Rng:0)Len<4417>Dim<1>KEY1<0>Rec<0>
- Rec: 0, 1 Row: 0 Qual: 0 Len: 12
- 0)DM_INFO:D(N#0#0)(Rng:0)Len<4417>Dim<1>KEY1<0>Rec<1>
- 1)DM_ENVIRONMENT:DE(N#5#0)(Rng:1)Len<868>Dim<1>Row<1>
- Rec: 1, 2 Row: 2 Qual: 1 Len: 19
- 0)DM_INFO:DI(N#0#0)(Rng:0)Len<4417>Dim<1>KEY1<0>Rec<0>
- Rec: 0, 1 Row: 0 Qual: 0 Len: 11
- 0)DM_OCD_LOG:L(N#0#0)(Rng:0)Len<714>Dim<1>KEY1<0>Rec<0>
- Rec: 0, 1 Row: 0 Qual: 0 Len: 31
- 170316:105328 DEP_DBIMPORT_WRAPPER Cost 2.00 Cpu 0.15 Ela 7.86 Bio 0 Dio 0 O0M0R2 P40R5197C1 S99,399 I15,480 U18,363 D6
- Command executed!
- 1)
- %CCL-L-346-CCL(0,0)S0L0.0l1{}Rollback issued for CCL inactive session due to timeout of 10 minutes.
- %CCL-L-346-CCL(0,0)S0L0.0l1{}Rollback issued for CCL inactive session due to timeout of 10 minutes.
- %CCL-F-293-CCL(0,0)S0L0.0l1{}CCL inactive session terminated due to timeout of 30 minutes.
- CCL LOG(03/16/17 11:23) Pool(486) Sym(ms1063,ls1063) Rdbms(249330)
- CCL CACHE Rng(Max:200 Hit:179 Mis:31 Ful:0) Prg(Max:200 Siz:125 Hit:22 Mis:28 Ful:0 Ovr:10)
- CCL FreePages(d4183037,s54269)
- FreePages0(4183037,0)Pool(13,2,1,53596)Misc(486,0)Rdb(249330)Fun(0,0)Ret(0)Sub(286)Prg(18)Rng(30)Rec(11,0,0,0 0,0,0,0)
- CCL LOG(03/16/17 11:23) Pool(486) Sym(ms1063,ls1063) Rdbms(249330)
- CCL CACHE Rng(Max:200 Hit:179 Mis:31 Ful:0) Prg(Max:200 Siz:125 Hit:22 Mis:28 Ful:0 Ovr:10)
- emoving CCL temp files for session...
- Ccldir(2W_63) Stat(Reopen:0,Par:2)
- CclExit(File:0 Beg:483 End:0 Blk:15) <Dcl:0 Work:0 Prg:18 Rng:60 Var:76 Sub:286 Eks:0 Misc:43>
- SESSION COMPLETE(CCL Rev:8.7.2 Hnam:01OCT2011).
- You have mail in /usr/spool/mail/root
- root:cert@(srvlabaix):/:
- #
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement