SQL>connect /as sysdba connected to an idle instance SQL> startup open ORA-44410: XE edition single instance violation error
On 3/26/07, Johannes Christian <[EMAIL PROTECTED]> wrote: > > setelah SQL> connect /as sysdba > SQL> startup open > SQL> alter user system identified by your_password; > dayat wrote: > > > > $ export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server > > $ export ORACLE_SID=XE > > $ export TNS_ADMIN=$ORACLE_HOME/network/admin > > $ export PATH=$PATH:$ORACLE_HOME/bin > > $ sqlplus /nolog > > > > SQL> connect /as sysdba > > Connected to an idle instance. > > SQL> alter user system identified by your_password; > > alter user system identified by your_password > > * > > ERROR at line 1: > > ORA-01034: ORACLE not available > > > > SQL> > > > > Masih ga bisa. > > > > On 3/24/07, arynur <[EMAIL PROTECTED] <arynur%40gmail.com> <mailto: > arynur% <arynur%25>40gmail.com>> wrote: > > > > > > dayat wrote: > > > > > > > > > > > > Salam, > > > > > > > > tadi aku baru aja install oracle xe dengan rpm di fedora core 5 > linux. > > > trus > > > > waktu aku jalanin service-nya, dia minta masukin password, ya udah > > > kuberikan > > > > aja. trus waktu aku connect pake SQL*Plus aku masukin user-name = > sys > > > dan > > > > password-nya sesuai dengan password waktu dia minta tadi, setelah > itu > > > > terjadilah ini: > > > > ERROR: > > > > ORA-01017: invalid username/password; logon denied > > > > > > > > di http://127.0.0.1:8080/apex <http://127.0.0.1:8080/apex> > > <http://127.0.0.1:8080/apex <http://127.0.0.1:8080/apex>> juga Invalid > > > > Login Credentials. padahal > > > > passwordnya ga salah yang waktu dimasukin pertama install, dan > > user udah > > > > dicoba pake sys, sysoper, sysdba system. > > > > > > > > gimana nih, tolong dong. > > > > > > > > makaci > > > > dayat > > > > > > > > > > Masuk ke console terminal dengan menggunakan user yang menjadi anggota > > > group dba. > > > > > > $ export > ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server > > > $ export ORACLE_SID=XE > > > $ export TNS_ADMIN=$ORACLE_HOME/network/admin > > > $ export PATH=$PATH:$ORACLE_HOME/bin > > > $ sqlplus /nolog > > > > > > SQL> connect /as sysdba > > > Connected. > > > SQL> alter user system identified by your_password; > > > User altered. > > > SQL> exit > > > > > > Kemudian coba ada logon melalui http://127.0.0.1:8080/apex > > <http://127.0.0.1:8080/apex> > > > dengan user: system dan password: your_password. > > > > > > Semoga membantu, > > > arynur > > > http://www.getbiofir.com/ <http://www.getbiofir.com/> > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > [Non-text portions of this message have been removed]
