thanks bro, atas infonya :).. --- On Tue, 1/5/10, yulius_wibowo <[email protected]> wrote:
From: yulius_wibowo <[email protected]> Subject: [indo-oracle] Re: Oracle 10.2.0.4.0 on Solaris 10 (grant sysdba) To: [email protected] Date: Tuesday, January 5, 2010, 9:16 AM Untuk dapat mengakses database secara remote dgn privilege SYSDBA, salah satu syarat utamanya adalah adanya PASSWORD file. - Lokasi : $ORACLE_HOME/ dbs atau %ORACLE_HOME% \database - Nama : orapwSID atau orapwSID.ora - Untuk membuatnya, gunakan "orapwd" Syarat lainnya, parameter REMOTE_LOGIN_ PASSWORDFILE= EXCLUSIVE Note: Hati2 memberi privilege SYSDBA. Ada baiknya cukup dgn memberi privilege SYSOPER. cmiiw, bowo --- In indo-oracle@ yahoogroups. com, dede zackky <dzackr...@. ..> wrote: > > Dear para master oracle, > saya minta pencerahannya, gimana caranya men set user menjadi privileges > sysdba.. > di database tersebut blm ada user yg ber privileges sebagai sysdba termasuk > sys. > > SQL>conn user1/admin@ spatial as sysdba; > ERROR: > ORA-01031 : insufficient privieges > > Warning: you are no longer connected to ORACLE. > > > saya sudah coba di sqlplus untuk grant > SQL> connect� as sysdba > connected. > SQL> grant sysdba to user1; > ERROR at line 1: > ORA-01994 : Grant Failed : Password file missing or disabled. > > Regards, > > zaky > > > > > > > > > [Non-text portions of this message have been removed] > [Non-text portions of this message have been removed]
