Tuesday, July 16, 2013

Sql Plus, why are you not more fault tolerant

Fun fact: a lack of a space char in your tnsnames.ora file can make sqlplus (os x lion) not work.

1) works: TnsEntry = (description =(address = (protocol = tcp)(host =localhost)(port = 1521))(connect_data =(service_name = orcl)))

2) not: TnsEntry = (description =(address = (protocol = tcp)(host =localhost)(port = 1521))LF/CR(connect_data =(service_name = orcl)))

3) works: TnsEntry = (description =(address = (protocol = tcp)(host =localhost)(port = 1521))LF/CR/Space(connect_data =(service_name = orcl))

No comments:

Post a Comment