Posts Tagged ‘DBA’

November 15th, 2020, posted in Oracle EBS Application, Oracle Queries

“alter database mount clone database“ is a statement that forces all datafiles to be put OFFLINE when mounting the target instance. ORA-19588: archived log RECID 1003 STAMP 2001986 is no longer valid,oracle error,imam dba,dba imam,immam dba,dba immam,rman error
You’ll see it’s being used in the background when you run RMAN commands like:

“transport tablespace”
“recover tablespace .. auxiliary destination ..”
“recover table” (12c feature)

In my case, i was trying to recover an 11.2.0.4 dropped table using “Tablespace Point In Time Recovery” by following the MOS note “How to Recover From a DROP / TRUNCATE / DELETE TABLE with RMAN (Doc ID 223543.1)“. The basic steps are:

– create pfile
– restore controlfile
– mount with “alter database mount clone database;”
– restore and recover a subset of the database with an RMAN script similar to:

RMAN> connect target /
        run {
        allocate channel c1 device type DISK;
        set until time "to_date( '13-01-2016 13:50', 'DD-MM-YYYY HH24:MI')";
        set newname for datafile 1 to "+RECO";
        set newname for datafile 3 to "+RECO";
        set newname for datafile 4 to "+RECO";
        set newname for datafile 23 to "+RECO";
        restore tablespace SYSTEM, UNDOTBS01, UNDOTBS02, TOOLS;
        switch datafile all;
        sql "alter database datafile 1,3,4,23 online";
        recover database skip forever tablespace TEMP,INDX,USERS,etc.;
        sql "alter database rename file ''+RECO/xxx/onlinelog/group_1.281.739547347'' to ''+RECO''";
        sql "alter database rename file ''+RECO/xxx/onlinelog/group_2.282.739547353'' to ''+RECO''";
        sql "alter database rename file ''+RECO/xxx/onlinelog/group_3.283.739547359'' to ''+RECO''";
        sql "alter database rename file ''+RECO/xxx/onlinelog/group_4.284.739547365'' to ''+RECO''";
release channel c1;
}

After completing the required steps, recovery raised the following error:

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup

Of course i got the error when tried to open with resetlogs. After struggling with possible causes, i found an internal support note similar with my issue: “ORA-1547 After Recovery When Database Was Mounted As Clone (Doc ID 252181.1)“. The interesting part was this note was published at Oct 23, 2003 for versions 8.1.7.4 to 9.2.0.4 and the fix was:

Use the following workaround until the bug gets resolved :
Do not mount the database as CLONE as in :
SQL> alter database mount clone database;
but mount is as normal database with :
SQL> alter database mount;

But there’s no bug number stated in the note. Even i thought that mysterious bug must have been fixed many years ago, desperation made me try the workaround with mounting the instance with “alter database mount” and manually taking the required datafiles offline. Suprisingly it worked and i was able to open the database with resetlogs.

As a result, it’s fine for me that RMAN uses “mount clone database” statement internally, however when I’ll do TSPITR again you can be sure that I’ll mount the instance with the way I used to !!

read more no comments

Oracle SQL To Check Instance Clone Date

March 1st, 2020, posted in Oracle Queries

SELECT resetlogs_time FROM v$database ;

Application Short Names for Oracle Apps

September 30th, 2018, posted in Oracle

Oracle Apps – Application Short Names

