Memang, di Windows agak ribet, terutama yang berkaitan dengan setting environment dan registry.
Masalah anda masih belum menginjak yang utama (primary &s tandby issue), ini masih tentang login ke dalam instance. Coba lakukan langkah berikut: 1. Edit file %ORACLE_HOME%\network\admin\sqlnet.ora tambahkan baris berikut: SQLNET.AUTHENTICATION_SERVICES = (NTS) 2. Sebelum menjalankan SQLPlus, jalankan command berikut set ORACLE_SID=dboratmp Salam, Rohmad http://rohmadst.wordpress.com --- In [email protected], musisi musisi <[EMAIL PROTECTED]> wrote: > > 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
