Home » Server Options » Data Guard » Difficulties in configuring Data Guard environment
Difficulties in configuring Data Guard environment [message #582574] Fri, 19 April 2013 09:10 Go to next message
ramanujam.y@gmail.com
Messages: 5
Registered: April 2013
Location: India
Junior Member
HI,

I am new to DBA. i am trying to setup a datagaurd environment. but i am facing some difficulties in configuring. can some one please help me to achieve this datagaurd configuration.

My primary database name is ourdb and stand by is oursby
steps i followed,
ourdb:-
pfile
[oracle@oracle10g dbs]$ cat initourdb.ora
ourdb.__db_cache_size=96468992
ourdb.__java_pool_size=4194304
ourdb.__large_pool_size=4194304
ourdb.__shared_pool_size=54525952
ourdb.__streams_pool_size=4194304
*.audit_file_dest='/u01/app/oracle/product/10.2.0/db_1/admin/ourdb/adump'
*.background_dump_dest='/u01/app/oracle/product/10.2.0/db_1/admin/ourdb/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/u01/app/oracle/product/10.2.0/db_1/oradata/ourdb/control01.ctl','/u01/app/oracle/product/10.2.0/db_1/oradata/ourdb/ control02.ctl','/u01/app/oracle/product/10.2.0/db_1/oradata/ourdb/control03.ctl'
*.core_dump_dest='/u01/app/oracle/product/10.2.0/db_1/admin/ourdb/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_file_name_convert='/u01/app/oracle/product/10.2.0/db_1/oradata/ourdb/','/u01/app/oracle/product/10.2.0/db_1/oradata/oursby/'
*.db_name='ourdb'
*.db_recovery_file_dest='/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.db_unique_name='OURDB'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=ourdbXDB)'
*.fal_client='oursby'
*.fal_server='ourdb'
*.job_queue_processes=10
*.LOCAL_LISTENER='(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST =stbyoracle10g.raja.com)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = oursby)))'
*.log_archive_config='DG_CONFIG=(ourdb,oursby)'
*.log_archive_dest_1='LOCATION=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area VALID_FOR=(ALL_LOGFILES,ALL_ROLES) db_unique_name=ourdb'
*.log_archive_dest_2='SERVICE=ourdb VALID_FOR=(ALL_LOGFILES,PRIMARY_ROLE) db_unique_name=oursby'
*.log_archive_dest_state_1='ENABLE'
*.log_archive_dest_state_2='ENABLE'
*.log_archive_format='%t_%s_%r.arc'
*.LOG_ARCHIVE_MAX_PROCESSES=30
*.log_file_name_convert='/u01/app/oracle/product/10.2.0/db_1/oradata/ourdb/','/u01/app/oracle/product/10.2.0/db_1/oradata/oursby/'
*.open_cursors=300
*.pga_aggregate_target=16777216
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.REMOTE_OS_AUTHENT=TRUE
*.service_names='OURDB'
*.sga_target=167772160
*.standby_file_management='AUTO'
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/app/oracle/product/10.2.0/db_1/admin/ourdb/udump'
[oracle@oracle10g dbs]$


And my standby pfile:-
oursby:-
pfile
[oracle@stbyoracle10g dbs]$ cat /u01/app/oracle/product/10.2.0/db_1/dbs/initoursby.ora
ourdb.__db_cache_size=83886080
ourdb.__java_pool_size=4194304
ourdb.__large_pool_size=4194304
ourdb.__shared_pool_size=67108864
ourdb.__streams_pool_size=4194304
*.audit_file_dest='/u01/app/oracle/product/10.2.0/db_1/admin/ourdb/adump'
*.background_dump_dest='/u01/app/oracle/product/10.2.0/db_1/admin/ourdb/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/u01/app/oracle/product/10.2.0/db_1/oradata/ourdb/control01.ctl','/u01/app/oracle/product/10.2.0/db_1/oradata/ourdb/ control02.ctl','/u01/app/oracle/product/10.2.0/db_1/oradata/ourdb/control03.ctl'
*.core_dump_dest='/u01/app/oracle/product/10.2.0/db_1/admin/ourdb/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='ourdb'
*.db_recovery_file_dest='/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.db_unique_name='oursby'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=ourdbXDB)'
*.fal_client='oursby'
*.fal_server='ourdb'
*.job_queue_processes=10
*.log_archive_config='DG_CONFIG=(oursby,ourdb)'
*.log_archive_dest_1='LOCATION=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area VALID_FOR=(ALL_LOGFILES,ALL_ROLES) db_unique_name=oursby'
*.log_archive_dest_2='SERVICE=ourdb LGWR ASYNC VALID_FOR=(ALL_LOGFILES,PRIMARY_ROLE) db_unique_name=ourdb'
*.log_archive_dest_state_1='ENABLE'
*.log_archive_dest_state_2='ENABLE'
*.log_archive_format='%t_%s_%r.arc'
*.LOG_ARCHIVE_MAX_PROCESSES=30
*.open_cursors=300
*.pga_aggregate_target=16777216
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=167772160
*.standby_file_management='AUTO'
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/app/oracle/product/10.2.0/db_1/admin/ourdb/udump'

=========================================================================================
tnsentry:-

=========================================================================================
OURDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle10g.raja.com)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ourdb)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

