to mas rochmad 1.untuk OS nya saya menggunakan OS window XP. 3. tnsping dbstandby saya lakukan di mesin standby dan conn sys/pwd juga d mesin standby 2. untuk create nya saya rasa sudah dengan oradim -new -sid dboratmp -syspwd oracle -startmode manual dan sudah ter-create, sedangkan untuk up nya blm bisa up karena klo tidak salah untuk mount database harus connect ke sys dan itu masih gagal.
berikut potongan seting file init.ora di sisi primary : Db_unique_name = dbora1 Service_names = dbora Log_archive_config = 'dg_config = (dbora, dboratmp)' control_file='c:/oradata/product/dbora/stby_ctl01.ctl' Log_archive_dest_1 = 'location = c:\oradata\product\dbora valid_for = (ALL_LOGFILES, ALL_ROLES) db_unique_name = dbora' Log_archive_dest_2 = 'service = dboratmp valid_for = (ONLINE_LOGFILES, PRIMARY_ROLE) db_unique_name = dboratmp lgwr async=20480' LOG_ARCHIVE_DEST_STATE_1=ENABLE LOG_ARCHIVE_DEST_STATE_2=ENABLE REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE Standby_file_management = AUTO Standby_archive_dest = 'location = c:\oradata\product\' dan potonga seting init.ora di sisi standby Db_unique_name = dbora1 Service_names = dbora Log_archive_config = 'dg_config = (dbora, dboratmp)' Log_archive_dest_1 = 'location = c:\oradata\lokasi\archive valid_for = (ALL_LOGFILES, ALL_ROLES) db_unique_name = dbora' Log_archive_dest_2 = 'service = dboratmp valid_for = (ONLINE_LOGFILES, PRIMARY_ROLE) db_unique_name = dboratmp lgwr async=20480' Log_archive_dest_state_1 = ENABLE Log_archive_dest_state_2 = DEFER Standby_file_management = AUTO Standby_archive_dest = 'location = c:\oradata\product\' dboratmp.control_files = 'c:\oradata\product\dbora\stby_ctl01.ctl' dboratmp.db_unique_name = dboratmp dboratmp.service_names = dboratmp dboratmp.log_archive_config = 'dg_config = (dbora, dboratmp)' dboratmp.log_archive_dest_1 = 'location = c:\oradata\lokasi\archive valid_for = (ALL_LOGFILES, ALL_ROLES) db_unique_name = dboratmp' dboratmp.log_archive_dest_2 = 'service = dbora valid_for = (ONLINE_LOGFILES, PRIMARY_ROLE) db_unique_name = dbora1' apakah ada yang salah dalam setingan file init.ora di masing2 mesin ? tolong bantuannya terima kasih TQ rohmadsan <[EMAIL PROTECTED]> wrote: 1. Di OS apakah? Windows, Solaris, Linux? 2. Apakah database standby-nya sudah ter-create dan up? 3. Melakukan tnsping dan conn sys/pwd dilakukan di mesin primary or standby? Salam, Rohmad http://rohmadst.wordpress.com --- In [email protected], musisi musisi <[EMAIL PROTECTED]> wrote: > > salam para oracle master, > > langsung saja, saya mencoba membuat standby database di oracle 10G. setelah melakukan beberapa setting di database yang utama, saya melakukan setting di database standby. saat melakukan tnsping dbstandby itu sukses > tetapi saat melakukan koneksi ke sys/pwd as sysdba > ternyata error TNS protocol adapter erro > > apa yang harus saya lakukan. > > tolong bantuannya > > TQ --------------------------------- Real people. Real questions. Real answers. Share what you know. [Non-text portions of this message have been removed]
