cancel
Showing results for 
Search instead for 
Did you mean: 

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

mrinal_sarkar62
Level 6

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

 

7 REPLIES 7

Jaydeep_S
Level 6
Employee Accredited Certified

Try the steps mentioned in this technote

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

mrinal_sarkar62
Level 6

Hi,

Already tried done the step from the below link.

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

Thanks.

Jaydeep_S
Level 6
Employee Accredited Certified

See if configuration is done as mentioned in the technote below

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

mrinal_sarkar62
Level 6

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.

 

mrinal_sarkar62
Level 6

Hi,

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

 

 

Thanks.

mrinal_sarkar62
Level 6

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.

mrinal_sarkar62
Level 6

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>