Password Management in oracle ebs R12.X (FNDCPASS / AFPASSWD)
Password Management in Oracle EBS R12.XThere are two different utilities being use in oracle ebs R12.x 1- FNDCPASS - password passes on command line2- AFPASSWD - Provide more securi...
Read morePractice SQL with Sample Tables
CREATE
TABLE "AGENTS"
(
"AGENT_CODE" CHAR(6) NOT NULL PRIMARY KEY,
"AGENT_NAME" CHAR(40),
"WORKING_AREA" CHAR(35),
"COMMISSION" NUMBER(10,2),
...
Read more
Set FRA in Oracle RAC Database
Setting Fast Recovery Area (FRA) and Enabling archive log in Oracle RAC Database
aSS
1- Check the database status: srvctl status database -d ORCL
Instance ORCL1 is running on node rac-node1
Instance ORCL2 is running on node rac-node2
2- Create arch directory in ASM disk location (+DATA)
$ asmcmd
asmcmd> lsdg
asmcmd> cd +DATA
asmcmd> mkdir arch
3- If database is up then...
Read moreSetting Up FRA in Oracle Database
To enable the flash recovery area(FRA), you must set the two initialization parameters DB_RECOVERY_FILE_DEST_SIZE (which specifies the disk quota, or maximum space to use for flash recovery area files for this database) and
DB_RECOVERY_FILE_DEST (which specifies the location of the flash recovery area).
Note:
DB_RECOVERY_FILE_DEST_SIZE must be set before DB_RECOVERY_FILE_DEST...
Read more
Subscribe to:
Posts
(
Atom
)
