![\"Oracle](\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2012\/12\/TDPerror.jpg\" "\\"Oracle_TDP_error\\"")
<\/a>SBT error = 7011 error for TDP for Oracle<\/p><\/div>\n
RMAN> backup database;<\/p>\n
Starting backup at 17-DEC-12<\/p>\n
RMAN-00571: ===========================================================<\/p>\n
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============<\/p>\n
RMAN-00571: ===========================================================<\/p>\n
RMAN-03002: failure of backup command at 12\/17\/2012 15:04:20<\/p>\n
ORA-19554: error allocating device, device type: SBT_TAPE, device name:<\/p>\n
ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer<\/p>\n
Linux-x86_64 Error: 106: Transport endpoint is already connected<\/p>\n
Additional information: 7011<\/p>\n
ORA-19511: Error received from media manager layer, error text:<\/p>\n
SBT error = 7011, errno = 106, sbtopen: system error<\/p>\n
<\/p>\n
Issue:<\/p>\n
The problem for both AIX & Linux is that the TDP client can not write to the tdpoerror.log file.\u00a0 When TDP is install, the person doing this is usually logged in as root or a super user, and the directory the log is stored is under the installer’s account name.<\/p>\n
Resolution:<\/p>\n
Change the permission on the file tdpoerror.log or its directory to allow the user \u2018oracle\u2019 to write to the error log.<\/p>\n
LINUX:<\/p>\n
- \n
- In the TDP for Oracle configuration file: \u2018tdpo.opt\u2019, find the parameter DSMI_LOG for the log file location.<\/li>\n<\/ol>\n
Default location for tdpo.opt:<\/p>\n
\/opt\/tivoli\/tsm\/client\/oracle\/bin64\/tdpo.opt<\/p>\n
In the tdpo.opt file find the parameter: DSMI_LOG<\/p>\n
Example: \u00a0DSMI_LOG\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/var\/logs\/oracle\/tdp<\/p>\n
2.\u00a0 Check the permissions of the DSMI_LOG location:<\/p>\n
Example: in folder in \/var\/logs\/oracle I found that it looked like below
\ndrwxr-xr-x 2 root\u00a0\u00a0 root\u00a0\u00a0\u00a0\u00a0\u00a0 4096 Nov 30 10:33 tdp<\/p>\nNote:\u00a0 the owner of the folder is root without write permission to the directory<\/p>\n
3.\u00a0 In the tdp folder, check the permissions tdpoerror.log<\/p>\n
I found that it looked like below:
\n-rw-r–r– 1 root root 2012 Nov 30 10:46 tdpoerror.log<\/p>\nAgain the log file was owned by root, and could not be written to.<\/p>\n
4.\u00a0 Fixing the permissions:<\/p>\n
As either root or some super user on the operating system, run the two commands below:<\/p>\n
chown oracle:dba \/var\/logs\/oracle\/tdp<\/span><\/p>\n
chown oracle:dba \/var\/logs\/oracle\/tdp\/tdpoerror.log<\/span><\/p>\n
Then I was able to run a successful backup in RMAN.<\/p>\n
<\/p>\n
AIX:<\/p>\n
The only difference from Linux above was the default location of the tdpo.opt file.<\/p>\n
\/usr\/tivoli\/tsm\/client\/oracle\/bin64\/dsm.opt<\/p>\n
Now back to testing my backups & restores in Oracle on Linux.<\/p>\n","protected":false},"excerpt":{"rendered":"