Re: Remote client to startup using SuSe

From: Howard J. Rogers <howardjr_at_dizwell.com>
Date: Tue, 05 Oct 2004 07:42:51 +1000
Message-ID: <41631606$0$20127$afc38c87@news.optusnet.com.au>

Vageesh wrote:

> Hi
>
> I am using a suse client and a suse server.
> I have configured the Lister and its up and running.
> I have configured tnsnames.ora and tnsping works.
> The database is SHUTDOWN and I want to START.
> I have a pfile at client place in which have specified the
> spfile=path/filename parameter.
> Now I try to say
> sqlplus "sys/password_at_connect as sysdba"

So you're connecting from the client to issue privileged commands? You'll need to set REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE if it's not already. There will need to be a password file on the server if you haven't already created one. Use orapwd to do that if necessary:

orapwd file=$ORACLE_HOME/dbs/orapwSID.ora password=xxxxx entries=20

And just so we're 100% clear, the correct connection string syntax is:

sqlplus "sys/password_at_SID as sysdba"

Let us know how you get on.

Regards
HJR
> It says insufficient priveleges
> Oerr ora 1031 insufficient Priveleges
>
> Could you please help
> Vageesh
Received on Mon Oct 04 2004 - 16:42:51 CDT