Oracle Error Ora-12546
Contents |
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page.
Ora-12546 Windows 7
Please enter a title. You can not post a blank message. Please ora 12546 tns permission denied oracle 10g type your message and try again. More discussions in General Database Discussions All PlacesDatabaseGeneral Database Discussions This discussion
Ora-12546 Tns Permission Denied Windows 8
is archived 11 Replies Latest reply on Mar 11, 2012 10:45 PM by 923047 ORA-12546: TNS:permission denied 923047 Mar 11, 2012 12:35 AM Hi, i've installed Oracle 10g on Windows ora-12546 error during installation 7 x64 and i have the following issue. When i try to connect to the database i get the following error ORA-12546: TNS:permission denied I've searched on google about this and didn't find anything usefull. I have the listener service as well as the other oracle services running in Local System Account I have a group called ora_dba "Oracle ora-12546: tns:permission denied sqlplus DBA Group" in wich my user account, the administrator account and the system account are. I put the output of LSNRCTL status LSNRCTL> status Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ORIOM)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for 32-bit Windows: Version 10.1.0.2.0 - Produ ction Start Date 10-MAR-2012 20:05:45 Uptime 0 days 1 hr. 27 min. 59 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File D:\oracle\product\10.1.0\Db_1\network\admin\listener.o ra Listener Log File D:\oracle\product\10.1.0\Db_1\network\log\listener.log Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ORIOM)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROCipc))) Services Summary... Service "PLSExtProc" has 1 instance(s). Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully There is a copy of tnsnames.ora # tnsnames.ora Network Configuration File: D:\oracle\product\10.1.0\Db_1\NETWORK\ADMIN\tnsnames.ora # Generated by Oracle configuration tools. ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ORIOM)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) ) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) ) there is a copy of listener.ora #
Last updated: April 22, 2016 - 4:40 am UTC Category: SQL*Plus � Version: 9.2.0 Whilst you are here, check out some content from the AskTom team: Is the Function Result Cache operative on my
Tns Permission Denied Oracle 10g Windows 7
database? Latest Followup You Asked i'm running oracle on standalone computer at home.it ora 12546 tns permission denied root used to work properly but from couple of days i'm getting error stating "ORA-12560: TNS:protocol adapter error " what
Ora 12546 Tns Permission Denied Oracle 12c
should i do? please help.. (scott/tiger) and we said... sounds like the database is not up. you probably restarted your machine and the instance is not set to autostart C:\Documents and Settings\tkyte>sqlplus https://community.oracle.com/thread/2360220 scott/tiger SQL*Plus: Release 10.1.0.4.0 - Production on Thu Sep 6 15:43:55 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Production With the Partitioning, OLAP and Data Mining options scott%ORA10GR1> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Production With the Partitioning, OLAP and Data Mining options C:\Documents and Settings\tkyte>net stop https://asktom.oracle.com/pls/asktom/f?p=100:11:0::NO::P11_QUESTION_ID:431775600346873836 oracleserviceora10gr1 The OracleServiceORA10GR1 service is stopping......... The OracleServiceORA10GR1 service was stopped successfully. C:\Documents and Settings\tkyte>sqlplus scott/tiger SQL*Plus: Release 10.1.0.4.0 - Production on Thu Sep 6 15:44:35 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. ERROR: ORA-12560: TNS:protocol adapter error Enter user-name: ERROR: ORA-12560: TNS:protocol adapter error Enter user-name: ERROR: ORA-12560: TNS:protocol adapter error SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus C:\Documents and Settings\tkyte>net start oracleserviceora10gr1 The OracleServiceORA10GR1 service is starting.......... The OracleServiceORA10GR1 service was started successfully. C:\Documents and Settings\tkyte>sqlplus scott/tiger SQL*Plus: Release 10.1.0.4.0 - Production on Thu Sep 6 15:45:12 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Production With the Partitioning, OLAP and Data Mining options scott%ORA10GR1> in the above ora10gr1 is my oracle sid, you can use control panel instead - control panel -> services -> look for the services starting with Oracle. Reviews Write a Review Another method September 10, 2007 - 3:15 am UTC Reviewer: Arangaperumal G from Chennai,India Start --> Run--> type " services.msc" Select the OracleService name, Right Click, Start. ora-12560 August 27,
SonicWALL User Sorry, we are having issues processing your request. If you own the SonicWALL product requested please confirm that you have registered your product https://support.software.dell.com/shareplex/kb/526 at My SonicWALL . If you have already registered your product then http://stackoverflow.com/questions/21875191/how-to-configure-oracle-11g-to-launch-sqlplus please contact Customer Service directly for further assistance at customerservice@software.dell.com. Continue × Support Forms Under Maintenance Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience. Continue Search Sign In Sign In Create Support permission denied Account Products ActiveRoles Boomi Change Auditor Foglight Identity Manager KACE Migration Manager Rapid Recovery Recovery Manager SharePlex SonicWALL Spotlight Statistica Toad View all Products Solutions Application & Data Integration Big Data Analytics Business Intelligence Cloud Management Data Protection Overview Backup and Recovery Deduplication and Compression Database Development and Management Database Replication & Backup Endpoint Management Mobile Workforce Management Overview Desktop Virtualization Enterprise tns permission denied Mobility Management Endpoint Security Network Security Secure Remote Access Performance Monitoring Security Overview Email Security Endpoint Security Identity & Access Management Network Security Secure Remote Access Virtualization Management Microsoft Platform Management View all Solutions Solutions by Platform Active Directory Exchange Google GroupWise & NDS Hadoop Hyper-V Lotus Notes Skype for Business/Lync Office 365 Oracle SharePoint SQL Server VMware Trials Buy Support By Product Line Enterprise Reporter Foglight KACE Migration Manager Migrator NetVault One Identity Quick Connect Performance Analysis Recovery Manager Shareplex SonicWALL Spotlight SQL Navigator Toad All Products Contact Support Download Software Knowledge Base My Account My Products My Service Requests My Licenses My Groups My Profile Policies & Procedures Professional Services Technical Documentation Training & Certification User Forums Video Tutorials Support Home Communities Partners × Email Share your favorite Support content with a friend. Email To Email From Subject Information from Dell Software Support Message You might be interested in the following information For more information regarding support on your Dell Software Product, please visit www.software.dell.com/support Print Email My Downloads () Support Knowledge Base SharePlex ORA-12546 TNS:permission denied (526) × Return Ti
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up How to configure Oracle 11g to launch sqlplus? up vote 1 down vote favorite On a RedHat 6 server, a third party application requires to be root to run and needs access to sqlplus. I have a running database, I can run sqlplus as user 'oracle'. When logged in as user root, 'sqlplus usr/pwd@dbname' works as expected. The trouble is that this agent needs to run sqlplus with no parameters and it always returns ORA-12546: TNS:permission denied. I've read a dozen times that enabling root to launch Oracle is a security issue but I really have no other choice. Running Oracle 11.2.0.1.0. Any help will be much appreciated as I've googled for 2 days with no success. oracle11g root sqlplus share|improve this question asked Feb 19 '14 at 8:45 PierreVn 1513 You haven't said what you've tried so this could get repetitive. Presumably you have the environment variables (ORACLE_HOME, TNS_ADMIN, ORACLE_SID...) set up properly, or I think you'd see different errors. Are you using the full Oracle install, and is there anything odd about the permissions in your ORACLE_HOME? I would suggest you have a separate installation of the instant client for root to use to keep as much separation as possible - is that feasible? –Alex Poole Feb 19 '14 at 11:09 I have the exact same environment variable for root than for the oracle user. Yes, its a standard Enterprise Oracle installation. I checked the file permissions and ownership with another server that runs as expected but couldn't find a difference and so I suspect it's related to a configuration somewhere. Unfortunately, installing a separate client for root is not possible in this context. I feel this is a problem with the listener configuration, much more than the database. Thanks for your investigations, so far. –PierreVn Feb 19 '14 at 12:22 Yes, I'm just launching sqlplus and rely on ORACLE_SI