APPLICATION SHORT NAME	APPLICATION NAME
FND	Application Object Library
SYSADMIN	System Administration
AU	Application Utilities
AD	Applications DBA
SQLGL	General Ledger
OFA	Assets
ALR	Alert
RG	Application Report Generator
CS	Service
EC	e-Commerce Gateway
SQLAP	Payables
PO	Purchasing
AR	Receivables
QA	Quality
CE	Cash Management
PA	Projects
AS	Sales Foundation
CN	Incentive Compensation
OE	Order Entry
INV	Inventory
AN	Sales Analysis
ODQ	Data Query
AX	Global Accounting Engine
AK	Common Modules-AK
MFG	Manufacturing
BOM	Bills of Material
ENG	Engineering
MRP	Master Scheduling/MRP
CRP	Capacity
WIP	Work in Process
CZ	Configurator
PER	Human Resources
PAY	Payroll
FF	FastFormula
DT	DateTrack
SSP	SSP
MSC	Advanced Supply Chain Planning
BEN	Advanced Benefits
OTA	Learning Management
JA	Asia/Pacific Localizations
JE	European Localizations
JG	Regional Localizations
JL	Latin America Localizations
CHV	Supplier Scheduling
ICX	Oracle iProcurement
AHM	Hosting Manager(Obsolete)
CST	Cost Management
RLA	Release Management Integration Kit (Obsolete)
VEH	Automotive Integration Kit (Obsolete)
HXT	Time and Labor
AZ	Application Implementation
PJM	Project Manufacturing
FLM	Flow Manufacturing
RHX	Advanced Planning Foundation(obsolete)
GHR	US Federal Human Resources
DEM	Demo Order Entry (AOL Class)
CLR	Culinary Application
CCT	Telephony Manager
BIS	Applications BIS
ADS	Applications Demonstration Services
CUSTOM	Custom Development
ADS_DEV	ADS Development
XTR	Treasury
PN	Property Manager
WMS	Warehouse Management
WPS	Manufacturing Scheduling
FII	Financial Intelligence
POA	Purchasing Intelligence
HRI	Human Resources Intelligence
OKC	Contracts Core
CSC	Customer Care
CSD	Depot Repair
ITA	Information Technology Audit
CDR	Oracle Clinical Data Repository
DUMMY_GMO	Obsolete Process Operations
CLJ	Japan Consulting Localizations
RRC	Retail Core
CLL	LAD Consulting Localizations
RRS	Site Management
CLE	EMEA Consulting Localizations
CSF	Field Service
CSS	Support (obsolete)
OKS	Service Contracts
ME	Controlled Availability Product(Obsolete)
BIM	Marketing Intelligence
BIC	Customer Intelligence (obsolete)
IES	Scripting
AMV	Marketing Encyclopedia System
AST	TeleSales
ASF	Sales Online
CSP	Spares Management
OKX	Contracts Integration
AMS	Marketing
XNM	Marketing for Communications (Obsolete)
XNC	Sales for Communications (Obsolete)
XNS	Service for Communications (obsolete)
XNP	Number Portability
XDP	Provisioning
FPT	Banking Center (obsolete)
IEO	Interaction Center Technology
GMA	Process Manufacturing Systems
GMI	Process Manufacturing Inventory
GMD	Process Manufacturing Product Development
GME	Process Manufacturing Process Execution
GMP	Process Manufacturing Process Planning
GMF	Process Manufacturing Financials
GML	Process Manufacturing Logistics
GR	Process Manufacturing Regulatory Management
PMI	Process Manufacturing Intelligence
XLA	Subledger Accounting
ONT	Order Management
QP	Advanced Pricing
RLM	Release Management
VEA	Automotive
WSH	Shipping Execution
IBA	iMarketing (Obsolete)
IBE	iStore
IBU	iSupport
IBY	Payments
IBP	Bill Presentment & Payment
BIL	Sales Intelligence
BIX	Interaction Center Intelligence
IEM	Email Center
OZP	Trade Planning (Obsolete)
OZF	Trade Management
OZS	iClaims (Obsolete)
ASG	CRM Gateway for Mobile Devices
JTF	CRM Foundation
IEX	Collections
IEU	Universal Work Queue
ASO	Order Capture
MSO	Constraint Based Optimization
OKE	Project Contracts
IPA	Capital Resource Logistics – Projects
CUI	Network Logistics – Inventory
CUP	Network Logistics – Purchasing
CUF	Capital Resource Logistics – Financials
CUS	Network Logistics
CUN	Network Logistics – NATS (obsolete)
CUA	Capital Resource Logistics – Assets
WSM	Shop Floor Management
SHT	Applications Shared Technology
ECX	XML Gateway
FRM	Report Manager
EAA	SEM Exchange (obsolete)
BSC	Balanced Scorecard
ABM	Activity Based Management (Obsolete)
EVM	Value Based Management
FEM	Enterprise Performance Foundation
POM	Exchange
MWA	Mobile Applications
OPI	Operations Intelligence
ISC	Supply Chain Intelligence
CSR	Scheduler
IEB	Interaction Blending
MSD	Demand Planning
HXC	Time and Labor Engine
PQH	Public Sector HR
PQP	Public Sector Payroll
PSB	Public Sector Budgeting
GMS	Grants Accounting
PSP	Labor Distribution
IGW	Grants Proposal
IGS	Student System
IGF	Financial Aid
IGC	Contract Commitment
PSA	Public Sector Financials
FV	Federal Financials
ENI	Product Intelligence
PV	Partner Management
ASL	Sales Offline
CUE	Billing Connect (obsolete)
EAM	Enterprise Asset Management
FTE	Transportation Execution
IGI	Public Sector Financials International
ITG	Internet Procurement Enterprise Connector
OKR	Contracts for Rights (Obsolete)
IPD	Product Development (obsolete)
MSR	Inventory Optimization
PRGC	Progress Custom
POS	iSupplier Portal
BNE	Web Applications Desktop Integrator
ASP	Oracle Sales for Handhelds
BIV	Service Intelligence
CSI	Install Base
CSL	Field Service/Laptop
CUG	Citizen Interaction Center
IMT	iMeeting (obsolete)
OKI	Contracts Intelligence
IEC	Advanced Outbound Telephony
CSE	Asset Tracking
OKO	Contracts for Sales (Obsolete)
JTS	CRM Self Service Administration
JTM	Mobile Application Foundation
AHL	Complex Maintenance Repair and Overhaul
IMC	Customers Online
OKB	Contracts for Subscriptions (Obsolete)
XNI	Install Base Intelligence (Obsolete)
QRM	Risk Management
PON	Sourcing
OKL	Lease and Finance Management
IBC	Content Manager
AMF	Fulfillment Services (Obsolete)
QOT	Quoting
CSM	Field Service/Palm
DOM	Document Managment and Collaboration
EGO	Advanced Product Catalog
DDD	CADView-3D
PJI	Project Intelligence
XNB	Oracle Telecommunications Billing Integrator
ZFA	Financial Analyzer
ZSA	Sales Analyzer
CLN	Supply Chain Trading Connector for RosettaNet
EDR	E-Records
PRP	Proposals
OUC	University Curriculum
TEST	test
PSR	Public Sector Receivables
CSN	Call Center
CLA	APAC Consulting Localizations
AMW	Internal Controls Manager
XDO	XML Publisher
WMA	Manufacturing Mobile Applications
ISX	iSettlement
MIV	Media Interactive
OAM	Oracle Applications Manager
BIE	eCommerce Intelligence
BIN	Communications Intelligence
CUC	Revenue Accounting
CUR	Mass Market Receivables for Comms
IBT	iAuction
XNA	Service Assurance for Communications
XNT	TeleBusiness for Telecom/Utilities
MQA	Mobile Quality Applications
CTB	Clinical Transaction Base
IET	Call Center Connectors
IEV	IVR Integrator
IEP	Predictive
HCP	Healthcare Intelligence
HCA	Healthcare
PBR	Budgeting and Planning
IAM	Digital Asset Management
OKT	Royalty Management
GNI	Genealogy Intelligence
CPGC	CPG – CDOA
HCC	iHCConnect
HCN	iHCIntegrate
AME	Approvals Management
OKP	Contracts for Procurement (Obsolete)
HCT	Healthcare Terminology Server
MIA	Mobile Applications for Inventory Management
GMW	Process Manufacturing Portal
BIY	Systems Intelligence
PFT	Oracle Profitability Manager
RMG	Risk Manager
FTP	Transfer Pricing
DNA	Development
BLC	Utility Billing
PTX	Patch Tracking System
EMS	Environment Management System
RCM	Regulatory Capital Manager (obsolete)
JMF	Supply Chain Localizations
IRC	iRecruitment
GMO	Manufacturing Execution System for Process Manufacturing
IPM	Oracle Imaging Process Management
IBW	Oracle Web Analytics
XLE	Legal Entity Configurator
ASN	Sales
MST	Transportation Planning
FUN	Financials Common Modules
GCS	Financial Consolidation Hub
ZX	E-Business Tax
LNS	Loans
IA	iAssets
FPA	Project Portfolio Analysis
ZPB	Enterprise Planning and Budgeting
BANKING	Banking
COREBANK	Core Banking
INSTITBANK	Institutional Banking
IZU	Oracle E-Business Suite Diagnostics
DPP	Oracle Price Protection
MTH	Oracle Manufacturing Operations Center
QPR	Oracle Deal Management
DDR	Demand Signal Repository
INL	Oracle Landed Cost Management

