This activating/setting of oracle is one of the adjustments in the installation of the SAS sosftware. oracle sas share|improve this question edited Nov 1 '13 at 15:32 Joe 43.8k52442 asked Nov 1 '13 at 15:28 user2945445 11 I'm not convinced this isn't an Oracle error, Do I need to cut and paste this as the path exactly as below? Should I define the relations between tables in database or just in code? this contact form
No need for the TNSPING test. Used parameter files: C:\Oracle\Network\Admin\sqlnet.ora Used EZCONNECT adapter to resolve the alias Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=macbook))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.110)(PORT=1521))) OK (10 msec) C:\>type C:\Oracle\Network\Admin\listener.ora # listener.ora Network Configuration File: C:\Oracle\network\admin\listener.ora # Generated by Oracle configuration I am getting ORA-12154. If so, why is it allowed?
The code I used to try and connect to Oracle is below. Type:Usage NotePriority:Topic:Data Management ==> Data Sources ==> External Databases ==> OracleSAS Reference ==> LIBNAME EnginesDate Modified:2005-12-05 15:12:30Date Created:2005-11-29 23:00:11 This content is presented in an iframe, which your browser does not Join them; it only takes a minute: Sign up Cannot connect with SAS LIBNAME up vote 0 down vote favorite I can connect to schema and tables through TOAD, but when Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options INSTANCE_NUMBER INSTANCE_NAME --------------- ---------------- HOST_NAME ---------------------------------------------------------------- VERSION STARTUP_T STATUSPARTHREAD# ARCHIVE LOG_SWITCH_WAIT -----------------
Your cache administrator is webmaster. Why is international first class much more expensive than international economy class? This is not working for me. Tnsping Before server side scripting how were HTML forms interpreted Abstract definition of convex set FTDI Breakout with additional ISP connector Why does Fleur say "zey, ze" instead of "they, the" in
You can not post a blank message. The value I gave it was "c:\oracle\product\10.2.0\client_1". Try to connect using SQL Plus from the computer that runs SAS - that would be equivalent of what SAS does. http://stackoverflow.com/questions/19729869/cannot-connect-with-sas-libname But if customers choose to # install "Software Only", this file wont exist and without the native # authentication, they will not be able to connect to the database on NT.
No other changes were performed. Ora-12514 Thanks a lot in advance, Alexander Like Show 0 Likes(0) Actions 50. The website is: https://metalink.oracle.com Suggested keywords for your search are: CLIENT CONNECTIONS STAY ESTABLISHED CONNECTING VIA ORACLE NAMES WHEN USING NAMES SERVER. Error message: ERROR - ORA-12154: TNS:could not resolve the connect identifier specified My setup: echo %COMPUTERNAME% echo %USERNAME% echo %PATH% echo %ORACLE_HOME% echo %ORACLE_SID% echo %TNS_ADMIN% ipconfig /all | findstr IP
I haven't used Oracle in a few years, or I could offer a more specific solution, sorry. –DomPazz Nov 5 '13 at 14:45 add a comment| 1 Answer 1 active oldest https://groups.google.com/d/topic/comp.soft-sys.sas/d1fPMpG--p8 I found it. Sas Ora 12154 Tns Could Not Resolve The Connect Identifier Specified path="(DESCRIPTION= (ADDRESS= (PROTOCOL=TCP)(HOST=10.12.102.60)(PORT=1521)) (CONNECT_DATA= (SERVICE_NAME=NEOLA.BPWDB.MSDS) ) )";The SID/Service_name will make a connection to oracle. Sas Libname Oracle I am able to connect to the server using File>>Open>>ODBC>>select Data Source Name (defined the server in ODBC with no problem).
Any suggestions? weblink Showing results for Search instead for Do you mean Find a Community Communities Welcome Getting Started Community Memo Community Matters Community Suggestion Box Have Your Say SAS Programming Base SAS Programming ORAPW= option doesn't look familiar to me, should be PW= I guess, though that would cause different error message to me. Download TypeBlogs Case Studies Infographics Presentations Service Overviews Videos Webinars White Papers SolutionDatabase Assessments Data Consulting Database Monitoring Database Projects Database Security Database Staffing Database Support Database Upgrades Database Development Database Libname Odbc
Email Address Categories 11g Amazon Web Services Art of BI Big Data Blog Business Intelligence Cloud Computing Database Administration DB2 Infrastructure MongoDB MySQL OBIEE Oracle Oracle Applications Potpourri Remote DBA SharePoint The work around to this problem is to use TSNAMES.ORA instead of the Oracle Names Server. But a large number of people are using, or trying to learn the usability of the prodcut with Windows XP or Windows 2003 machines, especially the much advertised XE. navigate here Try: C:> sqlplus u2/[email protected] Like Show 0 Likes(0) Actions 46.
EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) ) ORA92 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS Message 2 of 15 (2,193 Views) Reply 0 Likes kparker Contributor Posts: 42 Re: ORACLE connection error Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Highlight Print Email to ORACLE10 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = macbook)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = Oracle10gR2) ) ) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS =
Same problems as all of you. Random spaces used to cause problems. Is it not time to clarify the situation by means of an extended trouble shooting page. Tried new environment variables and other items mentioned above to no avail. ...
Like Show 0 Likes(0) Actions 1 2 3 4 5 6 Previous Next Go to original post Actions About Oracle Technology Network (OTN)My Oracle Support Community (MOSC)MOS Support PortalAboutModern Marketing BlogRSS The command completed successfully C:\>type C:\query.sql select * from v$instance; exit C:\>sqlplus / as sysdba @C:\query.sql SQL*Plus: Release 10.2.0.1.0 - Production on Fri Oct 19 11:07:53 2007 Copyright (c) 1982, 2005, After unpacking the "Basic" and "SQL*Plus" packages, I added the directory where I unpacked the files (C:\oracle\10g\instantclient) to the beginning of the PATH variable and added a TNS_ADMIN environment variable. his comment is here There is that conecpt of databases/schemas that is different to SAS libnames.
Re: ORA-12154: TNS:could not resolve the connect identifier specified 531112 Aug 31, 2006 3:42 PM (in response to 495468) Hi, Were you able to solve this problem? Are there any characters I am missing?LAPROD= (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=10.12.102.60) (PORT=1521) ) (CONNECT_DATA= (SERVICE_NAME=NEOLA.BPWDB.MSDS) ) ) Message 7 of 15 (2,193 Views) Reply 0 Likes SASKiwi Super User Posts: 2,396 Regards, Alexander Like Show 0 Likes(0) Actions 51. The TNSPING is working in his own session environment as part of oraclient install and could be using another on as the SAS environment is seeing.
Like Show 0 Likes(0) Actions 47. Re: ORA-12154: TNS:could not resolve the connect identifier specified orafad Jun 26, 2006 2:37 PM (in response to 509395) It's a shame so many people have to spend so much time SQLNET.AUTHENTICATION_SERVICES= (NTS) NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT) C:\>type C:\Oracle\Network\Admin\tnsnames.ora # tnsnames.ora Network Configuration File: C:\Oracle\network\admin\tnsnames.ora # Generated by Oracle configuration tools. Like Show 0 Likes(0) Actions 54.
http://www.devshed.com/c/a/Oracle/Experience-the-Possibilities-with-Oracle-10g-Express-Edition/ For other tutorials on Oracle check out this link: http://www.angelfire.com/vt2/hodentek/ It's a shame so many people have to spend so much time trouble shooting this ORA-12154 error. This activating/setting of oracle is one of the adjustments in the installation of the SAS sosftware. I can't connect to iSQLPlus through the web interface at http://macbook:5560/isqlplus/... I would check your PC's TNSNAMES.ORA Oracle config file to see if your path LAPROD is defined in there.
Please type your message and try again. Often they will be able to provide guidance for resolving your problem in accordance with your site's standards. I have no doubt many will agree. Operating System and Release InformationProduct FamilyProductSystemSAS ReleaseReportedFixed*SAS SystemSAS/ACCESS Interface to OracleMicrosoft Windows XP Professional9.1 TS1M3Microsoft Windows 2000 Server9.1 TS1M3Microsoft Windows Server 2003 Datacenter Edition9.1 TS1M3Microsoft Windows Server 2003 Enterprise Edition9.1 TS1M3Microsoft
To view the RateIT tab, click here. I am trying to create a direct connection to the server as I do with OLEDB to my SQL server. It points to a directory, where I've got a TNSNAMES.ORA file.