Oracle 11g location of old type alert_orcl.log file

sqlplus system/sys@orcl

SQL*Plus: Release 11.2.0.1.0 Production on Mon May 16 16:01:50 2011

Copyright (c) 1982, 2009, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> show parameter diag

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
diagnostic_dest string /opt/app/oracle
SQL> !pwd
/opt/app/oracle/diag/rdbms/orcl/orcl/trace

SQL> !ls -ltr alert_orcl.log
-rw-r----- 1 oracle oinstall 48551528 2011-05-16 02:50 alert_orcl.log

SQL>

Trace for tnsping ---------------------

TNSNAMES.ORA



strace -f -o tnsping.trc tnsping anuj

How to Install Oracle In silent mode

oracle installation silent mode

First complete Oracle prerequisite system parameter rpm,user group etc.


Your will get rsp file from following location

oracle@apt-amd-02:~/database/response> pwd
/home/oracle/database/response


you will get this file form

oracle@apt-amd-02:~/database/response> ls -ltr
total 268
-rw-r--r-- 1 root root 88279 2008-10-06 09:35 standard.rsp
-rw-r--r-- 1 root root 5743 2008-10-06 09:35 netca.rsp
-rw-r--r-- 1 root root 88298 2008-10-06 09:35 enterprise.rsp
-rw-r--r-- 1 root root 48199 2008-10-06 09:35 dbca.rsp
-rw-r--r-- 1 root root 26205 2008-10-06 09:35 custom.rsp

take the backup of this file enterprise.rsp
oracle@apt-amd-02:~/database/response> cp enterprise.rsp enterprise.rsp.orig

then edit this file enterprise.rsp

and change following value
=====================================
UNIX_GROUP_NAME=oinstall
FROM_LOCATION="/products.xml"
ORACLE_HOME=/home/oracle/product/11.2/DB
ORACLE_BASE=/apps/oracle
ORACLE_HOME_NAME=orcl
n_configurationOption=3
=====================================


n_configurationOption = 1 to create the database
= 2 to configure a ASM
= 3 install the software only



./runInstaller -ignoreSysPrereqs -force -silent -responseFile /enterprise.rsp

- force allows to install into nonempty directory




Starting Oracle Universal Installer...
...............

skipped ....

Installation in progress (Thu May 15 23:54:45 IST 2008)
............................................................... 18% Done.
............................................................... 36% Done.
............................................................... 54% Done.
............................................................... 73% Done.
............ 76% Done.
Install successful

Linking in progress (Thu May 15 23:59:36 IST 2008)
Link successful

Setup in progress (Fri May 16 00:06:30 IST 2008)
.............. 100% Done.
Setup successful

The following configuration scripts
/home/oracle/product/11.2/DB/root.sh

need to be executed as root for configuring the system. If you skip the execution of the configuration tools,the configuration will not be complete and the product wont function properly. In order to get the product to function properly, you will be required to execute the scripts and the configuration tools after exiting the OUI.


Then create database manually .

===========

create database manually

sample to create database manually

init_ora53old.txt file

change your parameter accordingly .


ora53old.__db_cache_size=2231369728
ora53old.__java_pool_size=16777216
ora53old.__large_pool_size=16777216
ora53old.__shared_pool_size=318767104
ora53old.__streams_pool_size=33554432
*.db_name='ora53old'
*.db_domain=''
*.core_dump_dest='/opt/oracle/admin/ora53old/cdump'
*.user_dump_dest='/opt/oracle/admin/ora53old/udump'
*.audit_file_dest='/opt/oracle/admin/ora53old/adump'
*.background_dump_dest='/opt/oracle/admin/ora53old/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/opt/oracle/oradata/ora53old/control01.ctl','/opt/oracle/oradata/ora53old/control02.ctl','/opt/oracle/oradata/ora53old/control03.ctl'
*.db_block_size=8192
*.db_file_multiblock_read_count=16
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
*.job_queue_processes=10
*.open_cursors=300
*.pga_aggregate_target=418381824
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=2621440000
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'

-bash-3.00$ cat v
export ORACLE_SID=ora53
export ORACLE_SID=ora53old
export ORACLE_SID=CCCUAT65
-bash-3.00$ ls -lt init*


-bash-3.00$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Thu Nov 26 11:20:13 2009

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to an idle instance.

SYS AS SYSDBA>startup nomount pfile='/export/home/oracle/init_ora53old.txt' ;

ORACLE instance started.


