Utk yg no.2 Tdk bisa startup pakai SQL*Plus di client:
Jawab : karena database server tidak menggunakan server parameter file (SPFILE) dan tidak ada parameter file di komputer client dimana SQL*Plusnya dijalankan. Solusi: gunakan server parameter file (SPFILE, mulai ada semenjak versi 9i). Atau copy parameter file ke komputer client, lalu startup dengan menggunakan option PFILE=<param_file> Mas Afandi, anda pakai Oracle versi berapa? CMIIW, Bw --- In [email protected], Johannes Christian <[EMAIL PROTECTED]> wrote: > > 1. Anda tidak perlu membuat script kalau hanya untuk export karena > oracle sudah menyertakan utility export (exp). exp ini bisa dilakukan > secara remote, jadi anda tidak perlu ke server. > 2. Anda tidak bisa start DB tentu ada error message nya, silahkan di > post disini. Tapi kemungkinan besar sih masalah SID yang berbeda. > > --jo-- > Andi Afandi wrote: > > > > Dear all Oracle and UNIX Master..., > > I have some questions those might be easy for you but difficult for me.. > > I'm working in sqlplus client computer that remotely access oracle > > solaris server > > 1. How to make a script that run export package or table on sql > > extension file and > > straight away going to my windows client computer not going to server > > 2. Why I can shutdown database from sqlplus in my windows client > > computer but cannot > > startup from there. > > I have to startup from telnet sql to start the database. > > What is the problem and the solution... > > > > Thanks..... > > Afandi > > > > __________________________________________________ > > Do You Yahoo!? > > Tired of spam? Yahoo! Mail has the best spam protection around > > http://mail.yahoo.com <http://mail.yahoo.com> > > > > [Non-text portions of this message have been removed] > > > > >
