Subscribe: Laurent Schneider
http://laurentschneider.com/feed/
Added By: Feedage Forager Feedage Grade B rated
Language: English
Tags:
connect data  connect  continue reading  continue  data  listener port  ncube  port  protocol tcp  reading  sid  srv port  tcp connect 
Rate this Feed
Rate this feedRate this feedRate this feedRate this feedRate this feed
Rate this feed 1 starRate this feed 2 starRate this feed 3 starRate this feed 4 starRate this feed 5 star

Comments (0)

Feed Details and Statistics Feed Statistics
Preview: Laurent Schneider

Laurent Schneider



Oracle Certified Master



Last Build Date: Sat, 17 Feb 2018 17:38:48 +0000

 



Dynamic number of columns revisited

Sat, 17 Feb 2018 17:33:03 +0000

Itching to start playing with 18c? Now you can on @oraclelivesql ! Here's a script to get you started: a dynamic CSV-to-columns converter using polymorphic table functionshttps://t.co/UfddLQ2tn5 pic.twitter.com/BxnXeIKoCx — Chris Saxon (@chrisrsaxon) February 17, 2018 The ingenious solution of Anton Scheffer using Data Cartridge is now beaten in 18c using polymorphic table function Anthologic post …



sid and pluggable

Fri, 08 Sep 2017 08:10:53 +0000

I wrote about SID there. (CONNECT_DATA=(SID=DB01)) is undocumented since Oracle 11gR1 and breaks things with multi-tenant / single-tenant. You create a container CDB01 and a pluggable DB01, you can connect with sqlplus "scott/tiger@   (description=(address=     (host=srv01)(port=1521)(protocol=tcp))     (connect_data=(service_name=DB01.example.com)))" But one of your application has hardcoded SID=DB01 sqlplus "scott/tiger@   (description=(address=     (host=srv01)(port=1521)(protocol=tcp))     (connect_data=(sid=DB01)))" ORA-12514: TNS:listener does not currently know …



default listener port

Mon, 10 Jul 2017 17:13:30 +0000

Long time ago, Maxime Yuen registered 1521 for nCube License Manager. By googling I found : Ellison cleans house at nCube, and since them 1521 has been used as a default port for Oracle. Still, you’ll see nCube in IANA.ORG service names port numbers and in /etc/services the nCube name. I don’t know which one …