Archive for February, 2018

ORA-00376 file 2 cannot be read at this time ORA-01548 UNDO Needs Recovery

February 27th, 2018, posted in Oracle Queries
Share

ORA-00376: file 2 cannot be read at this time ,

ORA-01548 UNDO “Needs Recovery”:

Error:

Wed May 21 07:52:20 2014
Errors in file c:\oracle\product\10.2.0\admin\ \bdump\ _cjq0_3412.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-00376: file 2 cannot be read at this time
ORA-01110: data file 2: ‘C:\ORACLE\ORADATA\ \DATA\ \UNDOTBS01.DBF’

Wed May 21 07:52:20 2014
Errors in file c:\oracle\product\10.2.0\admin\ \bdump\ _cjq0_3412.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-00376: file 2 cannot be read at this time
ORA-01110: data file 2: ‘C:\ORACLE\ORADATA\ \DATA\ \UNDOTBS01.DBF’

SQL> select file_name from dba_data_files where tablespace_name=’UNDOTBS1′;

FILE_NAME
 --------------------------------------------------------------------------------
 C:\ORACLE\ORADATA\ \DATA\ \UNDOTBS01.DBF
 C:\ORACLE\ORADATA\ \DATA\ \UNDOTBS02.DBF

SQL>

SQL> drop tablespace UNDOTBS1 including contents and datafiles;
 drop tablespace UNDOTBS1 including contents and datafiles
 *
 ERROR at line 1:
 ORA-01548: active rollback segment '_SYSSMU1$' found, terminate dropping tablespace

SQL>

Solution:

From the below SQL it shows that UNDOTBS1 contains a few corrupt undo segments

SQL> select segment_name,status,tablespace_name from  dba_rollback_segs where status not in (‘ONLINE’,’OFFLINE’);

SEGMENT_NAME                   STATUS           TABLESPACE_NAME
 ------------------------------ ---------------- ------------------------------
 _SYSSMU1$                      NEEDS RECOVERY   UNDOTBS1
 _SYSSMU2$                      NEEDS RECOVERY   UNDOTBS1
 _SYSSMU3$                      NEEDS RECOVERY   UNDOTBS1
 _SYSSMU4$                      NEEDS RECOVERY   UNDOTBS1
 _SYSSMU5$                      NEEDS RECOVERY   UNDOTBS1
 _SYSSMU6$                      NEEDS RECOVERY   UNDOTBS1
 _SYSSMU7$                      NEEDS RECOVERY   UNDOTBS1
 _SYSSMU8$                      NEEDS RECOVERY   UNDOTBS1
 _SYSSMU9$                      NEEDS RECOVERY   UNDOTBS1
 _SYSSMU10$                     NEEDS RECOVERY   UNDOTBS1

10 rows selected.

SQL>

ORA-00376 file 2 cannot be read at this time,ORA-01548 UNDO Needs Recovery,UNDO Needs Recovery,Needs Recovery,ORA-01548,ORA-00376,cannot be read at this time,Oracle dba,oracle apps,oracle database,oracle dba database,oracle need recovery,oracle recovery,database recovery,ORA 01548,ORA 00376,Ora error,apps dba,core dba,oracle dba,dba oracl,Oracle tablespace

 

 

 

 

 

To get past this problem:

  1. create a pfile from the current spfile,
  2. change UNDO_MANAGEMENT  to ‘MANUAL’ and UNDO_TABLESPACE to ‘SYSTEM’ in the pfile
  3. add the _corrupt_rollback_segments init parameter to the pfile    “_corrupted_rollback_segments=(_SYSSMU1$,_SYSSMU2$,_SYSSMU3$,_SYSSMU4$,_SYSSMU5$,_SYSSMU6$,_SYSSMU7$,_SYSSMU8$,_SYSSMU9$,_SYSSMU10$)”
  4. startup the database using “startup pfile=’<location/name of pfile>’ “;
  5. drop corrupt UNDOTBS1 uncluding contents and datafiles
  6. create a new UNDO tablespace
  7. shutdown database again, and startup using the existing spfile (not pfile)

 

SQL> create pfile from spfile;

File created.

SQL>

*.undo_management=’AUTO’
*.undo_tablespace=’UNDOTBS2′
_corrupted_rollback_segments=(_SYSSMU1$,_SYSSMU2$,_SYSSMU3$,_SYSSMU4$,_SYSSMU5$,_SYSSMU6$,_SYSSMU7$,_SYSSMU8$,_SYSSMU9$,_SYSSMU10$)

 

 

