Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Oracle on Linux backup issue - TNS:Permission access denied.

Created: 03 Oct 2013 | 7 comments

Hi,

We have the following.

Backup Exec 2010 R2 on Windows 2003 Ent. SP2 (32bit). As Master and Media server

RALUS of BE 2010 R2 installed on RHEL 5.4 64 Bit. as BE Client.

Now, we are configing the RALUS for Oracle backup.

We have completed the RALUS installation and the Linux server is showing the root folder.

Now, we have tried configuration of  Oracle authentication and instance authentication.

I have done this above task using a seperate User ID other then root.

I have selected not to use the recovery catalog for taking backup and default templet.

**************

In the BE server side console.

I see the all the instance and are in open state...

I can able to select the instance and recovery catlog fron the selection list.

But when executing the job its givind the error...

The script have a error.

in the script it give the below error.

ORA-12546: TNS:permission denied

Please, help...

Thanks

Operating Systems:

Comments 7 CommentsJump to latest comment

mrinal.sarkar6200's picture

Hi,

Already tried done the step from the below link.

http://www.symantec.com/docs/TECH135058

Thanks.

Certified Symantec Professional.

Work mostly with Netbackup, Backup Exec, Storage Foundation, DLO and System Recovery

Mrinal Sarkar

Howrah, India

________________________

mrinal.sarkar6200's picture

Hi,

See...

We have no password for RMAN as I have checked and tried to log in as RMAN and there is no password asked and streaght it providing the ...SQL> promt...

And either I have used the recovery catalog..

I have selected "NO" when asked for use of Oracle Recovery Catalog...

Its aksed for templet I have just pressed "Enter"..

The templet was taken as default...

Just to add.... I have checked and found that archive logs is being generated...

So, do I need to use the recovery catalog for taking Oracle backup...or as per the technot I can choose "No" and it can use the "Control" file for metadata storage...

Is my steps correct... or I must use the Oracle Recovery catalog...and provide the TNS name as mentioned in the technote...

Thanks.

Certified Symantec Professional.

Work mostly with Netbackup, Backup Exec, Storage Foundation, DLO and System Recovery

Mrinal Sarkar

Howrah, India

________________________

mrinal.sarkar6200's picture

Hi,

Any updates....................

Thanks.

Certified Symantec Professional.

Work mostly with Netbackup, Backup Exec, Storage Foundation, DLO and System Recovery

Mrinal Sarkar

Howrah, India

________________________

mrinal.sarkar6200's picture

Hi,

Here is the oracle logs.

***********************************************************************

Recovery Manager: Release 10.2.0.5.0 - Production on Fri Oct 4 16:53:47 2013

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

 # -----------------------------------------------------------------

 # RMAN command section

 # -----------------------------------------------------------------

 RUN {

 ALLOCATE CHANNEL ch0

     TYPE 'SBT_TAPE';

 SEND 'BSA_SERVICE_HOST=192.xxx.xx.xxx,NBBSA_TOTAL_STREAMS=1,NBBSA_JOB_COOKIE={11CBFAE9-7FEA-4965-8FF9-E90F0C772084},NBBSA_DB_DEVICE_NAME=Oracle-Linux::\\appdb02\xyzDB';

 BACKUP

     INCREMENTAL LEVEL=0

     FORMAT 'BE_U'

     TABLESPACE

         'EHIS_DATA' FORCE;

 BACKUP CURRENT CONTROLFILE

     FORMAT 'BE_U';

  RELEASE CHANNEL ch0;

 }

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

ORA-12546: TNS:permission denied

Recovery Manager complete.

*****************************************

Thanks.

Certified Symantec Professional.

Work mostly with Netbackup, Backup Exec, Storage Foundation, DLO and System Recovery

Mrinal Sarkar

Howrah, India

________________________

mrinal.sarkar6200's picture

Hi,

I have output the RMAN "SHOW ALL" command  and below is the output.

RMAN> SHOW ALL;

RMAN configuration parameters are:

CONFIGURE RETENTION POLICY TO REDUNDANCY 1;

CONFIGURE BACKUP OPTIMIZATION OFF;

CONFIGURE DEFAULT DEVICE TYPE TO DISK;

CONFIGURE CONTROLFILE AUTOBACKUP OFF;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F';

CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET;

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;

CONFIGURE MAXSETSIZE TO UNLIMITED;

CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_MKPRD.f'; # default

RMAN>

Certified Symantec Professional.

Work mostly with Netbackup, Backup Exec, Storage Foundation, DLO and System Recovery

Mrinal Sarkar

Howrah, India

________________________