| Physical Standby database ORA-01031: insufficient privileges [message #160420] |
Sat, 25 February 2006 07:19  |
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  |
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.
|
|
|
|
] 
Search
Help
Members
Register
Login
Home