SQL> startup pfile=’C:\oracle\product\10.2.0\db_1\database\INITwicustest.ora’;

ORACLE instance started.

Total System Global Area 1258291200 bytes
Fixed Size                  2065408 bytes
Variable Size             788532224 bytes
Database Buffers          452984832 bytes
Redo Buffers               14708736 bytes
Database mounted.
Database opened.
SQL> drop tablespace UNDOTBS1 including contents and datafiles;

Tablespace dropped.

SQL> create UNDO tablespace UNDOTBS1 datafile ‘C:\ORACLE\ORADATA\ \DATA\ \UNDOTBS01.DBF’ size 250M;

Tablespace created.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

C:\Users\Wicus>sqlplus sys as sysdba

 

SQL*Plus: Release 10.2.0.4.0 - Production on Wed May 21 07:56:13 2014

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Enter password:
 Connected to an idle instance.
SQL> startup
 ORACLE instance started.

Total System Global Area 1258291200 bytes
 Fixed Size                  2065408 bytes
 Variable Size             788532224 bytes
 Database Buffers          452984832 bytes
 Redo Buffers               14708736 bytes
 Database mounted.
 Database opened.
 SQL>

 

Share

Fullmetal Alchemist Brotherhood Homunculus Last Words

February 25th, 2018, posted in Art, ChARACtERs, MOViES, STORiES, TV Shows, Words, WORKiNG iN GRAPHiCS
Share

fullmetal alchemist brotherhood,fullmetal alchemist, brotherhood,fullmetal, alchemist brotherhood,lust,greed,warth,envy,father,sloth,gloth,pride,lust fullmetal alchemist brotherhood,greed fullmetal alchemist brotherhood,warth fullmetal alchemist brotherhood,envy fullmetal alchemist brotherhood,father fullmetal alchemist brotherhood,sloth fullmetal alchemist brotherhood,gloth fullmetal alchemist brotherhood,pride fullmetal alchemist brotherhood,

fullmetal alchemist brotherhood,fullmetal alchemist, brotherhood,fullmetal, alchemist brotherhood,lust,greed,warth,envy,father,sloth,gloth,pride,lust fullmetal alchemist brotherhood,greed fullmetal alchemist brotherhood,warth fullmetal alchemist brotherhood,envy fullmetal alchemist brotherhood,father fullmetal alchemist brotherhood,sloth fullmetal alchemist brotherhood,gloth fullmetal alchemist brotherhood,pride fullmetal alchemist brotherhood,

fullmetal alchemist brotherhood,fullmetal alchemist, brotherhood,fullmetal, alchemist brotherhood,lust,greed,warth,envy,father,sloth,gloth,pride,lust fullmetal alchemist brotherhood,greed fullmetal alchemist brotherhood,warth fullmetal alchemist brotherhood,envy fullmetal alchemist brotherhood,father fullmetal alchemist brotherhood,sloth fullmetal alchemist brotherhood,gloth fullmetal alchemist brotherhood,pride fullmetal alchemist brotherhood,

fullmetal alchemist brotherhood,fullmetal alchemist, brotherhood,fullmetal, alchemist brotherhood,lust,greed,warth,envy,father,sloth,gloth,pride,lust fullmetal alchemist brotherhood,greed fullmetal alchemist brotherhood,warth fullmetal alchemist brotherhood,envy fullmetal alchemist brotherhood,father fullmetal alchemist brotherhood,sloth fullmetal alchemist brotherhood,gloth fullmetal alchemist brotherhood,pride fullmetal alchemist brotherhood,

fullmetal alchemist brotherhood,fullmetal alchemist, brotherhood,fullmetal, alchemist brotherhood,lust,greed,warth,envy,father,sloth,gloth,pride,lust fullmetal alchemist brotherhood,greed fullmetal alchemist brotherhood,warth fullmetal alchemist brotherhood,envy fullmetal alchemist brotherhood,father fullmetal alchemist brotherhood,sloth fullmetal alchemist brotherhood,gloth fullmetal alchemist brotherhood,pride fullmetal alchemist brotherhood,

