Archive

Archive for March, 2013

ORA-07217: sltln: environment variable cannot be evaluated when backing up with RMAN

March 28th, 2013 No comments

When setting up a RMAN backup to tape i encountered the following issue on a Oracle 9.2 database (not sure if it applies to older database versions; i¬īd say no…):

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-07217: sltln: environment variable cannot be evaluated.

It turned out the script used to start the rman backup was the problem:

connect target /
connect catalog rman/rman@catalog
run {
backup database;
}

After changing the target connection line to include the username, password and TNS connect string the backup ran fine:

connect target sys/sys@database
connect catalog rman/rman@catalog
run {
backup database;
}

 

 

Categories: Oracle in general Tags:

Networker: Add a user to the Administrator list from the command line

March 14th, 2013 No comments

In case you locked yourself out of the Networker you can add a user from the command line with the following command:

 

nsraddadmin -u "user=administrator, host=machine1"
Categories: Oracle in general Tags: