Oracle Tips

=======================================================================================
pgh1914.__db_cache_size=184549376
pgh1914.__java_pool_size=4194304
pgh1914.__large_pool_size=4194304
pgh1914.__shared_pool_size=297795584
pgh1914.__streams_pool_size=8388608

*.user_dump_dest='/u02/oracle/pgh1914_rcs_prod_p01/oratrace/udump'
*.audit_file_dest='/u02/oracle/pgh1914_rcs_prod_p01/oratrace/adump'
*.control_files='/u90/oracle/pgh1914_rcs_prod_p01/oracontrol/control01.ctl','/u91/oracle/pgh1912_xem_p01/oracontrol/control02.ctl'
*.core_dump_dest='/u02/oracle/pgh1914_rcs_prod_p01/oratrace/cdump'
*.background_dump_dest='/u02/oracle/pgh1914_rcs_prod_p01/oratrace/bdump'
*.log_archive_dest_1='LOCATION=/u02/oracle/pgh1914_rcs_prod_p01/oraarch'
'
*.db_name='rcs_prod'
*.dispatchers='(PROTOCOL=TCP)(SERVICE=pgh1914)'

*.audit_trail='db_extended'
*.compatible='10.2.0.3.0'
*.db_block_size=8192
*.db_domain='ews_pgh1_dmdp1.meadwestvaco.com'
*.db_file_multiblock_read_count=16
*.filesystemio_options='setall'
*.global_names=TRUE
*.job_queue_processes=10
*.log_archive_format='arc_%S_%T_%R.log'
*.log_buffer=104857600
*.open_cursors=300
*.pga_aggregate_target=203423744
*.plsql_code_type='interpreted'
*.processes=200
*.remote_login_passwordfile='exclusive'
*.sga_target=612368384
*.undo_management='auto'
*.undo_tablespace='undotbs01'

===============================================================================================

export ORACLE_SID=pgh1914

startup nomount pfile='/u01/oracle/product/v102/dbserver/dbs/initpgh1914.ora';


CREATE DATABASE RCS_PROD
LOGFILE
GROUP 1 ('/u91/oracle/pgh1914_rcs_prod_p01/oraredo/redo0101.log','/u90/oracle/pgh1914_rcs_prod_p01/oraredomirr/redo0102.log') SIZE 100M,
GROUP 2 ('/u90/oracle/pgh1914_rcs_prod_p01/oraredo/redo0201.log','/u91/oracle/pgh1914_rcs_prod_p01/oraredomirr/redo0202.log') SIZE 100M,
GROUP 3 ('/u91/oracle/pgh1914_rcs_prod_p01/oraredo/redo0301.log','/u90/oracle/pgh1914_rcs_prod_p01/oraredomirr/redo0302.log') SIZE 100M
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 1000
MAXINSTANCES 1
MAXLOGHISTORY 292
ARCHIVELOG
CHARACTER SET AL32UTF8
NATIONAL CHARACTER SET AL16UTF16
DATAFILE
'/u914/oracle/pgh1914_rcs_prod_p01/oradata/system01.dbf' SIZE 2048M
sysaux 
datafile 
'/u914/oracle/pgh1914_rcs_prod_p01/oradata/sysaux_01.dbf' SIZE 2048M
undo tablespace undotbs01 
datafile 
'/u914/oracle/pgh1914_rcs_prod_p01/oradata/undo_01.dbf' SIZE 2048M
default temporary tablespace temp 
tempfile 
'/u914/oracle/pgh1914_rcs_prod_p01/oradata/temp_01.dbf' size 2048M;

========================================================================================
SQL> @?/rdbms/admin/catalog.sql
SQL> @?/rdbms/admin/catproc.sql
SQL> @?/rdbms/admin/utlrp.sql
========================================================================================
select name,i.instance_name from v$database,v$instance i

select name from v$database
union all
select name from v$controlfile
union all
select name from v$datafile
union all
select member from v$logfile;
select OWNER,OBJECT_NAME,OBJECT_TYPE,STATUS from dba_objects where status='INVALID';

========================================================================================
create spfile from pfile;
shutdown;
startup;
========================================================================================
Add entry in oratab
========================================================================================
change default user passwords
alter user system identified by systempwd;
alter user sys identified by syspwd;
alter user dbsnmp identified by dbsnmppwd;
alter user dbsnmp account unlock;
create user rman_backup_user identified by rmanpwd;
grant connect, resource, recovery_catalog_owner to rman_backup_user;
========================================================================================
schedule rman,export,monitoring Scripts
========================================================================================
register catalog
========================================================================================
create listener
PGH1914 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = ews-pgh1-dmdp1.meadwestvaco.com)(PORT = 5910))
  )

SID_LIST_PGH1914 =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = rcs_prod.ews_pgh1_dmdp1.meadwestvaco.com)
      (ORACLE_HOME = /u01/oracle/product/v102/dbserver)
      (SID_NAME = pgh1914)
    )
  )
========================================================================================
Create tns entry
RCS_PROD.EWS_PGH1_DMDP1.MEADWESTVACO.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ews-pgh1-dmdp1.meadwestvaco.com)(PORT = 5914))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = rcs_prod.ews_pgh1_dmdp1.meadwestvaco.com)
    )
  )
========================================================================================
Add database into Grid
========================================================================================
Check For any custom tasks

Create Tablespace ECR_DATA datafile '/u914/oracle/pgh1914_rcs_prod_p01/oradata/ecr_data_01.dbf' size 1024M autoextend on next 500M maxsize unlimited;
Create Tablespace ECR_INDEX datafile '/u914/oracle/pgh1914_rcs_prod_p01/oradata/ecr_index_01.dbf' size 1024M autoextend on next 500M maxsize unlimited;

Create Tablespace RCS_PROD_DATA datafile '/u914/oracle/pgh1914_rcs_prod_p01/oradata/RCS_PROD_DATA_01.dbf' size 1024M autoextend on next 500M maxsize unlimited;
Create Tablespace RCS_PROD_INDEX datafile '/u914/oracle/pgh1914_rcs_prod_p01/oradata/RCS_PROD_INDEX_01.dbf' size 1024M autoextend on next 500M maxsize unlimited;
========================================================================================
create user RCS_PROD identified by RCS_PROD;
grant create sequence to RCS_PROD;
grant create table to RCS_PROD;
grant create view to RCS_PROD;
grant create session TO RCS_PROD;
grant create procedure to RCS_PROD;
grant alter session to RCS_PROD;
grant select on v_$session to RCS_PROD;
grant select on v_$parameter to RCS_PROD;
grant select on v_$parameter2 to RCS_PROD;
alter user RCS_PROD default tablespace RCS_PROD_DATA;
alter user RCS_PROD quota unlimited on RCS_PROD_DATA;
alter user RCS_PROD quota unlimited on RCS_PROD_INDEX;
========================================================================================