fullmetal alchemist brotherhood,fullmetal alchemist, brotherhood,fullmetal, alchemist brotherhood,lust,greed,warth,envy,father,sloth,gloth,pride,lust fullmetal alchemist brotherhood,greed fullmetal alchemist brotherhood,warth fullmetal alchemist brotherhood,envy fullmetal alchemist brotherhood,father fullmetal alchemist brotherhood,sloth fullmetal alchemist brotherhood,gloth fullmetal alchemist brotherhood,pride fullmetal alchemist brotherhood,

fullmetal alchemist brotherhood,fullmetal alchemist, brotherhood,fullmetal, alchemist brotherhood,lust,greed,warth,envy,father,sloth,gloth,pride,lust fullmetal alchemist brotherhood,greed fullmetal alchemist brotherhood,warth fullmetal alchemist brotherhood,envy fullmetal alchemist brotherhood,father fullmetal alchemist brotherhood,sloth fullmetal alchemist brotherhood,gloth fullmetal alchemist brotherhood,pride fullmetal alchemist brotherhood,

Share

PSL 3 Schedule 2018 Time Table

February 22nd, 2018, posted in DAtEs iN a YeAR, PAKiSTAN
Share

PSL 3 Schedule 2018 Time Table,PSL 3 Schedule 2018,Time Table,PSL 3 Schedule,PSL 3,Schedule,Pakistan Super League,Pakistan,Pakistan Super League Teams,Islamabad United, Karachi Kings,Lahore Qalandars,Multan Sultans,Peshawar Zalmi,Quetta Gladiators,Islamabad, Karachi,Lahore,Multan,Peshawar,Quetta




PSL Schedule 2018 Time Table

 

Date Matches Time (PST) Venue
Thursday, February 22 Peshawar Zalmi vs Multan Sultans 10:00 pm Dubai
Friday, February 23 Karachi Kings vs Quetta Gladiators 4:30 pm Dubai
Multan Sultans vs Lahore Qalandars 9:00 pm
Saturday, February 24 Islamabad United vs Peshawar Zalmi 4:30 pm Dubai
Quetta Gladiators vs Lahore Qalandars 9:00 pm
Sunday, February 25 Multan Sultans vs Islamabad United 4:30 pm Dubai
Karachi Kings vs Peshawar Zalmi 9:00 pm
Monday, February 26 Karachi Kings vs Lahore Qalandars 9:00 pm Dubai
Wednesday, February 28 Islamabad United vs Quetta Gladiators 9:00 pm Sharjah
Thursday, March 1 Quetta Gladiators vs Peshawar Zalmi 9:00 pm Sharjah
Friday, March 2 Multan Sultans vs Karachi Kings 4:30 pm Sharjah
Lahore Qalandars vs Islamabad United 9:00 pm
Saturday, March 3 Multan Sultans vs Quetta Gladiators 4:30 pm Sharjah
Peshawar Zalmi vs Lahore Qalandars 9:00 pm
Sunday, March 4 Islamabad United vs Karachi Kings 9:00 pm Sharjah
Tuesday March 6 Peshawar Zalmi vs Multan Sultans 9:00 pm Dubai
Wednesday, March 7 Multan Sultans vs Quetta Gladiators 9:00 pm Dubai
Thursday, March 8 Islamabad United vs Lahore Qalandars 4:30 pm Dubai
Karachi Kings vs Quetta Gladiators 9:00 pm
Friday, March 9 Multan Sultans vs Lahore Qalandars 4:30 pm Dubai
Peshawar Zalmi vs Islamabad United 9:00 pm
Saturday, March 10 Multan Sultans vs Karachi Kings 4:30 pm Dubai
Peshawar Zalmi vs Quetta Gladiators 9:00 pm
Sunday, March 11 Karachi Kings vs Lahore Qalandars 9:00 pm Dubai
Tuesday March 13 Multan Sultans vs Islamabad United 9:00 pm Sharjah
Wednesday, March 14 Quetta Gladiators vs Lahore Qalandars 9:00 pm Sharjah
Thursday, March 15 Peshawar Zalmi vs Karachi Kings 4:30 pm Sharjah
Quetta Gladiators vs Islamabad United 9:00 pm
Friday, March 16 Peshawar Zalmi vs Lahore Qalandars 4:30 pm Sharjah
Islamabad United vs Karachi Kings 9:00 pm
Play-Offs
Sunday, March 18 Qualifier – Team 1 vs Team 2 9:00 pm Dubai
Tuesday March 20 Eliminator 1 – Team 3 vs Team 4 7:00 pm Lahore
Wednesday, March 21 Eliminator 2 – Eliminator 1 Winner vs Qualifier Loser 7:00 pm Lahore
Sunday, March 25 PSL Final 7:00 pm Karachi




