cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Veritas.com
Support

ORA-12546??

CSguy
Level 2

‎10-23-2007 07:33 AM

I am quite new to Oracle backups and I am sure this is an easy one. I am trying to backup an Oracle database but I get the error below. I created all the logs according to the manual and only one logged. Anyone kind enough to let me know what I am doing wrong? Thanks in advance

Master: 5.1mp6 windows
Media: same as master
Client: 5.1 mp6 Oracle 10g  linux

Error:

ORA-12546 TNS:permission denied

From log bpdbsbora

10:27:09.166 [17207] <2> main bpdbsbora: *****************************.
10:27:09.179 [17207] <2> DBSB_SetVerboseLevel(): Verbose is set to 0
10:27:12.832 [17209] <2> main bpdbsbora: *****************************.
10:27:12.909 [17209] <2> DBSB_SetVerboseLevel(): Verbose is set to 0
10:27:12.921 [17209] <2> PrintTPC: rman_defaults=1
10:27:27.641 [17220] <2> main bpdbsbora: *****************************.
10:27:27.643 [17220] <2> DBSB_SetVerboseLevel(): Verbose is set to 0
10:27:53.310 [17228] <2> main bpdbsbora: *****************************.
10:27:53.312 [17228] <2> DBSB_SetVerboseLevel(): Verbose is set to 0
10:27:53.917 [17229] <2> main bpdbsbora: *****************************.
10:27:53.919 [17229] <2> DBSB_SetVerboseLevel(): Verbose is set to 0
10:27:53.938 [17230] <2> main bpdbsbora: *****************************.
10:27:53.943 [17230] <2> DBSB_SetVerboseLevel(): Verbose is set to 0
10:27:54.197 [17230] <2> logconnections: BPRD CONNECT FROM 10.10.2.35.50254 TO 10.10.2.10.13720
10:27:54.370 [17230] <2> logconnections: BPRD CONNECT FROM 10.10.2.35.50255 TO 10.10.2.10.13720
10:27:55.901 [17230] <2> logconnections: BPRD CONNECT FROM 10.10.2.35.50256 TO 10.10.2.10.13720
10:27:57.024 [17230] <2> RMAN_ExecTemplate(): Begin progress logging to file /usr/openv/netbackup/logs/user_ops/root/logs/jbpBd1WRz.log
10:27:57.026 [17230] <2> logconnections: BPRD CONNECT FROM 10.10.2.35.50258 TO 10.10.2.10.13720
10:27:58.109 [17230] <2> sbint_GetPolicyInfo(): User initiated backup
10:27:58.109 [17230] <2> sbint_GetPolicyInfo(): Using Policy <oracle>, Schedule <unspecified>.
10:27:58.113 [17230] <2> logconnections: BPRD CONNECT FROM 10.10.2.35.50259 TO 10.10.2.10.13720
10:27:58.335 [17230] <4> sbint_GetPolicyInfo(): Using policy oracle to perform a user directed Standard backup.
10:27:58.345 [17230] <2> logconnections: BPRD CONNECT FROM 10.10.2.35.50260 TO 10.10.2.10.13720
10:27:59.524 [17230] <2> logconnections: BPRD CONNECT FROM 10.10.2.35.50261 TO 10.10.2.10.13720
10:28:00.603 [17230] <2> logconnections: BPRD CONNECT FROM 10.10.2.35.50262 TO 10.10.2.10.13720
10:28:01.688 [17230] <2> logconnections: BPRD CONNECT FROM 10.10.2.35.50263 TO 10.10.2.10.13720
10:28:02.807 [17230] <2> Run_cmd():

***************** BEGIN LOGGING RMAN INPUT *****************

