1. Can you explain what you mean by exporting on sql extension file?
Do you want to use EXP utility OR you want to generate an sql file
containing a script that we can use to create the tables and packages?
2. Is your problem actually you were unable to make a connection to the idle
instance hence you cannot start it OR you can make the connection to the
idle instance but unable to start it up?
If it's the former, then it is probably due to the service name was not
registered to the LISTENER (remote connection always use LISTENER). I think
your setup is using automatic registration, which means the instance will
automatically register itself to the LISTENER ONLY when it's up. The
workaround is to specify your SID in the listener.ora file, so it is always
registered regardless your instance is up or down.
CMIIW
On Nov 8, 2007 12:35 PM, Andi Afandi <[EMAIL PROTECTED]> 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
>
> [Non-text portions of this message have been removed]
>
>
>
[Non-text portions of this message have been removed]
