Re: Getting feet wet with users in Multi-Tenant Users and 12c
Date: Wed, 23 Mar 2016 21:51:34 +0000
Message-ID: <4A7153E1-C262-46C2-87A2-04735ABE5E2F_at_businessolver.com>
Yep - I'm running Yosemite too. I don't know if it's because I'm using tunneling or what. When I use the following (like your example) this is what happens:
rfreeman-mbp15:~ rfreeman$ sqlplus beneprod_at_localhost:1523/devdb1.qadb.local
SQL*Plus: Release 11.2.0.4.0 Production on Wed Mar 23 16:42:04 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
This is the weird crazy syntax I have to use to get it to actually work:
rfreeman-mbp15:~ rfreeman$ sqlplus beneprod_at_\"//localhost:1523/devdb1.qadb.local\"
SQL*Plus: Release 11.2.0.4.0 Production on Wed Mar 23 16:43:59 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
SQL> I suppose that it's possible that it's just some environment setting that is off... I also just noticed that this is the 32-bit version of the client - wonder if that it the issue.
RF
On Mar 23, 2016, at 1:44 PM, Hans Forbrich <fuzzy.graybeard_at_gmail.com<mailto:fuzzy.graybeard_at_gmail.com>> wrote:
Don't understand. Unless you are talking about OSX's insane DNS handling, for which I generally use IP addresses directly.
From my MAC, Yosemite, across the network to my Linux based server, with appropriate substitutions for public consumption .
olorin:bin hansforbrich$ ./sql system_at_%%%%%%%%:1521/samples.%%%%%%%<mailto:system_at_%%%%%%%%:1521/samples.%%%%%%%> SQLcl: Release 4.2.0.16.049.0842 RC on Wed Mar 23 12:39:21 2016
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Password? (**********?) *********
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL>
/Hans
On 23/03/2016 12:04 PM, Robert Freeman wrote:
I shall add my agreement to the wondrous nature of EX-Connect strings juxtaposed to TNS entires. However, if you have every tried to use them on a MAC - it's a whole world of pain.
On 03/22/2016 11:51 AM, Hans Forbrich wrote:
I've gotten out of the habit is adding a TNS entry - the overhead in the long run will become very very tedious. EZ-connect seems to be the way to go.
Here we agree 100% percent.
��i��0���zX���+�� n��{�+i�^l===
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Mar 23 2016 - 22:51:34 CET