10:28:02.811 [17230] <2> logconnections: BPRD CONNECT FROM 10.10.2.35.50264 TO 10.10.2.10.13720
# -----------------------------------------------------------------
# RMAN command section
# -----------------------------------------------------------------
RUN {
ALLOCATE CHANNEL ch00
    TYPE 'SBT_TAPE';
SEND 'NB_ORA_CLIENT=oracle,NB_ORA_POLICY=oracle,NB_ORA_SERV=50master';
SEND 'NB_ORA_PLOG=/usr/openv/netbackup/logs/user_ops/root/logs/jbpBd1WRz.log';
BACKUP
    INCREMENTAL LEVEL=0
    FORMAT 'bk_u%u_s%s_p%p_t%t'
    DATABASE;
[root@oracle bpdbsbora]# cat log.102307
10:27:09.166 [17207] <2> main bpdbsbora: *****************************.
10:27:09.179 [17207] <2> DBSB_SetVerboseLevel(): Verbose is set to 0
10:27:12.832 [17209] <2> main bpdbsbora: *****************************.
10:27:12.909 [17209] <2> DBSB_SetVerboseLevel(): Verbose is set to 0
10:27:12.921 [17209] <2> PrintTPC: rman_defaults=1
10:27:27.641 [17220] <2> main bpdbsbora: *****************************.
10:27:27.643 [17220] <2> DBSB_SetVerboseLevel(): Verbose is set to 0
10:27:53.310 [17228] <2> main bpdbsbora: *****************************.
10:27:53.312 [17228] <2> DBSB_SetVerboseLevel(): Verbose is set to 0
10:27:53.917 [17229] <2> main bpdbsbora: *****************************.
10:27:53.919 [17229] <2> DBSB_SetVerboseLevel(): Verbose is set to 0
10:27:53.938 [17230] <2> main bpdbsbora: *****************************.
10:27:53.943 [17230] <2> DBSB_SetVerboseLevel(): Verbose is set to 0
10:27:54.197 [17230] <2> logconnections: BPRD CONNECT FROM 10.10.2.35.50254 TO 10.10.2.10.13720
10:27:54.370 [17230] <2> logconnections: BPRD CONNECT FROM 10.10.2.35.50255 TO 10.10.2.10.13720
10:27:55.901 [17230] <2> logconnections: BPRD CONNECT FROM 10.10.2.35.50256 TO 10.10.2.10.13720
10:27:57.024 [17230] <2> RMAN_ExecTemplate(): Begin progress logging to file /usr/openv/netbackup/logs/user_ops/root/logs/jbpBd1WRz.log
10:27:57.026 [17230] <2> logconnections: BPRD CONNECT FROM 10.10.2.35.50258 TO 10.10.2.10.13720
10:27:58.109 [17230] <2> sbint_GetPolicyInfo(): User initiated backup
10:27:58.109 [17230] <2> sbint_GetPolicyInfo(): Using Policy <oracle>, Schedule <unspecified>.
10:27:58.113 [17230] <2> logconnections: BPRD CONNECT FROM 10.10.2.35.50259 TO 10.10.2.10.13720
10:27:58.335 [17230] <4> sbint_GetPolicyInfo(): Using policy oracle to perform a user directed Standard backup.
10:27:58.345 [17230] <2> logconnections: BPRD CONNECT FROM 10.10.2.35.50260 TO 10.10.2.10.13720
10:27:59.524 [17230] <2> logconnections: BPRD CONNECT FROM 10.10.2.35.50261 TO 10.10.2.10.13720
10:28:00.603 [17230] <2> logconnections: BPRD CONNECT FROM 10.10.2.35.50262 TO 10.10.2.10.13720
10:28:01.688 [17230] <2> logconnections: BPRD CONNECT FROM 10.10.2.35.50263 TO 10.10.2.10.13720
10:28:02.807 [17230] <2> Run_cmd():

***************** BEGIN LOGGING RMAN INPUT *****************

10:28:02.811 [17230] <2> logconnections: BPRD CONNECT FROM 10.10.2.35.50264 TO 10.10.2.10.13720
# -----------------------------------------------------------------
# RMAN command section
# -----------------------------------------------------------------
RUN {
ALLOCATE CHANNEL ch00
    TYPE 'SBT_TAPE';
SEND 'NB_ORA_CLIENT=oracle,NB_ORA_POLICY=oracle,NB_ORA_SERV=50master';
SEND 'NB_ORA_PLOG=/usr/openv/netbackup/logs/user_ops/root/logs/jbpBd1WRz.log';
BACKUP
    INCREMENTAL LEVEL=0
    FORMAT 'bk_u%u_s%s_p%p_t%t'
    DATABASE;
RELEASE CHANNEL ch00;
# Backup Archived Logs
sql 'alter system archive log current';
ALLOCATE CHANNEL ch00
    TYPE 'SBT_TAPE';
SEND 'NB_ORA_CLIENT=oracle,NB_ORA_POLICY=oracle,NB_ORA_SERV=50master';
SEND 'NB_ORA_PLOG=/usr/openv/netbackup/logs/user_ops/root/logs/jbpBd1WRz.log';
BACKUP
    FORMAT 'arch-s%s-p%p-t%t'
    ARCHIVELOG
        ALL
    DELETE INPUT;
RELEASE CHANNEL ch00;
# Control file backup
ALLOCATE CHANNEL ch00
    TYPE 'SBT_TAPE';
SEND 'NB_ORA_CLIENT=oracle,NB_ORA_POLICY=oracle,NB_ORA_SERV=50master';
SEND 'NB_ORA_PLOG=/usr/openv/netbackup/logs/user_ops/root/logs/jbpBd1WRz.log';
BACKUP
    FORMAT 'bk_u%u_s%s_p%p_t%t'
10:28:03.929 [17230] <2> logconnections: BPRD CONNECT FROM 10.10.2.35.50265 TO 10.10.2.10.13720
    CURRENT CONTROLFILE;
RELEASE CHANNEL ch00;
}
10:28:05.098 [17230] <2> Run_cmd():

***************** FINISHED LOGGING RMAN INPUT *****************

10:28:05.102 [17230] <2> logconnections: BPRD CONNECT FROM 10.10.2.35.50266 TO 10.10.2.10.13720
10:28:06.275 [17230] <2> logconnections: BPRD CONNECT FROM 10.10.2.35.50267 TO 10.10.2.10.13720
10:28:07.409 [17230] <2> Run_cmd():

***************** BEGIN LOGGING RMAN OUTPUT *****************

10:28:07.423 [17230] <2> logconnections: BPRD CONNECT FROM 10.10.2.35.50269 TO 10.10.2.10.13720
Recovery Manager: Release 10.2.0.1.0 - Production on Tue Oct 23 10:28:03 2007
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-12546: TNS:permission denied
Recovery Manager complete.
10:28:08.489 [17230] <2> logconnections: BPRD CONNECT FROM 10.10.2.35.50270 TO 10.10.2.10.13720
10:28:09.678 [17230] <2> Run_cmd():

***************** FINISHED LOGGING RMAN OUTPUT *****************

10:28:09.683 [17230] <2> logconnections: BPRD CONNECT FROM 10.10.2.35.50271 TO 10.10.2.10.13720
10:28:10.822 [17230] <16> Run_rman_cmd(): error occured while trying to execute command </u01/app/oracle/product/10.2.0/db_1/bin/rman  target 'SYS/*****' nocatalog>
10:28:10.823 [17230] <16> RMAN_ExecTemplate(): Run_rman_cmd() failed
10:28:10.825 [17230] <2> logconnections: BPRD CONNECT FROM 10.10.2.35.50272 TO 10.10.2.10.13720
10:28:11.864 [17230] <2> logconnections: BPRD CONNECT FROM 10.10.2.35.50273 TO 10.10.2.10.13720
10:28:12.958 [17230] <16> main bpdbsbora: Error in call to DBSB_ExecTemplate()
10:28:12.958 [17230] <16> main bpdbsbora: Could not execute /u01/app/oracle/product/10.2.0/db_1/bin/rman  target 'SYS/*****' nocatalog
10:28:12.958 [17230] <16> main bpdbsbora: Exited with status <1>



-Steve
0 Kudos
3 REPLIES 3

bbelang
Level 2
Partner

‎10-23-2007 08:46 PM

Have you check your user and password for those TNSname ?
Have you specified correct user, password, and TNSname string in your Oracle backup script  or template?


BBelang
0 Kudos

Stumpr2
Level 6

‎10-24-2007 06:40 AM

Are they being run by the oracle user?
 
0 Kudos

CSguy
Level 2

‎10-26-2007 08:40 AM

When I start the backup and I fill out the forms the part where it asks for authentication info I put in the user/pass for SYS user. From your postings I will try changing that information to Oracle user's credentials and let you guys know. Thanks for your patience and help.
0 Kudos