Re: Remote startup

From: Andy Hassall <andy_at_andyh.co.uk>
Date: Sat, 26 Mar 2005 15:46:37 +0000
Message-ID: <en0b4194avt27sdmu7r060p3ukdbs36r1j@4ax.com>

On Sat, 26 Mar 2005 10:06:38 +0100, "astalavista" <spam_at_nowhere.com> wrote:

>I try to start a remote database ...
>
>From my PC, connected as sysdba to a remote database ( 9i, AIX 5.1)
>(remote_login_passwordfile = exclusive, using spfile)
>
>- shutdown OK
>- startup, only start the instance,cannot mount the database
>
>Is there a way to startup a database remote ???
>( no OEM)

What problems are you having? Remote startup works just fine on 10g, and as far as I'm aware the principles haven't changed so should also work in 9i. You've already said you're using an SPFILE which simplifies the process. You might also have to statically define the instance in listener.ora, since it'll un-register when the database shuts down.

Example; excession is this Windows machine, test101 is on a linux machine next to it.

andyh_at_excession ~
$ sqlplus sys/sys_at_test101 as sysdba

SQL*Plus: Release 10.1.0.4.0 - Production on Sat Mar 26 15:40:51 2005

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 369098752 bytes

Fixed Size                   779256 bytes
Variable Size             326114312 bytes
Database Buffers           41943040 bytes
Redo Buffers                 262144 bytes

Database mounted.
Database opened.

-- 
Andy Hassall / <andy@andyh.co.uk> / <http://www.andyh.co.uk>
<http://www.andyhsoftware.co.uk/space> Space: disk usage analysis tool

Received on Sat Mar 26 2005 - 09:46:37 CST