oursby =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =stbyoracle10g.raja.com)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = oursby)
)
)
=======================================================================================

i am trying to duplicate the primary to stand by as below.

i have taken the backup from primary(database+archive logs,current controlfile, password file)
i have moved the backups to the same location.from oracle10g to stboracle10g(both servers both location(/u01/backup).

now i am trying to perform
rman target / auxiliary system@oursby

error :-
[oracle@oracle10g admin]$ rman target / auxiliary system@oursby

Recovery Manager: Release 10.2.0.1.0 - Production on Wed Dec 7 07:48:25 2005

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

connected to target database: OURDB (DBID=543793856)
auxiliary database Password:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04006: error from auxiliary database: ORA-01031: insufficient privileges
[oracle@oracle10g admin]$

listener:-
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
(SID_NAME = ourdb)
)
(SID_DESC =
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
(SID_NAME = oursby)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle10g.raja.com)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)


please help me what is wrong in this

Thanks,
Raja.S

[SPLIT from someone else's topic by LF]

[Updated on: Sat, 20 April 2013 16:43] by Moderator

Report message to a moderator

Re: dataguard error in startup using pfileORCL.ora [message #582577 is a reply to message #582574] Fri, 19 April 2013 09:15 Go to previous messageGo to next message
Michel Cadot
Messages: 59291
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
*.REMOTE_OS_AUTHENT=TRUE


NEVER, NEVER set that.

Quote:
RMAN-04006: error from auxiliary database: ORA-01031: insufficient privileges


1/ Check the name if your password file
2/ Recreate it with SYS password

Regards
Michel
Re: dataguard error in startup using pfileORCL.ora [message #582596 is a reply to message #582577] Fri, 19 April 2013 19:38 Go to previous messageGo to next message
BlackSwan
Messages: 22845
Registered: January 2009
Senior Member
>RMAN-04006: error from auxiliary database: ORA-01031: insufficient privileges

post results from OS command below

env | sort
Re: dataguard error in startup using pfileORCL.ora [message #582646 is a reply to message #582596] Sat, 20 April 2013 14:11 Go to previous messageGo to next message
ramanujam.y@gmail.com
Messages: 5
Registered: April 2013
Location: India
Junior Member
Hi Michel,

First of all sorry for the delayed reply. my net is not working properly.
As you said i made the changes in the pfile, still i am getting the same error.

[oracle@oracle10g ~]$ rman target / auxiliary sys@oursby

Recovery Manager: Release 10.2.0.1.0 - Production on Thu Dec 8 12:49:36 2005

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

connected to target database: OURDB (DBID=543793856)
auxiliary database Password:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04006: error from auxiliary database: ORA-01031: insufficient privileges
[oracle@oracle10g ~]$


Thanks,Raja

[Updated on: Sat, 20 April 2013 14:12]

Report message to a moderator

Re: dataguard error in startup using pfileORCL.ora [message #582647 is a reply to message #582596] Sat, 20 April 2013 14:15 Go to previous messageGo to next message
ramanujam.y@gmail.com
Messages: 5
Registered: April 2013
Location: India
Junior Member
HI BlackSwan,

Please find the below output.

[oracle@oracle10g ~]$ env | sort
_=/bin/env
CLASSPATH=/u01/app/oracle/product/10.2.0/db_1/JRE:/u01/app/oracle/product/10.2.0/db_1/jlib:/u01/app/oracle/product/10.2.0/db_1/rdbms/ jlib
CVS_RSH=ssh
G_BROKEN_FILENAMES=1
HISTSIZE=1000
HOME=/home/oracle
HOSTNAME=oracle10g.raja.com
INPUTRC=/etc/inputrc
LANG=en_US.UTF-8
LD_LIBRARY_PATH=/u01/app/oracle/product/10.2.0/db_1/lib:/lib:/usr/lib
LESSOPEN=|/usr/bin/lesspipe.sh %s
LOGNAME=oracle
LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32: *.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*. zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00; 35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:
MAIL=/var/spool/mail/oracle
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
ORACLE_SID=ourdb
ORACLE_TERM=xterm
PATH=/u01/app/oracle/product/10.2.0/db_1/bin:/usr/sbin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/oracle/bin
PWD=/home/oracle
SHELL=/bin/bash
SHLVL=1
SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
SSH_CLIENT=192.168.242.1 52539 22
SSH_CONNECTION=192.168.242.1 52539 192.168.242.128 22
SSH_TTY=/dev/pts/1
TERM=xterm
TMPDIR=/tmp
TMP=/tmp
USER=oracle


Thanking you,
Raja
Re: dataguard error in startup using pfileORCL.ora [message #582654 is a reply to message #582647] Sat, 20 April 2013 18:17 Go to previous messageGo to next message
BlackSwan
Messages: 22845
Registered: January 2009
Senior Member
>RMAN-04006: error from auxiliary database: ORA-01031: insufficient privileges

It appears that you are not allowed to remotely log into @oursby as SYS.
Why not?
When was last time this worked without error?
What changed since then?
Re: Difficulties in configuring Data Guard environment [message #582673 is a reply to message #582574] Sun, 21 April 2013 02:38 Go to previous messageGo to next message
John Watson
Messages: 4611
Registered: January 2010
Location: Global Village
Senior Member
Your parameter files are way off. In the primary file, you need to look at local_listener, %_file_name_convert, fal_%. In the standby file, many are missing.
Youe listener.ora file is wrong, you seem to be confused about which machine the listener is running on and which machine the databases are on.
I think you may need to go back to the docs, and start again.
Re: Difficulties in configuring Data Guard environment [message #582694 is a reply to message #582673] Mon, 22 April 2013 00:10 Go to previous messageGo to next message
ramanujam.y@gmail.com
Messages: 5
Registered: April 2013
Location: India
Junior Member
Hi Watson,

The listener entry that i mentioned is the primary Listener entry which is running on oracle10g.raja.com

Do you want me to update the local listener with the listener name ?

I will remove the %_file_name_convert as i am using the same location in both the server(i used the clone option in the vmware so every thing will be same).

what needs to be changed in the fal_% ?

or please help me by providing the link which helps me to configure the data guard properly.

Regards,
Raja



Re: dataguard error in startup using pfileORCL.ora [message #582698 is a reply to message #582654] Mon, 22 April 2013 00:31 Go to previous messageGo to next message
ramanujam.y@gmail.com
Messages: 5
Registered: April 2013
Location: India
Junior Member
Hi Blackswan,

Actually from the beginning i am trying to connect but it is not allowing to connect from primary(oracle10g.raja.com) to standby(stbyoracle10g.raja.com) .But i tried from stand by to primary which works perfectly.

[oracle@stbyoracle10g ~]$ sqlplus system/sys123@ourdb

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Dec 9 23:18:28 2005

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


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> show parameter db_name

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_name string ourdb
SQL> sho parameter service

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
service_names string OURDB
SQL> sho parameter db_unique

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_unique_name string OURDB
SQL>


Thanks,
Raja

[Updated on: Mon, 22 April 2013 00:42]

Report message to a moderator

Re: Difficulties in configuring Data Guard environment [message #582703 is a reply to message #582673] Mon, 22 April 2013 01:38 Go to previous messageGo to next message
John Watson
Messages: 4611
Registered: January 2010
Location: Global Village
Senior Member
Quote:
or please help me by providing the link which helps me to configure the data guard properly.
http://docs.oracle.com/cd/E11882_01/server.112/e25608/toc.htm
Re: Difficulties in configuring Data Guard environment [message #597482 is a reply to message #582703] Sat, 05 October 2013 00:16 Go to previous messageGo to next message
8939513598$
Messages: 103
Registered: July 2013
Location: chennai
Senior Member
Hi Mr.Ramanujam, whether listener pinging with Tns service name, also the location of passwordfile, important...
icon11.gif  Re: Difficulties in configuring Data Guard environment [message #597486 is a reply to message #597482] Sat, 05 October 2013 00:40 Go to previous message
Michel Cadot
Messages: 59291
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

I hope OP has fixed his problem since April.

Previous Topic: ORA_01157 and ORA_01110
Next Topic: doubt in log applied or not
Goto Forum:
  


Current Time: Wed Oct 01 15:50:06 CDT 2014

Total time taken to generate the page: 0.29389 seconds