Database creation

Manual Database Creation in 10g:

step 1: create Directory structure.

mkdir -p /apps/prod/oradata
mkdir -p /apps/prod/admin/{arch,scripts,network,bdump,cdump,udump}

step2: Give the permissions.

chown -R oracle:dba /apps/prod
chmod -R 777 /apps/prod

Step3: export variables

export ORACLE_HOME=/apps/oracle/product/10.2.0
export PATH=$ORACLE_HOME/bin:$PATH
export LD_ASSUME_PATH=$ORACLE_HOME/lib:$PATH

export TNS_ADMIN=/apps/prod/admin/network
export ORACLE_SID=prod

Step4: create parameter file

[oracle@ravi ~]$ cd $ORACLE_HOME/dbs
[oracle@ravi dbs]$ vi initprod.ora

prod.__db_cache_size=369098752
prod.__java_pool_size=4194304
prod.__large_pool_size=4194304
prod.__shared_pool_size=142606336
prod.__streams_pool_size=0
*.background_dump_dest='/apps/prod/admin/bdump'
*.compatible='10.2.0'
*.control_files='/apps/prod/oradata/control01.ctl'
*.core_dump_dest='/apps/prod/admin/cdump'
*.db_block_size=4096
*.db_name='prod'
*.log_archive_dest='/apps/prod/admin/arch'
*.log_archive_format='redo_%s_%r_%t.arc'
*.sga_target=500M
*.undo_management='auto'
*.undo_tablespace='undotbs'
*.user_dump_dest='/apps/prod/admin/udump'


Step5: start the database in nomount state.

SQL> STARTUP NOMOUNT

Step6: create database creation script.

create database prod
datafile '/apps/prod/oradata/system01.dbf' size 300M
sysaux datafile '/apps/prod/oradata/sysaux01.dbf' size 200m
undo tablespace undotbs datafile '/apps/prod/oradata/undotbs01.dbf' size 100m
default temporary tablespace temp tempfile '/apps/prod/oradata/temp01.dbf' size 100m
default tablespace userdata datafile '/apps/prod/oradata/userdata01.dbf' size 400m
logfile
group 1 '/apps/prod/oradata/redo1a.log' size 30m,
group 2 '/apps/prod/oradata/redo2a.log' size 30m
character set UTF8;
~                          

Step6: run the post scripts like

@?/rdbms/admin/catalog.sql  ------> create Indexes
@?/rdbms/admin/catproc.sql ------> packages are create
connect system/manager
@?/sqlplus/admin/pupbld.sql

Note: by using OMF (oracle Managed files) doesn't create directories manually automatically create those locations will be write in p-file.

                                db_create_file_dest ---> to specify the CRD files.

Reasions for DB creation errors:

1. If physical files are not there.
2. Database is Inconsistent.

Errors:

ora-01092- signalled during: alter database open...

Sol: check Undo_tablespace prameter and undo tablespace names are same or not.

change logo in Oracle login page

1. Change the FNDSSCORP.gif file.

• Make a backup copy of the FNDSSCORP.gif file.  Name it FNDSSCORP.bak
• Make the name of the custom logo FNDSSCORP.gif
• Upload the new FNDSSCORP.gif file to the $OA_MEDIA directory

Log out and log back into the application

OR

2.  copy the image file to $OA_MEDIA directory.

• Navigate to the System Administrator - Profile -System
• enter the Profile option name  "Corporate Branding Image for Oracle Applications".
• enter your logo name.

DMZ

Demilitarized Zones (DMZ):-

By using this Oracle E-business suite functionality accessible via the Internet to external users.

DMZ Configuration options are supported:

• Use of separate web node for external usage.
• Setting of server level profile values.
• Associating trust levels to application middle tier nodes.
• Limiting available responsibilities to a restricted set for the external web node.
• Deploying a reverse proxy in front of the external web node.
• Configuring a URL firewall and mod security in the reverse proxy.
• Running only essential Oracle E-Business Suite Application services on the external web tier.

Reverse Proxy: It is an intermediate server that sits between a client and the actual web server and makes requests to the web server on behalf of the client.

Restrictions for DMZ:

1. APPL_TOP,COMMON_TOP,ORA_TOP cannot be shared between external web tier and Internal middle tier.
2. 
   

Scenarios

Scenarios:

1.      How to identify sql text for running Concurrent Program from backend?

2.      Navigate to Concurrent-Program-define screen & find out the FMX, identify the OS level?

3.      Submit Active user program save the output in Desktop?

4.      Schedule Active Responsibilities program for every one hour?

5.      Change the Standard Manager process to 5?

6.      Increase Active Responsibilities program priority to 10?

7.      Submit Gather Schema Statistics program find out the sid,query of the  program & kill the program at OS level?

8.      Create a user with name Demo assign following responsibilities 

System Administrator

XML publisher

Workflow Admininistrator and set password expire to 90 Days?

9.      Write a query to find out how many of users are having system Administrator Responsibilites?

10.  Identify the .rdf location of Active Responsibilites?

11.  Submit Active User program with print option & locate log & out at OS level?

12.  Check the file version of o2fvaens.pls?

13.  Regenerate the executable of GLPPOS?

14.  Navigate to Security-User-Define screen identify the .fmx, take the backup of it and recreate the .fmx?

15.  Regenerate the custom.pll file?

16.  Take the backup of sqlplus file and regenerate it?

$ORACLE_HOME/sqlplus/lib

make –f ins_sqlplus.mk install



17. How to validate the dbc file?
[applravi@ravi secure]$ java oracle.apps.fnd.security.AdminAppServer apps/apps status DBC=/u01/applravi/inst/apps/ravi_ravi/appl/fnd/12.0.0/secure/ravi.dbc

Database Server
---------------
DATABASE_ID: ravi
AUTHENTICATION: SECURE

Application Server
------------------
APPL_SERVER_STATUS: VALID
APPL_SERVER_ID: DF6B5C00F62630FBE040007F0100047928839603012886011864145370676912

[applravi@ravi secure]$