UAE Match Timings

Opening Ceremony : 7:00 pm UAE time / 8:00 pm Pakistan time
Opening Match : 9:00 pm UAE time / 10:00 pm Pakistan time
Day Matches in UAE : 3:30 pm UAE time / 4:30 pm Pakistan time
Night Matches in UAE : 8:00 pm UAE time / 9:00 pm Pakistan time

Share

FLASH EXPLAINS WHY YOU CAN’T ENFORCE PEACE

February 20th, 2018, posted in Art, COMiCS, MOViES, WORKiNG iN GRAPHiCS
Share

FLASH EXPLAINS WHY YOU CAN’T ENFORCE PEACE,FLASH, EXPLAINS WHY YOU CAN’T ENFORCE PEACE,ENFORCE PEACE,PEACE,superman vs flash,flash vs superman,flash and superman race,race superman and flash,justice league,jjustice league animated,justice league comic,flash comic,superman comic,flash vs superman comic,flash playing chess,superman playing chess FLASH EXPLAINS WHY YOU CAN’T ENFORCE PEACE,FLASH, EXPLAINS WHY YOU CAN’T ENFORCE PEACE,ENFORCE PEACE,PEACE,superman vs flash,flash vs superman,flash and superman race,race superman and flash,justice league,jjustice league animated,justice league comic,flash comic,superman comic,flash vs superman comic,flash playing chess,superman playing chess FLASH EXPLAINS WHY YOU CAN’T ENFORCE PEACE,FLASH, EXPLAINS WHY YOU CAN’T ENFORCE PEACE,ENFORCE PEACE,PEACE,superman vs flash,flash vs superman,flash and superman race,race superman and flash,justice league,jjustice league animated,justice league comic,flash comic,superman comic,flash vs superman comic,flash playing chess,superman playing chess FLASH EXPLAINS WHY YOU CAN’T ENFORCE PEACE,FLASH, EXPLAINS WHY YOU CAN’T ENFORCE PEACE,ENFORCE PEACE,PEACE,superman vs flash,flash vs superman,flash and superman race,race superman and flash,justice league,jjustice league animated,justice league comic,flash comic,superman comic,flash vs superman comic,flash playing chess,superman playing chess

Share

APP-PAY-06153 System Error Procedure INITFORMS at Step 1

February 18th, 2018, posted in Oracle
Share

Problem : 


APP-PAY-06153: System Error : Procedure INIT_FORMS at Step 1

Cause: The procedure INIT_FORMS has created an error at Step 1.

Action : Contact your system administrator quoting the procedure INIT_FORMS and Step 1.

APP-PAY-06153,System Error,Procedure INIT_FORMS at Step 1,Step 1,Oracle Appps Error,APP-PAY Error,APP PAY 06153,Oracle Administrator,Oracle Apps,Oracle Application,Oracle EBS,Oracle Apps DBA,Oracle DBA,the procedure INIT_FORMS


Solution :

Navigate : System Administrator->Profile->System

APP-PAY-06153,System Error,Procedure INIT_FORMS at Step 1,Step 1,Oracle Appps Error,APP-PAY Error,APP PAY 06153,Oracle Administrator,Oracle Apps,Oracle Application,Oracle EBS,Oracle Apps DBA,Oracle DBA,the procedure INIT_FORMS

Click find

APP-PAY-06153,System Error,Procedure INIT_FORMS at Step 1,Step 1,Oracle Appps Error,APP-PAY Error,APP PAY 06153,Oracle Administrator,Oracle Apps,Oracle Application,Oracle EBS,Oracle Apps DBA,Oracle DBA,the procedure INIT_FORMS

Assign Site: FA: Vision Operations

Save and close

Navigate:->Human Resource->Work Structure->Organization

APP-PAY-06153,System Error,Procedure INIT_FORMS at Step 1,Step 1,Oracle Appps Error,APP-PAY Error,APP PAY 06153,Oracle Administrator,Oracle Apps,Oracle Application,Oracle EBS,Oracle Apps DBA,Oracle DBA,the procedure INIT_FORMS

Form is opened

Share