Solved

stand by

Posted on 2013-05-26
9
354 Views
Last Modified: 2013-05-30
Two machines



mac

term2





initstand.ora is in term2



Here is the content



stand.__db_cache_size=771751936
stand.__java_pool_size=4194304
stand.__large_pool_size=4194304
stand.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
stand.__pga_aggregate_target=645922816
stand.__sga_target=1056964608
stand.__shared_io_pool_size=0
stand.__shared_pool_size=268435456
stand.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/stand/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/u01/app/oracle/oradata/stand/control01.ctl','/u01/app/oracle/flash_recovery_area/stand/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_file_name_convert='/oradata/primary','/oradata/stand'
*.db_name='primary'
*.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=4039114752
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=primaryXDB)'
*.fal_client='STAND'
*.fal_server='PRIMARY'
*.log_archive_config='dg_config=(primary,stand)'
*.log_archive_dest_1='location=/u01/app/oracle/admin/primary/arch valid_for=(all_logfiles,all_roles) db_unique_name=stand'
*.log_archive_dest_2='service=primary valid_for=(online_logfile,primary_role) db_unique_name=primary'
*.log_archive_dest_state_2='defer'
*.log_file_name_convert='/oradata/primary','/oradata/stand'
*.open_cursors=300
*.pga_aggregate_target=642777088
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=1053818880
*.standby_file_management='AUTO'
*.undo_tablespace='UNDOTBS1'
~                                                                                                                            
~                                                                                                                            
~                                  



--------------------------------------------



why it is like this



[oracle@term2 ~]$ . oraenv stand
ORACLE_SID = [stand] ? stand
The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1 is /u01/app/oracle
[oracle@term2 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Sun May 26 02:13:03 2013

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

Connected to an idle instance.

SQL> startup nomount
ORACLE instance started.

Total System Global Area  477073408 bytes
Fixed Size                  1337324 bytes
Variable Size             205522964 bytes
Database Buffers          264241152 bytes
Redo Buffers                5971968 bytes
SQL> show parameter db_name

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_name                              string      prim
SQL>



ie database name is appeared as prim



Please see in the home..



[oracle@term2 ~]$ cd $ORACLE_HOME/dbs
[oracle@term2 dbs]$ ls
hc_newdb1.dat   init.ora        orapworcl       peshm_prim_0
hc_newdb.dat    initorcl.ora    orapwprimary    peshm_stand_0
hc_orcl.dat     initstand.ora   orapwstand      spfilenewdb1.ora
hc_stand.dat    initstand.ora~  peshm_newdb_0   spfilenewdb.ora
initnewdb1.ora  lkNEWDB         peshm_NEWDB_0   spfileorcl.ora
initnewdb.ora   lkORCL          peshm_NEWDB1_0  spfilestand.ora
initnewdb.ora~  lkSTAND         peshm_orcl_0
[oracle@term2 dbs]$
0
Comment
Question by:walkerdba
  • 5
  • 3
9 Comments
 
LVL 12

Expert Comment

by:praveencpk
ID: 39198572
try to startup the database using init file i.e

SQL>startup pfile='<path>/initstand.ora' nomount

then check the DB name.
0
 

Author Comment

by:walkerdba
ID: 39198638
SQL> startup pfile=/u01/app/oracle/product/11.2.0/db_1/initstand.ora nomount
LRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0/db_1/initstand.ora'
ORA-01078: failure in processing system parameters
SQL> startup pfile='/u01/app/oracle/product/11.2.0/db_1/initstand.ora' nomount;
LRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0/db_1/initstand.ora'
ORA-01078: failure in processing system parameters
SQL>
0
 
LVL 12

Expert Comment

by:praveencpk
ID: 39198824
yeah i got it you are connecting to right database but in your initstand.ora file you have mention db_name as primary that why you are getting as prim.

i.e *.db_name='primary'
0
 

Author Comment

by:walkerdba
ID: 39199654
I changed it now it is

stand.__db_cache_size=771751936
stand.__java_pool_size=4194304
stand.__large_pool_size=4194304
stand.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
stand.__pga_aggregate_target=645922816
stand.__sga_target=1056964608
stand.__shared_io_pool_size=0
stand.__shared_pool_size=268435456
stand.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/stand/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/u01/app/oracle/oradata/stand/control01.ctl','/u01/app/oracle/flash_recovery_area/stand/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_file_name_convert='/oradata/primary','/oradata/stand'
*.db_name='stand'
*.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=4039114752
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=primaryXDB)'
*.fal_client='STAND'
*.fal_server='PRIMARY'
*.log_archive_config='dg_config=(primary,stand)'
*.log_archive_dest_1='location=/u01/app/oracle/admin/primary/arch valid_for=(all_logfiles,all_roles) db_unique_name=stand'
*.log_archive_dest_2='service=primary valid_for=(online_logfile,primary_role) db_unique_name=primary'
*.log_archive_dest_state_2='defer'
*.log_file_name_convert='/oradata/primary','/oradata/stand'
*.open_cursors=300
*.pga_aggregate_target=642777088
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=1053818880
*.standby_file_management='AUTO'
*.undo_tablespace='UNDOTBS1'


But the output is



[oracle@term2 dbs]$ . oraenv stand
ORACLE_SID = [orcl] ? stand
The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1 is /u01/app/oracle
[oracle@term2 dbs]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Mon May 27 12:31:20 2013

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

Connected to an idle instance.

SQL> startup nomount
ORACLE instance started.

Total System Global Area  477073408 bytes
Fixed Size                  1337324 bytes
Variable Size             205522964 bytes
Database Buffers          264241152 bytes
Redo Buffers                5971968 bytes
SQL> show parameter db_name

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_name                              string      prim
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 12

Expert Comment

by:praveencpk
ID: 39200304
you have changed the initstand.ora file but when you issue startup its uses the spfilestand.ora file, so the spfile is still as db_name as primary .

Once you have edited the initstand.ora file then do the startup using initstand.ora file as i stated in my first post 39198572.
0
 

Author Comment

by:walkerdba
ID: 39200490
But still..

SQL> shu abort
ORACLE instance shut down.
SQL> startup pfile='/u01/app/oracle/product/11.2.0/db_1/dbs/initstand.ora' nomount;
ORACLE instance started.

Total System Global Area  477073408 bytes
Fixed Size                  1337324 bytes
Variable Size             205522964 bytes
Database Buffers          264241152 bytes
Redo Buffers                5971968 bytes
SQL> show parameter db_name;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_name                              string      prim
SQL>
0
 
LVL 34

Accepted Solution

by:
johnsone earned 500 total points
ID: 39202151
What are you trying to accomplish?  It has been a while since I created a standby database, but as I recall you don't want to change the database name.  It has to be the same as the primary database name so you can apply the archive logs from the primary.  Changing the database name requires a reset logs which would render the archive logs useless.

The instance name can be anything you want, but the as far as I can recall, the database name must remain the same.
0
 

Author Comment

by:walkerdba
ID: 39203546
Sir,

The output expected is primary..

but why it is like this

SQL> show parameter db_name;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_name                              string      prim
SQL>

from where prim comes from?
0
 

Author Closing Comment

by:walkerdba
ID: 39209060
yes ok
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now