Blog article describes the procedure to add datafiles to Oracle database using BRtools.
While performing Oracle patch operation, we received error as:The Central Inventory is corrupted,The oraInst.loc file specified is not valid.
In this article we will focus on how to perform Oracle Index rebuilding using BRtools in SAP.
NLS_DATE_FORMAT is one of the initialization parameter in Oracle which defines default date format to use with the TO_CHAR and TO_DATE functions.
In this article we will discuss how to set the NLS_DATE_FORMAT Parameter In Oracle
Article describes how to unlock SAP user without using traditional way of unlocking SAP* user with database restart.
This will reduce the efforts with no downtime.
Article describes how we can use Oracle recovery manager i.e RMAN to check the consistency of various Oracle database objects.
During oracle startup,R3trans-d throws with error :
2EETW169 no connect possible: “DBMS = ORACLE— dbs_ora_tnsname
we will discuss how to rectify this error.