error standby database server

24 Feb

Beberapa error standby database server

1. target host or object does not exist
SQL> select dest_id, destination, status, error from v$archive_dest;
DEST_ID DESTINATION STATUS ERROR
———- —————————————- ———- ———-
1 /u01/archive/prmr11g VALID
2 stby11g ERROR ORA-12545:
Connect
failed
because
target
host or
object
does not
exist

SQL> /

edit file TNSNAMES.ORA dan ubah host name menjadi angka TCP/IP

2. TNS : no listener
SQL> select dest_id, destination, status, error from v$archive_dest;
DEST_ID DESTINATION STATUS ERROR
———- —————————————- ———- ———-
1 /u01/archive/prmr11g VALID
2 stby11g ERROR ORA-12541:
TNS:no
listener

[oracle@prmr11g admin]$ lsnrctl reload

3. Primary log shipping client not logged on standby
SQL> select dest_id, destination, status, error from v$archive_dest;
DEST_ID DESTINATION STATUS ERROR
———- —————————————- ———- ———-
1 /u01/archive/prmr11g VALID
2 stby11g ERROR ORA-16191:
Primary
log
shipping
client not
logged on
standby

SQL> alter system set SEC_CASE_SENSITIVE_LOGON=FALSE scope=both;
SQL> alter system set SEC_CASE_SENSITIVE_LOGON=FALSE scope=both;
[oracle@stby11g ~]$ rm $ORACLE_HOME/dbs/orapwstby11g
[oracle@stby11g ~]$ orapwd file=$ORACLE_HOME/dbs/orapwstby11g password=oracle0 ignorecase=Y
[oracle@prmr11g ~]$ rm $ORACLE_HOME/dbs/orapwprmr11g
[oracle@prmr11g ~]$ orapwd file=$ORACLE_HOME/dbs/orapwprmr11g password=oracle0 ignorecase=Y

SQL> /
DEST_ID DESTINATION STATUS ERROR
———- —————————————- ———- ———-
1 /u01/archive/prmr11g VALID
2 stby11g VALID

One Response to “error standby database server”

  1. Jack Nickolson May 4, 2010 at 8:46 pm #

    Good solution for ORA-12545 on standby database. Thanks a lot.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: