top of page

グループ

公開·16名のメンバー

ORA-12546: TNS: Permission Denied



I've read a lot on "ORA-12546: TNS:permission denied" on stackoverflow site, but all topics are concerning Linux. I tried to set read and execute permissions on c:\app\oracle, where my Oracle is installed. Actually, Administrators already by default had all permissions on that directory, so it did not make any difference




ORA-12546: TNS: Permission Denied



Problem:Only-tables are exported fine, but with owner=myuser export key I get TNS:permission denied, and only if Windows scheduled task is started by schedule, while manually started task does everything OK. How do I make it export all, and by schedule?


  • Hello Pankaj,\\n\\nDo you have previous screenshots??\\n\\nRegards,\\nJaved\",\"author\":\"username\":\"former.member\",\"displayName\":\"Former Member\",\"groupIcons\":[],\"suspended\":true,\"isCurrentUser\":false,\"id\":12592566,\"posted\":1473775371000,\"votes\":0,\"isAccepted\":false,\"isLocked\":false,\"userVoted\":\"\",\"relations\":\"canCancelAccept\":false,\"canUnlock\":false,\"canUseDelete\":false,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canAccept\":false,\"type\":\"answer\",\"canVoteUpOrCancel\":false,\"isCurrentUserAuthor\":false,\"attachments\":[]},\"body\":\"Hi,\\n\\nORA-12546: TNS:permission denied is due to insufficient privileges to the user has, below link may be helpful to you..\\n\\n -oracle.com/t_ora_12546_tns_permission_denied.htm\\n\\nRegards,\\nJaved\",\"author\":\"username\":\"former.member\",\"displayName\":\"Former Member\",\"groupIcons\":[],\"suspended\":true,\"isCurrentUser\":false,\"id\":12592568,\"posted\":1473775927000,\"votes\":0,\"isAccepted\":false,\"isLocked\":false,\"userVoted\":\"\",\"relations\":\"canCancelAccept\":false,\"canUnlock\":false,\"canUseDelete\":false,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canAccept\":false,\"type\":\"answer\",\"canVoteUpOrCancel\":false,\"isCurrentUserAuthor\":false,\"attachments\":[],\"body\":\"Hello,\\n\\nThis could possibly be related to the umask that was set when the Oracle installation was done as well as the groups that the oracle user belongs to.\\n\\nPlease show the permissions of the oracle home directory as well as the permissions of the file named oracle found under ORACLE_HOME/bin.\\n\\nKR,\\n\\nAmerjit\",\"author\":\"username\":\"former.member\",\"displayName\":\"Former Member\",\"groupIcons\":[],\"suspended\":true,\"isCurrentUser\":false,\"id\":12592446,\"posted\":1473776292000,\"votes\":0,\"isAccepted\":false,\"isLocked\":false,\"userVoted\":\"\",\"relations\":\"canCancelAccept\":false,\"canUnlock\":false,\"canUseDelete\":false,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canAccept\":false,\"type\":\"answer\",\"canVoteUpOrCancel\":false,\"isCurrentUserAuthor\":false,\"attachments\":[],\"body\":\"Hi,For this case, please refer to SAP note 583861. It should help.Best regards,James\",\"author\":\"username\":\"james.zhang4\",\"displayName\":\"James Zhang\",\"groupIcons\":[\"name\":\"topic-expert\",\"title\":\"This user is a Topic Expert\",\"priority\":19,\"name\":\"employee\",\"title\":\"This user is an SAP Employee\",\"priority\":21],\"suspended\":false,\"isCurrentUser\":false,\"id\":12593357,\"posted\":1473821048000,\"votes\":0,\"isAccepted\":false,\"isLocked\":false,\"userVoted\":\"\",\"relations\":\"canCancelAccept\":false,\"canUnlock\":false,\"canUseDelete\":false,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canAccept\":false,\"type\":\"answer\",\"canVoteUpOrCancel\":false,\"isCurrentUserAuthor\":false,\"attachments\":[],\"body\":\"So Permission issue ultimately, Huh? Thought so. Could you check whether login/connect through ORASID happening or not? So here my guess TNS Listener would also not work as same is issue with TNS_ADMIN matter.\",\"author\":\"username\":\"kaus19d\",\"displayName\":\"Kaushik Debnath\",\"groupIcons\":[],\"suspended\":false,\"isCurrentUser\":false,\"id\":12595928,\"posted\":1473931058000,\"votes\":0,\"isAccepted\":false,\"isLocked\":false,\"userVoted\":\"\",\"relations\":\"canCancelAccept\":false,\"canUnlock\":false,\"canUseDelete\":false,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canAccept\":false,\"type\":\"answer\",\"canVoteUpOrCancel\":false,\"isCurrentUserAuthor\":false,\"attachments\":[],\"body\":\"Which user was used installing the Oracle Software? Either 'oracle' or 'ora' must be used...Which user did the SWPM installation? Only 'root' is permitted....Usually no explicit environment variables have to be set after having installed the Oracle software...the DB owner is created through SWPM before the step \\\"DB SW INSTALLATION\\\" and usually will be equipped with all needed rights and the correct environment...What were your exact steps and in which order did you execute these steps?GreetZ, AH\",\"author\":\"username\":\"andreas.herzog\",\"displayName\":\"Andreas Herzog\",\"groupIcons\":[],\"suspended\":false,\"isCurrentUser\":false,\"id\":12600976,\"posted\":1474289034000,\"votes\":0,\"isAccepted\":false,\"isLocked\":false,\"userVoted\":\"\",\"relations\":\"canCancelAccept\":false,\"canUnlock\":false,\"canUseDelete\":false,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canAccept\":false,\"type\":\"answer\",\"canVoteUpOrCancel\":false,\"isCurrentUserAuthor\":false,\"attachments\":[]]"), answerForm: formAction: "/answers/12592537/post.json", textareaName: "body", textareaErrors: "", isAttachmentsEnabled: true, answerEditorialGuideline: title: "Before answering", content: "You should only submit an answer when you are proposing a solution to the poster\'s problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that your answer complies with our Rules of Engagement.", links: [ title: "Rules of Engagement", href: " -of-engagement.html", ] , answerMinBodyLength: '10', answerMaxBodyLength: '20000' , currentUser: sapInternalId: '', permissions: canVoteUpOrCancel: false, canVoteDownOrCancel: false, canModerate: false, , isVotedUp: false, isVotedDown: false , alerts: alertModeratorMinLength : "It should be given a proper explanation about why the content is inappropriate.", alertModeratorMinLengthValue : "10", alreadyReportedMessage : "You already have an active moderator alert for this content." , url: profileApiBaseUrl: ' -api.services.sap.com', followUnfollowQuestion: '/sap/nodeSubscription.json', isFollowingQuestion: '/sap/isFollowingNode.json', vote: voteUp: '/commands/0/voteup.json', voteDown: '/commands/0/votedown.json', cancelVote: '/commands/0/cancelvote.json' , rss: answers: '/feed/12592537/answers.rss', answersAndComments: '/feed/12592537/comments-and-answers.rss' , authorizeUploadContext: type: 'answer' , atMention: userSearchServiceUrl: ' ', currentUserName: '', useNewUSSCORS: true, atMentionDelayMs: 100, showMentionInRedactor: true , attachmentSettings: commentMaxAttachments: '2', answerMaxAttachments: '10', commentMaxAttachmentSizeBytes: '1048576', answerMaxAttachmentSizeBytes: '1048576', commentAttachmentsSizeBytesTotal: '2097152', answerAttachmentsSizeBytesTotal: '10485760' , editor: editorClipboardUploadEnabled: true }) })(); Home

  • Community

  • Ask a Question

  • Write a Blog Post

