[Spacewalk-list] Oracle XE archive log mode

[Sander Grendelman]

On Fri, Feb 18, 2011 at 03:01:43PM +0000, Kobus Bensch wrote:
>
> start a new instance:
> I am sure you do that by:
> sqlplus /nolog
> then execute
> startup mount
>
> this is where things go wrong.
> it always says:
> SQL> startup mount
> ORA-12162: TNS:net service name is incorrectly specified

You could try to connect directly (without going through the listener).

As user oracle:

sqlplus "/ as sysdba"

This connects directly to the DB using membership of the "dba" group for
authentication.

If the above does not work set your ORACLE_HOME and ORACLE_SID variables
either through sourcing /usr/local/bin/oraenv:
. oraenv

or by setting them manually:

export ORACLE_SID=XE
export ORACLE_HOME=/path/to/oracle_xe/home

While you're thinking about configuring the DB for archive log mode
take care to think of the following:

* Set the archive_log destination to a different filesystem (e.g. /arch)
  and monitor this filesystem, once the filesystem is full your DB will
  stop working.
* Use rman for back-ups, when configured correctly you can make back-ups
  to tape or to disk and clean old archive-log files automatically.

With kind regards,

Sander Grendelman.