[Spacewalk-list] Oracle XE archive log mode
Sander Grendelman
sander at grendelman.com
Fri Feb 18 15:53:43 UTC 2011
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.
More information about the Spacewalk-list
mailing list