Login / Sign-up Search Questions and Answers 0 Former Member Sep 13, 2016 at 01:51 PM SAP ECC import -ORACL 12C installation Issue-12546 TNS permission Denied 412 Views Follow RSS Feed Dear Team,


Added new server, so I updated the scripts to include possibility of more server names. After cluster failover to new server, of the four DB, three run fine, archive and DB, the fourth gives me the ORA-12546: TNS:permission denied error when run from NB, or as root from the server. When run as oracle by running the script, it works fine.


The cause is either listener owner can't access oracle binary in database home:ls -l $RDBMS_HOME/bin/oraclels: /home/oracle/app/oracle/product/11.2/db/bin/oracle: Permission deniedOROracle binary in database home got wrong permission:ls -l $RDBMS_HOME/bin/oracle-rwxr-x--x 1 ogrid oinstall 184286251 Aug 9 16:25 /home/oracle/app/oracle/product/11.2/db/bin/oracle>> Note oracle binary should have permission of 6751; so output should be:ls -l $RDBMS_HOME/bin/oracle-rwsr-s--x 1 ogrid oinstall 184286251 Aug 9 16:25 /home/oracle/app/oracle/product/11.2/db/bin/oracle


We see that we get a Permission denied error when trying to view the contents of the directory when the read permission has been revoked. Despite not being able to see what is in the directory we can still change our working directory to that directory.


(HOUR = XYZYY) (USER = yyyyyy))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XXXX) (INSTANCE_NAME = XXXX) (CID = (PROGRAM = aaaaaaaaaaaaaaaaaaaaaaaaaaaa) (ADDRESS = (PROTOCOL = tcp) (HOST = XXX.XXX.XXX.XXX) (PORT = 3860)) * establish * XXXX * 12500TNS-12500: TNS: listener failed to start a dedicated server processTNS-12546: TNS: permission deniedTNS-12560: TNS: protocol adapter errorTNS-00516: Permission denied32-bit Windows Error: 5: Input / output error


In my hope PC I have Windows XP, I am going to install Oracle 9i,Installation completed successfully except 'Agent Configuration Assistant' failed.When I am trying to start the listener services from the Windows Service Utility, i am getting the following error for couple of services namely --OracleOraHome92Agent,OracleOraHome92HTTPServer,OracleOraHome92PagingServerOracleOraHome92TNSListener etc.Error:The Oracle81listenerTNSListener on Local Computer Started and then Stopped. Some services stop automatically if they have no work to do, for example, the Performance Logs and Alert serviceIf i delete all my previous listener services from oracle through "Net Manager", although these listener services are showing in the " Window's Service window" --why?When i am trying to run listener from windows command prompt, getting the following errorTNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - ProductionSystem parameter file is E:\oracle\ora92\network\admin\listener.oraLog messages written to E:\oracle\ora92\network\log\listener.logError listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=home-8bdc697937)(PORT=1521)))TNS-12546: TNS:permission denied TNS-12560: TNS:protocol adapter error TNS-00516: Permission denied 32-bit Windows Error: 13: Permission deniedListener failed to start. See the error message(s) above...How to proceed?


グループについて

グループへようこそ!他のメンバーと交流したり、最新情報をチェックしたり、動画をシェアすることもできます。
bottom of page