read more no comments

Select Number And Convert Number From English To Arabic In Oracle

April 23rd, 2018, posted in Oracle Queries

CREATE FUNCTION numToEasternArabic(
  in_value IN NUMBER
) RETURN NVARCHAR2 DETERMINISTIC
IS
  p_num  VARCHAR2(100) := TO_CHAR( in_value );
  p_char CHAR(1);
  o_str  NVARCHAR2(100);
BEGIN
  FOR i IN 1 .. LENGTH( p_num ) LOOP
    p_char := SUBSTR( p_num, i, 1 );
    o_str := o_str
          || CASE p_char
             WHEN '.'
             THEN N'.'
             ELSE UNISTR(
                    '\' || TO_CHAR(
                             TO_NUMBER( p_char ) + 660,
                             'FM0000'
                           )
                  )
             END;
  END LOOP;
  RETURN o_str;
END;
/

Query 1:

SELECT numToEasternArabic( 1438 )
FROM   DUAL

Results:

| NUMTOEASTERNARABIC(1438) |
|--------------------------|
|                     ١٤٣٨ |

read more no comments

How to manually mount CD-DVD-ROM in Solaris

March 3rd, 2018, posted in Solaris

Add A User From The Command Line In Solaris,Add A User From The Command Line In Solaris 10,Add A User From The Command Line, In Solaris10 ,Add A User ,The Command Line In Solaris10,The Command Line In Solaris,solaris 10,

