| How to clear this Data Guard alert message in EM? [message #210886] |
Fri, 22 December 2006 23:27  |
wxfjordan
Messages: 92
Registered: December 2006
|
Member |
|
|
Please see the Data Guard alert message in the upload picture, it is my oracle database status.
I ever built this server as primary database in Data Guard environement.
And then I have canceled the standby database long time ago.
Initialized parameter file as following:
primary1.__db_cache_size=184549376
primary1.__java_pool_size=4194304
primary1.__large_pool_size=4194304
primary1.__shared_pool_size=92274688
primary1.__streams_pool_size=0
*.audit_file_dest='C:\oracle\product\10.2.0/admin/primary1/adump'
*.background_dump_dest='C:\oracle\product\10.2.0/admin/primary1/bdump'
*.compatible='10.2.0.1.0'
*.control_files='C:\oracle\product\10.2.0\oradata\primary1\control01.ctl','C:\oracle\product\10.2.0\oradata\primary1\control02.ctl',' C:\oracle\product\10.2.0\oradata\primary1\control03.ctl'
*.core_dump_dest='C:\oracle\product\10.2.0/admin/primary1/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=8
*.db_name='primary1'
*.db_recovery_file_dest='C:\oracle\product\10.2.0\flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=primary1XDB)'
*.job_queue_processes=10
*.log_archive_dest_1='location=C:\oracle\product\10.2.0\archivelog'
*.open_cursors=300
*.pga_aggregate_target=95420416
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=287309824
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='C:\oracle\product\10.2.0/admin/primary1/udump'
and the listener.ora file as following:
# listener.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = webtest2)(PORT = 1521))
)
)
Why still display Data Guard alert message in EM?
How to clear this Data Guard alert message in EM?
Give me some directions
Thanks
Jordan
|
|
|
|
|
|
| Re: How to clear this Data Guard alert message in EM? [message #210948 is a reply to message #210886] |
Sun, 24 December 2006 01:05  |
wxfjordan
Messages: 92
Registered: December 2006
|
Member |
|
|
But there are two file pfile and spfile in directory oracle_home\dbs.
And now the EM can't be startuped.
I found a file in directory oracle_home\database.
The file is core_primary1_pid_2028_tid_xC0_2006_12_24_14_14_46.log
and the content is
An Unhandled Exception Occurred,
Exception Number : 0xc0000005
Exception Address : 0x60af2cc4
Please see the attachment picture.
( Wow... The problem will become bigger. )
Thanks
|
|
|
|
|
|
] 
Search
Help
Members
Register
Login
Home
