Dear Pak Leonard, kalau dari pri-->stb SQL> conn s...@oltpdg as sysdba Enter password: ERROR: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
kalau dari stb--> pri Enter user-name: s...@dppjabar as sysdba Enter password: ERROR: ORA-01017: invalid username/password; logon denied cat: padahal passwordnya udah benar.. Regards, Rosa Rosmala --- On Mon, 7/13/09, Leonard Sukendro <[email protected]> wrote: From: Leonard Sukendro <[email protected]> Subject: Re: [indo-oracle] Kegagalan pengiriman Redo ke standby database pada Dataguard 10g To: [email protected] Date: Monday, July 13, 2009, 2:37 PM to pak/bu rosa, bisa coba connect dr pri -> stby dan stby -> pri... bisa gk ya? misal dr pri: conn sys/[password] @stby as sysdba regards, [L] --- On Mon, 7/13/09, rosa mala <nangin_...@yahoo. com> wrote: From: rosa mala <nangin_...@yahoo. com> Subject: Re: [indo-oracle] Kegagalan pengiriman Redo ke standby database pada Dataguard 10g To: indo-oracle@ yahoogroups. com Date: Monday, July 13, 2009, 1:40 PM Dear Defry, Tnsping dari standby ke primary ataupun sebaliknya sukses ( 0 Msec). Tks. Regards, Rosa Rosmala --- On Sat, 7/11/09, defri afrian <def_rian80@ yahoo. com> wrote: From: defri afrian <def_rian80@ yahoo. com> Subject: Re: [indo-oracle] Kegagalan pengiriman Redo ke standby database pada Dataguard 10g To: indo-oracle@ yahoogroups. com Date: Saturday, July 11, 2009, 8:55 AM Dear Rosa Bagaimana status tnsping antara standby server dari primary server dan sebaliknya ? Regards, Defry --- On Fri, 7/10/09, rosa mala <nangin_ndu@ yahoo. com> wrote: From: rosa mala <nangin_ndu@ yahoo. com> Subject: [indo-oracle] Kegagalan pengiriman Redo ke standby database pada Dataguard 10g To: indo-oracle@ yahoogroups. com Date: Friday, July 10, 2009, 12:29 AM Selamat siang Bapak / Ibu, Mohon bantuannya untuk kasus berikut: Saat saya coba mengirimkan redo dari primary database ke standby database saya menemukan error sebagai berikut: SQL> select dest_id, destination, status, error from v$archive_dest; DEST_ID DESTINATION STATUS ERROR ---------- ------------ --------- ---- --------- ------------ -------- 1 /archivelog VALID 2 oltpdg ERROR ORA-01031: insufficient privileges 3 INACTIVE 4 INACTIVE 5 INACTIVE 6 INACTIVE 7 INACTIVE 8 INACTIVE DEST_ID DESTINATION STATUS ERROR ---------- ------------ --------- ---- --------- ------------ -------- 9 INACTIVE 10 INACTIVE 10 rows selected. Apakah yang menyebabkan ada error insufficient privileges padahal diawal saya sudah set orapwd dimana password yang di primary dan stadby sudah sama. database standby sudah bisa di startup mount. Mohon masukkannya ya. Tks sebelumnya. Regards, Rosa Rosmala DBA PLN DJBB [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