Recently while trying to build a Solaris JumpStart server, I encountered an error in reading the home-burnt DVD-ROM disk of Solaris 10 10/08. There are many threads out on the internet that talk about the same difficulty and issue. To circumvent the issue, I needed to manually mount the DVD-ROM. To do this, you first need to disable the volmgmt software in Solaris. Since I am running Solaris 10, the command is simple:

# svcadm disable volfs
# svcs volfs
STATE          STIME    FMRI
disabled        7:29:01 svc:/system/filesystem/volfs:default
# ps -ef |grep vol
    root 10189   936   0 07:26:10 pts/1       0:00 grep vol

Once that is done, you should be able to mount the DVD-ROM using the following command:

# mount -F hsfs -o ro /dev/sr0 /cdrom
# cd /cdrom
# ls
Copyright                    License                      boot                         platform
JDS-THIRDPARTYLICENSEREADME  Solaris_10                   installer

Once done, don’t forget to re-enable volume management. That is done by:

# svcadm enable volfs
# svcs volfs
STATE          STIME    FMRI
online          8:33:21 svc:/system/filesystem/volfs:default

read more no comments

« Older Entries

Newer Entries »

POiSON WORLD

Posts Tagged ‘DBA’

TSPITR Issue By Doing Mount Clone Database

Oracle SQL To Check Instance Clone Date

SELECT resetlogs_time FROM v$database ;

Application Short Names for Oracle Apps

Oracle Apps – Application Short Names

Select Number And Convert Number From English To Arabic In Oracle

How to manually mount CD-DVD-ROM in Solaris

Follow Me On Social Networks :

Recent Posts

Recent Comments

Categories

Archives

Share It With Others :

POiSON WORLD

Posts Tagged ‘DBA’

TSPITR Issue By Doing Mount Clone Database

Oracle SQL To Check Instance Clone Date

SELECT resetlogs_time FROM v$database ;

Application Short Names for Oracle Apps

Oracle Apps – Application Short Names

Select Number And Convert Number From English To Arabic In Oracle

How to manually mount CD-DVD-ROM in Solaris

Follow Me On Social Networks :

Recent Posts

Recent Comments

Categories

Archives

Tags

Share It With Others :