04-24-2013
Hi Hanson44,
One issue I still face while executing the script is:
initqa.ora file shows the prod sid name instead of the qa name which is incorrect
Code :
-bash-3.2$ ./compare_two_initoras.sh initprod.ora.14thjan initqa.ora
*._gc_undo_affinity=false=*._gc_undo_affinity=false - initprod.ora.14thjan
*._gc_undo_affinity=false= - initqa.ora
---------------------------------------------------
*.audit_file_dest='?/rdbms/audit'=*.audit_file_dest='?/rdbms/audit' - initprod.ora.14thjan
*.audit_file_dest='?/rdbms/audit'= - initqa.ora
---------------------------------------------------
*.audit_trail='OS'=*.audit_trail='OS' - initprod.ora.14thjan
*.audit_trail='OS'= - initqa.ora
---------------------------------------------------
*.cluster_database=TRUE=*.cluster_database=TRUE - initprod.ora.14thjan
*.cluster_database=TRUE= - initqa.ora
---------------------------------------------------
*.control_files='/prod/oradata/data02/cntrl01.ctl','/prod/oradata/data03/cntrl02.ctl','/prod/oradata/data01/cntrl03.ctl'=*.control_files='/prod/oradata/data02/cntrl01.ctl','/prod/oradata/data03/cntrl02.ctl','/prod/oradata/data01/cntrl03.ctl' - initprod.ora.14thjan
*.control_files='/prod/oradata/data02/cntrl01.ctl','/prod/oradata/data03/cntrl02.ctl','/prod/oradata/data01/cntrl03.ctl'= - initqa.ora
---------------------------------------------------
*.db_cache_advice='ON'=*.db_cache_advice='ON' - initprod.ora.14thjan
*.db_cache_advice='ON'= - initqa.ora
---------------------------------------------------
*.db_cache_size=118111664=*.db_cache_size=118111664 - initprod.ora.14thjan
*.db_cache_size=118111664= - initqa.ora
---------------------------------------------------
*.db_files=1256=*.db_files=1256 - initprod.ora.14thjan
*.db_files=1256= - initqa.ora
---------------------------------------------------
*.db_name='prod'=*.db_name='prod' - initprod.ora.14thjan
*.db_name='prod'= - initqa.ora
---------------------------------------------------
*.db_writer_processes=32=*.db_writer_processes=32 - initprod.ora.14thjan
*.db_writer_processes=32= - initqa.ora
---------------------------------------------------
*.diagnostic_dest='/prod/log'=*.diagnostic_dest='/prod/log' - initprod.ora.14thjan
*.diagnostic_dest='/prod/log'= - initqa.ora
---------------------------------------------------
prod1.instance_number=1=prod1.instance_number=1 - initprod.ora.14thjan
prod1.instance_number=1= - initqa.ora
---------------------------------------------------
prod2.instance_number=2=prod2.instance_number=2 - initprod.ora.14thjan
prod2.instance_number=2= - initqa.ora
---------------------------------------------------
*.java_pool_size=1448699711=*.java_pool_size=1448699711 - initprod.ora.14thjan
*.java_pool_size=1448699711= - initqa.ora
---------------------------------------------------
*.local_listener=''=*.local_listener='' - initprod.ora.14thjan
*.local_listener=''= - initqa.ora
---------------------------------------------------
prod2.local_listener='prod2'=prod2.local_listener='prod2' - initprod.ora.14thjan
prod2.local_listener='prod2'= - initqa.ora
---------------------------------------------------
prod1.local_listener='prod1'=prod1.local_listener='prod1' - initprod.ora.14thjan
prod1.local_listener='prod1'= - initqa.ora
---------------------------------------------------
*.log_archive_dest='/prod/arch'=*.log_archive_dest='/prod/arch' - initprod.ora.14thjan
*.log_archive_dest='/prod/arch'= - initqa.ora
---------------------------------------------------
*.log_archive_format='prod_%t_%s_%r.arc'=*.log_archive_format='prod_%t_%s_%r.arc' - initprod.ora.14thjan
*.log_archive_format='prod_%t_%s_%r.arc'= - initqa.ora
---------------------------------------------------
*.log_archive_max_processes=2=*.log_archive_max_processes=2 - initprod.ora.14thjan
*.log_archive_max_processes=2= - initqa.ora
---------------------------------------------------
*.log_buffer=33554432=*.log_buffer=33554432 - initprod.ora.14thjan
*.log_buffer=33554432= - initqa.ora
---------------------------------------------------
*.open_cursors=500=*.open_cursors=500 - initprod.ora.14thjan
*.open_cursors=500= - initqa.ora
---------------------------------------------------
*.parallel_max_servers=32=*.parallel_max_servers=32 - initprod.ora.14thjan
*.parallel_max_servers=32= - initqa.ora
---------------------------------------------------
*.parallel_min_servers=31=*.parallel_min_servers=31 - initprod.ora.14thjan
*.parallel_min_servers=31= - initqa.ora
---------------------------------------------------
*.processes=15219=*.processes=15219 - initprod.ora.14thjan
*.processes=15219= - initqa.ora
---------------------------------------------------
*.recovery_parallelism=31=*.recovery_parallelism=31 - initprod.ora.14thjan
*.recovery_parallelism=31= - initqa.ora
---------------------------------------------------
*.recyclebin='off'=*.recyclebin='off' - initprod.ora.14thjan
*.recyclebin='off'= - initqa.ora
---------------------------------------------------
prod1.remote_listener='prod_REMOTE'=prod1.remote_listener='prod_REMOTE' - initprod.ora.14thjan
prod1.remote_listener='prod_REMOTE'= - initqa.ora
---------------------------------------------------
prod2.remote_listener='prod_REMOTE'=prod2.remote_listener='prod_REMOTE' - initprod.ora.14thjan
prod2.remote_listener='prod_REMOTE'= - initqa.ora
---------------------------------------------------
*.sessions=30439=*.sessions=30439 - initprod.ora.14thjan
*.sessions=30439= - initqa.ora
---------------------------------------------------
*.shared_pool_reserved_size=3186517606=*.shared_pool_reserved_size=3186517606 - initprod.ora.14thjan
*.shared_pool_reserved_size=3186517606= - initqa.ora
---------------------------------------------------
*.shared_pool_size=31865176064=*.shared_pool_size=31865176064 - initprod.ora.14thjan
*.shared_pool_size=31865176064= - initqa.ora
---------------------------------------------------
prod1.thread=1=prod1.thread=1 - initprod.ora.14thjan
prod1.thread=1= - initqa.ora
---------------------------------------------------
prod2.thread=2=prod2.thread=2 - initprod.ora.14thjan
prod2.thread=2= - initqa.ora
---------------------------------------------------
prod1.undo_tablespace='APPS_UNDOTS1'=prod1.undo_tablespace='APPS_UNDOTS1' - initprod.ora.14thjan
prod1.undo_tablespace='APPS_UNDOTS1'= - initqa.ora
---------------------------------------------------
prod2.undo_tablespace='UNDOTBS2'=prod2.undo_tablespace='UNDOTBS2' - initprod.ora.14thjan
prod2.undo_tablespace='UNDOTBS2'= - initqa.ora
---------------------------------------------------
*.utl_file_dir='/prod/oratmp','/prod/applcsf/tmp','/prod/applcsf/log','/prod/applcsf/out','/kbrt/share/prod','/prod/oracle/product/112/appsutil/outbound/prod_host','/usr/tmp'=*.utl_file_dir='/prod/oratmp','/prod/applcsf/tmp','/prod/applcsf/log','/prod/applcsf/out','/kbrt/share/prod','/prod/oracle/product/112/appsutil/outbound/prod_host','/usr/tmp' - initprod.ora.14thjan
*.utl_file_dir='/prod/oratmp','/prod/applcsf/tmp','/prod/applcsf/log','/prod/applcsf/out','/kbrt/share/prod','/prod/oracle/product/112/appsutil/outbound/prod_host','/usr/tmp'= - initqa.ora
---------------------------------------------------
-bash-3.2$
Any ideas please?
Thanks,
a1_win
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
hi there
i write one awk script file in shell programing
the code is related to dd/mm/yy to month, day year format
but i get an error
please can anybody help me out in this problem ??????
i give my code here including error
awk `
# date-month -- convert mm/dd/yy to month day,... (2 Replies)
Discussion started by: Herry
2 Replies
2. UNIX for Dummies Questions & Answers
Hello,
I apologize if this was addressed in a previous post. I have done some searching but may have missed it. I am trying to read a list from a file, for example:
3bik
3bix
3biu
3bin
1nwn
and using this list, copy files with these names (ex: 3bik.dssp.Z) to a seperate folder,... (1 Reply)
Discussion started by: InfoSeeker
1 Replies
3. Shell Programming and Scripting
Hi All,
I have written a korn script (code pasted below). It is giving the error while debugging "new.sh: syntax error at line 62: `end of file' unexpected".
I have re-written the whole code in VI and explored all help related to this error on this Unix forum and tried it. Somehow, I could... (7 Replies)
Discussion started by: schandrakar1
7 Replies
4. Shell Programming and Scripting
hello everyone
i am beginner on shell scripting .and i am working on my project work on ad hoc network
i wrote a batch (.sh) to do a looping and execute a tcl script i wrote before in each iteration ..but i got this problem "
syntax error near unexpected token `('... (1 Reply)
Discussion started by: marcoss90
1 Replies
5. Shell Programming and Scripting
I am trying to run a unix script in my home directory.Snippet below
echo "`date '+%Y%m%d_%H%M%S'` Getting ProductList.dat"
if ( -f $DIR/ProductList.dat) then
cp $DIR/ProductList.dat MigratedProductList.dat
else
echo "`date '+%Y%m%d_%H%M%S'`ProductList.dat does not exist; Processing... (4 Replies)
Discussion started by: Mary James
4 Replies
6. Shell Programming and Scripting
I am creating a shell script. In which, I need to get server name and server IP. I used this command in script.
servername=`cat /etc/hosts|grep `eval hostname`|awk '{print $2}'`
however, when execute script or put set -x to debug, it return:
line 13: syntax error at line 13: `|' unexpected... (4 Replies)
Discussion started by: duke0001
4 Replies
7. HP-UX
Hi All,
We are getting a very unique error while running a shell script on HP-UX box.
Can somebody help in this regards?
The shell script is working fine on linux/solaris box.
Error:
++++++++++++++++++++++++
$/test.sh
./test.sh: 0^J30: Syntax error
$
++++++++++++++++++++++++
TIA.... (16 Replies)
Discussion started by: vai_sh
16 Replies
8. Shell Programming and Scripting
Hi,
I wrote this shell script to be a tool for my team to do daily routine works.
Though, option a and b are working fine, option c is giving below error.
line 647: syntax error near unexpected token `else'
line 647: `else'
Here s my script. A bit lengthy though. Pls excuse.
Also,... (3 Replies)
Discussion started by: Naga06
3 Replies
9. Shell Programming and Scripting
I have one bash shell script to execute table refreshment. At the bottom of script, I have one piece of code to check 'ORA-' error from log file, then send email to DBA or application people. But this piece of code didn't work. I tried different ways and also search online to find where is my... (2 Replies)
Discussion started by: duke0001
2 Replies
10. UNIX for Beginners Questions & Answers
Hello,
I have a newbe syntax error but I cant find it
syntax error: unexpected end of file
#!/bin/csh
# pe request
#$ -pe mpi_16 32
#### 16 core : 'mpi_16 16' || 24 core : 'mpi_24 24 '
# our Job name
#$ -N test2MD
#$ -S /bin/sh (1 Reply)
Discussion started by: dulceC
1 Replies