Home » Server Options » Data Guard » Physical Standby database ORA-01031: insufficient privileges
Physical Standby database ORA-01031: insufficient privileges [message #160420] Sat, 25 February 2006 07:19 Go to next message
jaiminks
Messages: 3
Registered: January 2006
Junior Member
This is what I have done

The Primary database(ORA10g) is on the linux box

I took the cold backup and restored it into another linux box. the database name here is the same as primary (ORA10g)

Created a standby control file in the primary db

using <ALTER DATABASE CREATE STANDBY CONTROLFILE AS '/data/apps/db/oracle/oradata/ORA10g_standby/ORA10g_standby.ctl';> command on specific location.

Did the followin changes to the primary database(ORA10g)init.ora file


processes=150

###########################################
# SGA Memory
###########################################
sga_target=605028352

###########################################
# Security and Auditing
###########################################
audit_file_dest=/db/oracle/admin/ORA10g/adump
remote_login_passwordfile=EXCLUSIVE

###########################################
# Shared Server
###########################################
dispatchers="(PROTOCOL=TCP) (SERVICE=ORA10gXDB)"

###########################################
# Sort, Hash Joins, Bitmap Indexes
###########################################
pga_aggregate_target=201326592

###########################################
# System Managed Undo and Rollback Segments
###########################################
undo_management=AUTO
undo_tablespace=UNDOTBS1

log_archive_config='DG_CONFIG=(ORA10g2,ORA10g_standby)'

log_archive_dest_1='LOCATION=/db/oracle/product/10.2.0.1/db_1/arch/ORA10g/
VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
db_unique_name=ORA10g'
log_archive_dest_2='SERVICE=ORA10g_standby
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=ORA10g_standby LGWR ASYNC REOPEN=10'
log_archive_dest_state_1='enable'
log_archive_dest_state_2='enable'
db_unique_name='ORA10g'
remote_login_passwordfile='EXCLUSIVE'
DB_FILE_NAME_CONVERT='/db/oracle/oradata/ORA10g/','/db/devices/oracle/ORA10g'
LOG_FILE_NAME_CONVERT='/db/oracle/oradata/ORA10g/','/db/devices/oracle/ORA10g'
standby_file_management='AUTO'


Did the following changes to the listener.ora file for primary host

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =dbs-ld52.webdb.aol.com)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = ORA10g))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME =/db/oracle/product/10.2.0.1/db_1)
(SID_NAME = ORA10g)
)
)

Did the following changes to the tnsnames.ora file for primary host


ORA10g =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dbs-ld52.webdb.aol.com)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORA10g)
)
)

ORA10g_standby =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dbs-ld53.webdb.aol.com)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORA10g_standby)
)
)

Did the following changes to the init.ora file for standby host

ORA10g.__db_cache_size=436207616
ORA10g.__java_pool_size=4194304
ORA10g.__large_pool_size=4194304
ORA10g.__shared_pool_size=155189248
ORA10g.__streams_pool_size=0
*.audit_file_dest='/db/devices/oracle/ORA10g/adump'
*.background_dump_dest='/db/devices/oracle/ORA10g/bdump'
*.compatible='10.2.0.1.0'
*.core_dump_dest='/db/devices/oracle/ORA10g/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.DB_FILE_NAME_CONVERT='/db/devices/oracle/ORA10g/','/db/oracle/oradata/ORA10g/'
*.db_name='ORA10g'
*.db_unique_name='ORA10g_standby'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=ORA10gXDB)'
*.job_queue_processes=10
*.log_archive_config='DG_CONFIG=(ORA10g2,ORA10g_standby)'
*.log_archive_dest_1='LOCATION=/db/devices/oracle/ORA10g/arch/
VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
db_unique_name=ORA10g_standby'
*.log_archive_dest_2='SERVICE=ORA10g
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=ORA10g LGWR ASYNC REOPEN=10'
*.log_archive_dest_state_1='enable'
*.log_archive_dest_state_2='enable'
*.LOG_FILE_NAME_CONVERT='/db/devices/oracle/ORA10g/','/db/oracle/oradata/ORA10g/'
*.open_cursors=300
*.pga_aggregate_target=201326592
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=605028352
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/db/devices/oracle/ORA10g/udump'
CONTROL_FILES='/db/devices/oracle/ORA10g/stdby.ctl'
standby_file_management=AUTO
standby_archive_dest='/db/devices/oracle/ORA10g/arch'


Did the following changes to the listener.ora file for standby host


LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =dbs-ld53.webdb.aol.com)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = ORA10g_standby))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME =/db/devices/product/10.2.0.1/db_1)
(SID_NAME = ORA10g_standby)
)
)

Did the following changes to the tnsnames.ora file for standby host

ORA10g =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dbs-ld52.webdb.aol.com)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORA10g)
)
)

ORA10g_standby =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dbs-ld53.webdb.aol.com)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORA10g_standby)
)
)
~



started the standby database in nomount state.

mounted the standby database with this command

startup mount

put the stanby database in recovery mode using

<alter database recover managed standby database disconnect>

on the primary site, i opened the database,

issued the log switch.checked the v$archive_deststatus is showing error

and error showing
SQL> select status,error from v$archive_dest;

STATUS ERROR
--------- -----------------------------------------------------------------
VALID
ERROR ORA-01031: insufficient privileges
INACTIVE
INACTIVE
INACTIVE
INACTIVE
INACTIVE
INACTIVE
INACTIVE
INACTIV
Re: Physical Standby database ORA-01031: insufficient privileges [message #213689 is a reply to message #160420] Thu, 11 January 2007 21:52 Go to previous message
kbijayanta
Messages: 1
Registered: January 2007
Location: Bangalore
Junior Member
Hi
try creating password files on both the servers like this(execute it in $ORACLE_HOME/dbs):
$ orapwd file=orapwORADR password=some_pass entries=5 force=y

Reason:
Every database in a Data Guard environment must use a password file. Additionally, the password used by SYS must be the same for all primary and standby databases.

I hope it works.

Previous Topic: Information on archive log
Next Topic: dataguard on 10g
Goto Forum:
  


Current Time: Fri Mar 29 07:43:02 CDT 2024