to boss rosa boss, apa iya tnsping nya dr kedua server itu bolak-balik, berhasil??? koq masi bisa error TNS ya??? *bingung...* mungkin bs dcoba check lagi tnsnames.ora n listener.ora d 2 server itu... trus, sys nya oltpdg n dppjabar itu share password yg sama gk? mungkin bs dcoba dulu pake pass yg sama, trus coba create ulang file passwd nya lagi... parameter remote_login_passwordfile d 2 server itu, nilainya "EXCLUSIVE" khan ya?? CMIIW, [L]
--- On Mon, 7/13/09, rosa mala <[email protected]> wrote: From: rosa mala <[email protected]> Subject: Re: [indo-oracle] Kegagalan pengiriman Redo ke standby database pada Dataguard 10g To: [email protected] Date: Monday, July 13, 2009, 4:36 PM 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 <leon_190699@ yahoo.com> wrote: From: Leonard Sukendro <leon_190699@ 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, 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_ndu@ yahoo. com> wrote: From: rosa mala <nangin_ndu@ 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] [Non-text portions of this message have been removed]