CREATE DATABASE "ora53old"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE '/opt/oracle/oradata/ora53old/system01.dbf' SIZE 300M REUSE
AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/opt/oracle/oradata/ora53old/sysaux01.dbf' SIZE 120M
REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE
'/opt/oracle/oradata/ora53old/temp01.dbf' SIZE 20M REUSE AUTOEXTEND ON
NEXT 640K MAXSIZE UNLIMITED
SMALLFILE UNDO TABLESPACE "UNDOTBS1" DATAFILE
'/opt/oracle/oradata/ora53old/undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND
ON NEXT 5120K MAXSIZE UNLIMITED
CHARACTER SET WE8ISO8859P1
NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 ('/opt/oracle/oradata/ora53old/redo01.log') SIZE 51200K,
GROUP 2 ('/opt/oracle/oradata/ora53old/redo02.log') SIZE 51200K,
GROUP 3 ('/opt/oracle/oradata/ora53old/redo03.log') SIZE 51200K
USER SYS IDENTIFIED BY "sys" USER SYSTEM IDENTIFIED BY "sys";


spool instance name.log

SQL> @?/rdbms/admin/catalog.sql
SQL> @?/rdbms/admin/catproc.sql
@?/rdbms/admin/utlrp

for jvm

$ORACLE_HOME/javavm/install/initjvm.sql

for xml


$ORACLE_HOME/xdk/admin/initxml.sql for xml


#

====


#

inter Media

Verify that Oracle JVM is installed and is valid.

You can verify that Oracle JVM is correctly installed by running
SQL*Plus, connecting as SYSDBA, and issuing the following query:

SQL> select version, status from dba_registry where comp_id='JAVAVM';



Ensure that the version is correct and the status is VALID.







SQL> connect SYS/password as SYSDBA
SQL> spool text_install.txt
SQL> @?/ctx/admin/catctx.sql CTXSYS SYSAUX TEMP NOLOCK

Where:
CTXSYS - is the ctxsys user password
SYSAUX - is the default tablespace for ctxsys
TEMP - is the temporary tablespace for ctxsys
LOCK|NOLOCK - ctxsys user account will be locked or not


connect CTXSYS/ctxsys



------------------- cut here ------------------------------
connect SYS/password as SYSDBA

set pages 1000
col object_name format a40
col object_type format a20
col comp_name format a30
column library_name format a8
column file_spec format a60 wrap
spool text_install_verification.log

-- check on setup
select comp_name, status, substr(version,1,10) as version from
dba_registry where comp_id = 'CONTEXT';
select * from ctxsys.ctx_version;
select substr(ctxsys.dri_version,1,10) VER_CODE from dual;

select count(*) from dba_objects where owner='CTXSYS';

-- Get a summary count
select object_type, count(*) from dba_objects where owner='CTXSYS' group
by object_type;

-- Any invalid objects
select object_name, object_type, status from dba_objects where
owner='CTXSYS' and status != 'VALID' order by object_name;

spool off
------------------- cut here ------------------------------


/opt/oracle/oradata/ora53old/

Create tablespace DM_CCCUAT2_DOCBASE datafile
'/opt/oracle/oradata/ora53old/dm_cccuat2_docbase01.dbf' size 4g
autoextend on next 100M maxsize unlimited extent management local
segment space management auto;


Create tablespace DM_CCCUAT2_DOCBASE datafile
'/opt/oracle/oradata/ora53old/dm_cccuat2_docbase01.dbf' size 4g
autoextend on next 100M maxsize unlimited extent management local
segment space management auto;

Create tablespace DM_CCCUAT2_index datafile
'/opt/oracle/oradata/ora53old/dm_cccuat2_index' size 3g
autoextend on next 100M maxsize unlimited extent management local
segment space management auto;
;

SYS AS SYSDBA>create user cccuat2 identifed by cccuat2 ;
create user cccuat2 identifed by cccuat2
*
ERROR at line 1:
ORA-00922: missing or invalid option


SYS AS SYSDBA>create user cccuat2 identified by cccuat2 ;

User created.

SYS AS SYSDBA>alter user cccuat2 default tablespace DM_CCCUAT2_DOCBASE ;

User altered.

SYS AS SYSDBA>grant connect,resource to cccuat2;

Grant succeeded.

create directory expdp_dir as '/opt/oracle/'

grant read,write on directory expdp_dir to system,cccuat2


CCCUAT2_pump.dmp


impdp cccuat2/cccuat2 DIRECTORY=expdp_dir DUMPFILE=CCCUAT2_pump.dmp SCHEMAS=cccuat2 TABLE_EXISTS_ACTION=REPLACE

impdp " '/ as sysdba'" DIRECTORY=expdp_dir DUMPFILE=CCCUAT2_pump.dmp SCHEMAS=cccuat2 TABLE_EXISTS_ACTION=REPLACE LOGFILE=ora53old.log