tag:blogger.com,1999:blog-24426479819958199812024-03-14T09:03:41.826-07:00SQLDeveloper Senior Member of Tech Staff blogExperience:<br> 11g DBA OCP / VM / Docker / REST / SQLcl / SQLDeveloper / macOS / Linux / Java Developer <br> Continuous improvement <br> The views expressed on this blog are my own and do not necessarily reflect the views of Oracle.Turloch O'Tierneyhttp://www.blogger.com/profile/08870427718022428504noreply@blogger.comBlogger49125tag:blogger.com,1999:blog-2442647981995819981.post-29965995893402516472024-03-14T09:03:00.000-07:002024-03-14T09:03:01.706-07:00<p>Interested in new opportunities.</p><p>Last day at Oracle March 22nd 2024 after 25 years at Oracle - moving on to different things. Contact details: +353 868256032, turloch@gmail.com. Search for Turloch O'Tierney on facebook or LinkedIn (Turloch is an unusual spelling there will not be two instances of Turloch O'Tierney).</p><p>Skills: Oracle Database, Linux, Java, git, Docker and C. International experience: England, Netherlands, Canada. Based in Dublin Ireland.</p><p>(Oracle experience + </p><p>coderdojo leader/champian experience 2016 to 2018 + </p><p>1 hr a week with 17 year old son experience up to 2024).</p>Turloch O'Tierneyhttp://www.blogger.com/profile/08870427718022428504noreply@blogger.com0tag:blogger.com,1999:blog-2442647981995819981.post-11089679652800307872023-04-19T14:34:00.001-07:002023-04-19T14:34:41.577-07:00<p> <a href="https://www.oracle.com/database/technologies/databaseappdev-vm.html">https://www.oracle.com/database/technologies/databaseappdev-vm.html</a> Got a new Virtualbox VM out.</p><p>unset TWO_TASK to connect sqlplus / as SYSDBA.</p><p>You might want to mark the disks as SSD - so TRIM can be used/reduce ware.</p><p>SQLDeveloper desktop and SQLDeveloper Modeller were not included (But sqldevloper web/database actions via ords is included). There were no demos included. Simply database sqlcl apex and ords.</p><p>Firefox within the VM is a bit flakey/out of date - you may upgrade - or simply use your host browser.</p><p>A bit of a rush towards the end, meant to give a better starting screen - use the forum <a href="https://forums.oracle.com/ords/apexds/domain/dev-community/category/oracle-database-free">https://forums.oracle.com/ords/apexds/domain/dev-community/category/oracle-database-free</a> - or drop a message here if you have any queries.</p><p>ORDS is started on startup kill it if you want it restarted - there is an ordsstart helper script.</p><p>There is a service enabled: oracle-free-23c which starts database listener and ords - and stops database and listener (but not ords)- if you stop and restart the service the ords fails as there is already an ords on 8080.</p><p>For me the display may need to be set to 200% - if the virtual box window is too small (font too small).</p>Turloch O'Tierneyhttp://www.blogger.com/profile/08870427718022428504noreply@blogger.com1tag:blogger.com,1999:blog-2442647981995819981.post-68874390960540151622020-02-18T06:17:00.000-08:002020-02-18T06:17:08.893-08:00Cannot reproduce (sql - maybe alias related) reply<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(0, 0, 0); color: black; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
Cannot reproduce. (alias related issue)</div>
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(0, 0, 0); color: black; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
<br /></div>
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(0, 0, 0); color: black; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
Get back to the customer.</div>
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(0, 0, 0); color: black; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
<br /></div>
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(0, 0, 0); color: black; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
We should have a standard reply if we cannot reproduce the sql error I will try to give one:</div>
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(0, 0, 0); color: black; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
<br /></div>
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(0, 0, 0); color: black; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
1/sql command has -verbose flag which show issues (like java or sql exceptions) that have been logged.</div>
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(0, 0, 0); color: black; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
<br /></div>
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(0, 0, 0); color: black; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
2/"set echo on” might help (unlikely though - it will echo out what commands the alias is doing)</div>
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(0, 0, 0); color: black; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
<br /></div>
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(0, 0, 0); color: black; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
3/Things that might not be accounted for in customer ‘aliases.xml’ test case: </div>
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(0, 0, 0); color: black; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
<br /></div>
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(0, 0, 0); color: black; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
.login.sql file or equivalent automatically read at startup</div>
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(0, 0, 0); color: black; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
set sqlformat <non ansiconsole="" example="" for="" standard=""></non></div>
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(0, 0, 0); color: black; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
The bug is logged against linux (that is what I tested on and could not reproduce)</div>
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(0, 0, 0); color: black; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
Might need a full:</div>
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(0, 0, 0); color: black; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
sql username/password @thetestcase.sql</div>
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(0, 0, 0); color: black; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
Testcase (with aliases xml and .login.sql if any) in case anything before the alias in the session and or customer environment is required to reproduce.</div>
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(0, 0, 0); color: black; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
What is the encoding/language? - ie is it UTF8 + American (English) (Some bugs are multibyte is Japanese/Chinese only)</div>
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(0, 0, 0); color: black; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
<br /></div>
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(0, 0, 0); color: black; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
Try with latest oracle java 8 (not openjdk) and ORACLE_HOME unset i.e. thin driver as shipped instead of thick driver from Oracle home. (What is the show JDBC and show java output?)</div>
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(0, 0, 0); color: black; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
(What is the oracle database version being connected to and what Oracle Database does $ORACLE_HOME point too?)</div>
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(0, 0, 0); color: black; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
<br /></div>
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(0, 0, 0); color: black; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
4/Can the customer reproduce with new operating system user/different linux box?</div>
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(0, 0, 0); color: black; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
<br /></div>
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(0, 0, 0); color: black; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
5/Has the database connection timed out (Oracle ADB does that) - or other too much resource used and connection cut off by the database dba/automatically, - unlikely as the command works on repeating it (could be a reconnect)</div>
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(0, 0, 0); color: black; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
<br /></div>
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(0, 0, 0); color: black; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
6/The error says ctrl C - however there could be another error caught and reported wrong/differently</div>
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(0, 0, 0); color: black; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
<br /></div>
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(0, 0, 0); color: black; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
If I had a test case I would go through the code line by line.</div>
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(0, 0, 0); color: black; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
Without the code If I could reproduce I would do some tracing (strace/wireshark) - but I cannot expect customer to do that - too much in the tracing file/output to go through - in sqldeveloper there is a log view which at least gives all the sql sent to the database (slightly more user friendly than strike/wireshark). There might be other tracing the customer is aware of/more familiar with, Unless encrypted or https - the sql to and error back from database is sent received by a write/read from file/socket (and unencrypted).</div>
</div>
Turloch O'Tierneyhttp://www.blogger.com/profile/08870427718022428504noreply@blogger.com0tag:blogger.com,1999:blog-2442647981995819981.post-71807866025129794172020-01-23T03:49:00.001-08:002020-01-23T03:49:15.709-08:00LDAP and Kerberos<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<br />
LDAP web ui (OID12 + OUD latest tested - interested in reports of anything else working not working - but we do not have it in house)<br />
19.? - paging used for ldap ui search - broke unpatched OID11 (tested successfully with OID12) - required configuration OUD<br />
19.4 - on specific exception on paging try non paged (tested successfully OID12 and OUD (latest - with only anonymous bind configuration))<br />
Active directory not tested (that was actually where the paging request came in) (not tested)<br />
(Huge performance improvement on lots of aliases on loading dbservice (alias became lazily evaluated))<br />
<br />
(Advanced URL based thick or thin LDAP works - I think thick ldap by 'dbservice name' (forgot the name in the ui) outside LDAP web lookup might be OK - certainly full LDAP url ok - but different syntax for thick and thin).<br />
<br />
KERBEROS (Linux/MIT Kerberos tested easy enough - Active directory Kerberos ticket tested fairly recently) - thick JDBC should work 'like sqlplus'.<br />
18.4 Kerberos - tested with credential cache blank 'Active directory Kerberos ticket' on windows -> means try native (regedit change required). I have rough notes from testing on this configuration.<br />
<br /></div>
Turloch O'Tierneyhttp://www.blogger.com/profile/08870427718022428504noreply@blogger.com0tag:blogger.com,1999:blog-2442647981995819981.post-11650818105314475402020-01-03T08:07:00.000-08:002020-01-03T08:07:05.027-08:00SQL Developer 19.4 Datapump wizard, now with encryption of data files.<div dir="ltr" style="text-align: left;" trbidi="on">
<span class="css-901oao css-16my406 r-1qd0xha r-ad9z0x r-bcqeeo r-qvutc0">SQL Developer 19.4 Datapump wizard, now with encryption of data files. </span><br />
<span class="css-901oao css-16my406 r-1qd0xha r-ad9z0x r-bcqeeo r-qvutc0">(Underlying PLSQL API had encryption option since Oracle Database 11gr1)</span></div>
Turloch O'Tierneyhttp://www.blogger.com/profile/08870427718022428504noreply@blogger.com0tag:blogger.com,1999:blog-2442647981995819981.post-71937291112214972742019-09-18T06:04:00.001-07:002019-09-18T06:04:22.111-07:00LDAP SQLDeveloper new paging requirement<div dir="ltr" style="text-align: left;" trbidi="on">
Currently OID is the target LDAP provider <br />
<br />
Paging access (added 6 months ago) so that over 1000 entries will not get truncated seems to be causing problems on unpatched OID11 - though I tested it against patched OID 11 and OID 12 .<br />
<br />
I have been asking people with issues to contact support - if the issue is prioritised I may get a broken setup to test against. If I sense a paging error for example - I could try a non paged version (getting large number of results truncated is better than no results).<br />
<br />
Some guy managed to get OUD working by allowing paging (Third party link removed)<br />
<br />
Note that<br />
1/ you can supply context in ldap.ora<br />
2/ you can give exact match in the dbservice combo box (and download the single connection details without searching for all services in a context)<br />
<br />
I was hoping this might help for LDAPs that do not allow root searching (ODSEE?) (or do not have paged access)<br />
<br />
These LDAP considerations apply to the SQLDeveleoper specific LDAP UI for searching for entries - you could always use the advanced URL for LDAP (thick and thin have different syntax). <br />
<br />
Also 6 months ago we fixed:<br />
Kerberos Active Directory default login ticket support on windows (give cache as blank i.e. "" (without the quotes)) - was tested with a configuration file with thin jdbc . (You could have, and still can, use thick kerberos and sqlnet.ora configuration) <br />
<br /></div>
Turloch O'Tierneyhttp://www.blogger.com/profile/08870427718022428504noreply@blogger.com1tag:blogger.com,1999:blog-2442647981995819981.post-41516483153706226932019-06-21T08:59:00.002-07:002019-06-21T08:59:37.487-07:0019.3 database 19.1 dbtools software releases<div dir="ltr" style="text-align: left;" trbidi="on">
VM download page: https://www.oracle.com/technetwork/community/databaseappdev-vm-161299.html<br />
<br />
Dropped json and xml labs<br />
<br />
<span style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(0, 0, 0); color: black; display: inline !important; float: none; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">Virtualbox 6.0.8</span><br />
<br />
<span style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(0, 0, 0); color: black; display: inline !important; float: none; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">sqldeveloper fails 10% of the time workaround: turn off splash page</span><br />
<span style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(0, 0, 0); color: black; display: inline !important; float: none; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;"><br /></span>
<span style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(0, 0, 0); color: black; display: inline !important; float: none; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">Sometime too small (mac retinal screen) magnify by: machine -> settings -> display -> scale factor </span><br />
<br />
Performs ok with 3G RAM & 2 CPUS - 2G RAM and 1CPU - bare minimum (swaps).<br />
<br />
Old release blog http://totierne.blogspot.com/2018/10/new-developer-day-vm-183-182-apex.html<br />
<br />
Let me know any issues.</div>
Turloch O'Tierneyhttp://www.blogger.com/profile/08870427718022428504noreply@blogger.com0tag:blogger.com,1999:blog-2442647981995819981.post-45109296968091985692019-05-17T01:21:00.003-07:002019-05-17T01:21:36.584-07:00kerberos native non file based connection cache in windows (from 18.4)<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(0, 0, 0); color: black; display: inline !important; float: none; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">From SQLDeveloper 18.4 kerberos works on windows with thin driver and </span><span class="" style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(0, 0, 0); color: black; font-family: "Times New Roman", serif; font-size: 12pt; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;"> </span><span class="" style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(0, 0, 0); color: black; font-family: Times New Roman, serif; font-size: small; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">Active Directory Kerberos and using "native credential cache” configured by not entering a file cache name.</span></div>
Turloch O'Tierneyhttp://www.blogger.com/profile/08870427718022428504noreply@blogger.com0tag:blogger.com,1999:blog-2442647981995819981.post-34290332121985202332019-05-15T09:41:00.000-07:002019-05-17T01:13:52.635-07:00LDAP - User report no context shown<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(61, 61, 61); color: #3d3d3d; font-family: "Helvetica Neue", Helvetica, Arial, "Lucida Grande", sans-serif; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; margin: 0px; orphans: auto; padding: 0px; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
Hi <span style="color: #333333; font-family: inherit; font-size: 0.9em; font-style: inherit; font-weight: bold;">user</span><span style="color: #333333; font-family: "helvetica neue" , "helvetica" , "arial" , sans-serif; font-size: 0.9em;"></span></div>
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(61, 61, 61); color: #3d3d3d; font-family: "Helvetica Neue", Helvetica, Arial, "Lucida Grande", sans-serif; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; margin: 0px; orphans: auto; padding: 0px; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
<br /></div>
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(61, 61, 61); color: #3d3d3d; font-family: "Helvetica Neue", Helvetica, Arial, "Lucida Grande", sans-serif; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; margin: 0px; orphans: auto; padding: 0px; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
18.2 required an ldap.ora (by mistake on my part).</div>
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(61, 61, 61); color: #3d3d3d; font-family: "Helvetica Neue", Helvetica, Arial, "Lucida Grande", sans-serif; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; margin: 0px; orphans: auto; padding: 0px; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
(you can specify a default context in ldap.ora)</div>
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(61, 61, 61); color: #3d3d3d; font-family: "Helvetica Neue", Helvetica, Arial, "Lucida Grande", sans-serif; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; margin: 0px; orphans: auto; padding: 0px; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
<br /></div>
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(61, 61, 61); color: #3d3d3d; font-family: "Helvetica Neue", Helvetica, Arial, "Lucida Grande", sans-serif; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; margin: 0px; orphans: auto; padding: 0px; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
I tried the following:</div>
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(61, 61, 61); color: #3d3d3d; font-family: "Helvetica Neue", Helvetica, Arial, "Lucida Grande", sans-serif; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; margin: 0px; orphans: auto; padding: 0px; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
Windows (2012) 19.1 against oid12 - success without ldap.ora</div>
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(61, 61, 61); color: #3d3d3d; font-family: "Helvetica Neue", Helvetica, Arial, "Lucida Grande", sans-serif; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; margin: 0px; orphans: auto; padding: 0px; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
Mac 19.1 against oid12 - success. (with or without ldap.ora) (the ldap search screens are pure java - not affected by oracle client etc - emulation of ldap.ora support).</div>
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(61, 61, 61); color: #3d3d3d; font-family: "Helvetica Neue", Helvetica, Arial, "Lucida Grande", sans-serif; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; margin: 0px; orphans: auto; padding: 0px; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
<br /></div>
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(61, 61, 61); color: #3d3d3d; font-family: "Helvetica Neue", Helvetica, Arial, "Lucida Grande", sans-serif; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; margin: 0px; orphans: auto; padding: 0px; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
Useful for the user to know.</div>
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(61, 61, 61); color: #3d3d3d; font-family: "Helvetica Neue", Helvetica, Arial, "Lucida Grande", sans-serif; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; margin: 0px; orphans: auto; padding: 0px; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
It does not tell you anything if you got the host or port wrong (it is as you report no context shown - please check your host and port are valid - and there Is nothing in the way (firewall) - you could use a previous 'known working' SQLDeveloper version on the same windows machine/user)</div>
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(61, 61, 61); color: #3d3d3d; font-family: "Helvetica Neue", Helvetica, Arial, "Lucida Grande", sans-serif; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; margin: 0px; orphans: auto; padding: 0px; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
Press enter after entering the ldap server to get Context populated.</div>
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(61, 61, 61); color: #3d3d3d; font-family: "Helvetica Neue", Helvetica, Arial, "Lucida Grande", sans-serif; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; margin: 0px; orphans: auto; padding: 0px; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
<br data-mce-bogus="1" /></div>
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(61, 61, 61); color: #3d3d3d; font-family: "Helvetica Neue", Helvetica, Arial, "Lucida Grande", sans-serif; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; margin: 0px; orphans: auto; padding: 0px; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
Load to fill the service entries list (double click from pull down (or type in) to select a service) (What is typed in narrows selection).</div>
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(61, 61, 61); color: #3d3d3d; font-family: "Helvetica Neue", Helvetica, Arial, "Lucida Grande", sans-serif; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; margin: 0px; orphans: auto; padding: 0px; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
<br data-mce-bogus="1" /></div>
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(61, 61, 61); color: #3d3d3d; font-family: "Helvetica Neue", Helvetica, Arial, "Lucida Grande", sans-serif; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; margin: 0px; orphans: auto; padding: 0px; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
Changes in this release:</div>
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(61, 61, 61); color: #3d3d3d; font-family: "Helvetica Neue", Helvetica, Arial, "Lucida Grande", sans-serif; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; margin: 0px; orphans: auto; padding: 0px; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
Performance fix around aliases</div>
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(61, 61, 61); color: #3d3d3d; font-family: "Helvetica Neue", Helvetica, Arial, "Lucida Grande", sans-serif; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; margin: 0px; orphans: auto; padding: 0px; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
Load in pages (i.e. can load in pages over the default 1000 entries). (Loads in pages of 499 - could conflict with old configuration)</div>
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(61, 61, 61); color: #3d3d3d; font-family: "Helvetica Neue", Helvetica, Arial, "Lucida Grande", sans-serif; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; margin: 0px; orphans: auto; padding: 0px; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
Tries subtree, peer and exact search. (uses first one that does not error out/returns data)</div>
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(61, 61, 61); color: #3d3d3d; font-family: "Helvetica Neue", Helvetica, Arial, "Lucida Grande", sans-serif; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; margin: 0px; orphans: auto; padding: 0px; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
<br data-mce-bogus="1" /></div>
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(61, 61, 61); color: #3d3d3d; font-family: "Helvetica Neue", Helvetica, Arial, "Lucida Grande", sans-serif; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; margin: 0px; orphans: auto; padding: 0px; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
Useful for the oid admin to know:</div>
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(61, 61, 61); color: #3d3d3d; font-family: "Helvetica Neue", Helvetica, Arial, "Lucida Grande", sans-serif; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; margin: 0px; orphans: auto; padding: 0px; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
There are two very similar setting one of them is now required, here is one of them</div>
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(61, 61, 61); color: #3d3d3d; font-family: "Helvetica Neue", Helvetica, Arial, "Lucida Grande", sans-serif; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; margin: 0px; orphans: auto; padding: 0px; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
<a class="" data-mce-href="https://support.oracle.com/knowledge/Middleware/2046445_1.html" href="https://support.oracle.com/knowledge/Middleware/2046445_1.html" style="color: #2989c5; text-decoration: none;" title="https://support.oracle.com/knowledge/Middleware/2046445_1.html">https://support.oracle.com/knowledge/Middleware/2046445_1.html</a> </div>
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(61, 61, 61); color: #3d3d3d; font-family: "Helvetica Neue", Helvetica, Arial, "Lucida Grande", sans-serif; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; margin: 0px; orphans: auto; padding: 0px; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
<br data-mce-bogus="1" /></div>
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(61, 61, 61); color: #3d3d3d; font-family: "Helvetica Neue", Helvetica, Arial, "Lucida Grande", sans-serif; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; margin: 0px; orphans: auto; padding: 0px; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
-Turloch</div>
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(61, 61, 61); color: #3d3d3d; font-family: "Helvetica Neue", Helvetica, Arial, "Lucida Grande", sans-serif; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; margin: 0px; orphans: auto; padding: 0px; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
SQLDeveloper team.</div>
</div>
Turloch O'Tierneyhttp://www.blogger.com/profile/08870427718022428504noreply@blogger.com0tag:blogger.com,1999:blog-2442647981995819981.post-7899569274554534042019-05-03T06:05:00.001-07:002019-05-03T06:05:32.827-07:00ldap - ldap.ora for host and context<div dir="ltr" style="text-align: left;" trbidi="on">
ldap - ldap.ora for host and context<br />
<br />
combobox - type in - no search required - i.e. no tree search required. (One customer said they could do without search if that was the issue stopping ODS from working)</div>
Turloch O'Tierneyhttp://www.blogger.com/profile/08870427718022428504noreply@blogger.com0tag:blogger.com,1999:blog-2442647981995819981.post-83255223636269116772019-03-01T02:52:00.003-08:002019-03-01T02:52:51.778-08:00SQLDeveloper 18.4 active directory 'kerberos' login using not file based ticket should work<div dir="ltr" style="text-align: left;" trbidi="on">
SQLDeveloper 18.4 active directory 'kerberos' login using not file based ticket should work - i.e. ticket cache name not forced to be a string/file -> one of the defaults tried is internal cache</div>
Turloch O'Tierneyhttp://www.blogger.com/profile/08870427718022428504noreply@blogger.com0tag:blogger.com,1999:blog-2442647981995819981.post-51866760162955586472018-11-06T04:25:00.002-08:002018-11-06T04:25:38.657-08:00DONE: Retreived existing kerberos/Active Directory internal ticket. TODO: confirm an existing internal ticket based Kerberos/Active directory login to Database with java.<div dir="ltr" style="text-align: left;" trbidi="on">
Code:<br />https://docs.oracle.com/en/database/oracle/oracle-database/12.2/jjdbc/client-side-security.html#GUID-991705F7-C2C5-4BA9-85D1-32749AE2FF64<br />Kerberos Hello World login:<br /><br />For testing with Active Directory<br /><br />krb5.conf or krb5.ini setting required - or copy it to java default place<br />Cross site registry setting may be required: https://support.microsoft.com/en-gb/help/308339/registry-key-to-allow-session-keys-to-be-sent-in-kerberos-ticket-grant<br /><br />Old but seems comprehensive notes:<br />http://cr.openjdk.java.net/~weijun/special/krb5winguide-2/raw_files/new/kwin<br /><br />Login code:<br />https://docs.oracle.com/en/database/oracle/oracle-database/12.2/jjdbc/client-side-security.html#GUID-991705F7-C2C5-4BA9-85D1-32749AE2FF64<br /><br />Replace "jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)"+<br /> "(HOST=oracleserver.mydomain.com)(PORT=5221))(CONNECT_DATA=" +<br /> "(SERVICE_NAME=orcl)))" with your connection details.<br /><br />Replace "/home/Jdbc/Security/kerberos/krb5.conf" with your krb5.ini or krb5.conf (java also has a default place to look if this is not set). (with windows use double back slash \\)<br /><br />If you want to use internal cache comment out:<br /> prop.setProperty(OracleConnection.CONNECTION_PROPERTY_THIN_NET_AUTHENTICATION_KRB5_CC_NAME,<br /> "/tmp/krb5cc_5088");<br /><br />Look at: "Attempt to connect with the default user:"<br />Ignore: "Attempt to connect with a specific user:"<br /><br />use ojdbc8.jar (from sqldeveloper or sqlcl).<br /><br />javac -cp ojdbc8.jar KerberosJdbcDemo.java<br />java -Dsun.security.krb5.debug=true -Dsun.security.jgss.debug=true -cp ojdbc8.jar;. KerberosJdbcDemo<br /><br />You can use these settings in your sqldeveloper.conf (and start sqldeveloper from sqldeveloper/bin) to get this tracing/debugging in sqldeveloper.<br />(Currently (SQLDeveloper 18.3) internal cache does not work with sqldeveloper - you need an explicit file based cache).<br /><br />(If you get >>> Found no TGT's in LSA you could need registry setting)<br />should see: >>> Obtained TGT from LSA: Credentials:<br />
<br />
My Active Directory is not linked to my Oracle Database at the moment - so I could not check if this ticket worked for database login.</div>
Turloch O'Tierneyhttp://www.blogger.com/profile/08870427718022428504noreply@blogger.com1tag:blogger.com,1999:blog-2442647981995819981.post-68623117800048430542018-10-22T03:29:00.000-07:002018-10-22T03:32:07.137-07:00New Developer Day VM 18.3 (18.2 APEX)<div dir="ltr" style="text-align: left;" trbidi="on">
<a data-saferedirecturl="https://www.google.com/url?q=https://www.oracle.com/technetwork/database/enterprise-edition/databaseappdev-vm-161299.html&source=gmail&ust=1540287323658000&usg=AFQjCNHpn3RPGZQKZlaqvTj8Fc0tRGjUYw" href="https://www.oracle.com/technetwork/database/enterprise-edition/databaseappdev-vm-161299.html" target="_blank">https://www.oracle.com/<wbr></wbr>technetwork/database/<wbr></wbr>enterprise-edition/<wbr></wbr>databaseappdev-vm-161299.html</a><br />
<br />
<ul>
<li>Oracle Linux 7</li>
<li>Oracle Database 18.3 Linux x86-64</li>
<li>Oracle SQL Developer 18.3</li>
<li>Oracle Application Express 18.2</li>
<li>Hands-On-Labs (accessed via the Toolbar Menu in Firefox) <ul>
<li>Oracle REST Data Services 18.3</li>
<li>Oracle SQL Developer Data Modeler 18.3</li>
<li>Oracle XML DB </li>
</ul>
</li>
</ul>
For performance up resources to 2CPU 3GB RAM - default 1CPU 2G ram.<br />
<br />
Errata:<br />
1/ Occasional SQLDeveloper startup issue:<br />
2/ DBCA trick <br />
3/ JET lab<br />
4/ reset scripts<br />
<br />
1/Occasional SQLDeveloper startup issue:<br />
<br /><div class="" style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; color: black; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
(java:23682): Gdk-ERROR **: The program 'java' received an X Window System error.</div>
<div class="" style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; color: black; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
This probably reflects a bug in the program.</div>
<div class="" style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; color: black; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
The error was 'RenderBadPicture (invalid Picture parameter)'.</div>
<div class="" style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; color: black; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
(Details: serial 17547 error_code 143 request_code 139 minor_code 7)</div>
<div class="" style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; color: black; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
(Note to programmers: normally, X errors are reported asynchronously;</div>
<div class="" style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; color: black; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
that is, you will receive the error a while after causing it.</div>
<div class="" style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; color: black; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
To debug your program, run it with the --sync command line</div>
<div class="" style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; color: black; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
option to change this behavior. You can then get a meaningful</div>
<div class="" style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; color: black; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
backtrace from your debugger if you break on the gdk_x_error() function.)</div>
<div class="" style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; color: black; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
/u01/userhome/oracle/sqldeveloper/sqldeveloper/bin/../../ide/bin/launcher.sh: line 1606: 23682 Trace/breakpoint trap (core dumped) ${JAVA} "${APP_VM_OPTS[@]}" ${APP_ENV_VARS} -classpath ${APP_CLASSPATH} ${APP_MAIN_CLASS} "${APP_APP_OPTS[@]}"</div>
<div class="" style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; color: black; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
[oracle@localhost ~]$ which java</div>
<div class="" style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; color: black; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
~/java/jdk1.8.0_152/bin/java</div>
<br />
2/ DBCA Trick:<br />
For dbca copy in assistance directory to $ORACLE_HOME from unzip of 18.3 Oracle Database download<br />
https://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html<br />
<br />
3/JET lab<br />
Automated set up of seconds ords for use in JET lab (2nd ords also be done through sqldeveloper as described in labs) <br />
2nd pdb 2nd ords<br />
newpdbords -Sets up 2nd pdb called 'ORDS'<br />
9090init -Starts up ords on new pdb port 9090<br />
(can start stop with 9090start 9090stop)<br />
<br />
#!/bin/bash<br />
. /home/oracle/.bashrc<br />
newpdbords<br />
9090init<br />
sleep 180<br />
cd /home/oracle/sqldeveloper/ords<br />
echo '#!/usr/bin/expect<br />
exp_internal 1<br />
set timeout 1200<br />
spawn $JAVA_HOME/bin/java -jar ords.war user ords_dev "SQL Developer"<br />
expect -regexp "Enter a password for user ords_dev." { send "oracle\r" }<br />
expect -regexp "Confirm password for user ords_dev." {send "oracle\r"}<br />
expect -regexp "Something that will never happen to force keep searching until process end" {send "neverhappen\r"}<br />
interact'| sed 'sZ$JAVA_HOMEZ'"$JAVA_HOME"'Zg' > ~/bin/xp.sh<br />
chmod 755 ~/bin/xp.sh<br />
~/bin/xp.sh<br />
echo '#!/usr/bin/expect<br />
exp_internal 1<br />
set timeout 1200<br />
spawn $JAVA_HOME/bin/java -jar ords.war user ords_admin "Listener Administrator"<br />
expect -regexp "Enter a password for user ords_admin." { send "oracle\r" }<br />
expect -regexp "Confirm password for user ords_admin." {send "oracle\r"}<br />
expect -regexp "Something that will never happen to force keep searching until process end" {send "neverhappen\r"}<br />
interact'| sed 'sZ$JAVA_HOMEZ'"$JAVA_HOME"'Zg' > ~/bin/xp.sh<br />
chmod 755 ~/bin/xp.sh<br />
~/bin/xp.sh<br />
cd -<br />
9090stop<br />
#on ords 9090 reset we want reinstall not uninstall<br />
touch ~/.ordsreinstall<br />
#note 9090init has a 3 minute wait to ensure ords has started<br />
<br />
<br />
4/reset scripts<br />
Report any issues - if reset fails reimport VM</div>
Turloch O'Tierneyhttp://www.blogger.com/profile/08870427718022428504noreply@blogger.com4tag:blogger.com,1999:blog-2442647981995819981.post-31416795919403772182018-06-06T12:03:00.000-07:002018-06-06T12:13:10.039-07:00New Developer day VM<div dir="ltr" style="text-align: left;" trbidi="on">
http://www.oracle.com/technetwork/database/enterprise-edition/databaseappdev-vm-161299.html<br />
<br />
Virtualbox 5.2.8 or above<br />
for performance use 3GB RAM 2 CPU<br />
<br />
New ish:<br />
<br />
rest enabled sql<br />
rest enabled jdbc sql username/password@http://...(to ORDS)<br />
<br />
+18.1 ORDS SQLDeveloper SQLCL modeller APEX<br />
Oracle Linux 7 update5 (yum updated from 7u3 iso)<br />
<br />
executables now under applications->other<br />
(only .txt and .html can be easily clicked on desktop with no popups)<br />
<br />
readme.txt and readmeCopy.txt - the same - one sometimes gets half hidden in icon layout.<br />
<br />
errata<br />
Same as last release + more recent software<br />
any requests/what does not work let me know in the comments.</div>
Turloch O'Tierneyhttp://www.blogger.com/profile/08870427718022428504noreply@blogger.com11tag:blogger.com,1999:blog-2442647981995819981.post-48856280425009749362018-05-04T07:02:00.001-07:002018-05-04T10:12:01.267-07:00Things I worked around when setting up MIT kerberos and sqldeveloper over thin jdbc against 12.2.0.1 Oracle Database:<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-size: small;">Server used Oracle Linux 7 for Kerberos (yum -y install krb5-server krb5-libs)<br />and Oracle Database 12.2.0.1<br />Clients used Oracle Linux 7 and Windows both SQLDeveloper 18.1<br /><br />MIT Kerberos / oracle thick driver went OK once I used global c## user.<br /><br />use c## user:<br />SQL> create user c##user1 identified externally as 'user1@...'<br /><br />(non c## user did not work for me.).<br /><br />Used sqldeveloper with jre included (on windows).<br /><br />SQLdeveloper jdbc thick:<br />'just like sqlplus' requires Oracle Client or Instant Client (not sure (which/if both) has Kerberos).<br /><br />Sqldeveloper thin kerberos configuration:<br /><br />tools->preferences->database->advanced: config file (krb5.conf) - eg (on my<br />linux client) /etc/krb5.conf Credential cache file (on my linux client) eg<br />/home/oracle/mycache (not (Microft Windows) MSLSA or OSMFT) <br />- sqldeveloper thin driver does not read sqlnet.ora <br />- or currently recognize non file based cache.<br /><br />On connection either:<br />1/Give principal (no ticket/cache required) give / get prompted for password - went OK.<br />2/Leave principal blank (and get it from cache): <br />Use kinit (from sqldeveloper on windows - from yum -y install krb5-workstation on Oracle Linux) to set up existing ticket:<br /> needed "kinit -A" (for addressless ticket on windows) (used kinit default cache location and pointed to default from sqldev) (i.e. -A to get around: incorrect net address)<br /><br />(Also tried at the same time kinit -p -f (proxiable and forwardable, and setting non proxy java -D setting) after -A it worked.)<br /><br />klist -f <br />showed:<br />Flags: FORWARDABLE;PROXIABLE;PRE-AUTHENT<br /><br />Issues - customers might not be using MIT Kerberos.<br />Workarounds: Often thick jdbc works 'just like sqlplus' to workaround thin jdbc issues. </span></div>
Turloch O'Tierneyhttp://www.blogger.com/profile/08870427718022428504noreply@blogger.com1tag:blogger.com,1999:blog-2442647981995819981.post-52825286727450792782018-01-24T02:59:00.002-08:002018-01-24T03:01:51.724-08:00<div dir="ltr" style="text-align: left;" trbidi="on">
1/Cool stuff from Oracle (Developer Day VM related)<br />
<br />
2/Showing off your Developer Day VM to remote users (one method only requiring ssh).<br />
<br />
3/Do not 'yum update' 2017 Developer Day VM<br />
<br />
<div style="font-variant-east-asian: normal; font-variant-ligatures: normal; font-variant-position: normal; line-height: 16px; margin-bottom: 0in;">
1/Cool stuff from Oracle (Developer Day VM related)</div>
<div style="font-variant-east-asian: normal; font-variant-ligatures: normal; font-variant-position: normal; line-height: 16px; margin-bottom: 0in;">
<br /></div>
<div style="font-variant-east-asian: normal; font-variant-ligatures: normal; font-variant-position: normal; line-height: 16px; margin-bottom: 0in;">
<span style="font-family: "helvetica";"><span style="font-size: 9pt;">Any </span><span style="font-size: 12px;">trouble</span><span style="font-size: 9pt;"> </span><span style="font-size: 12px;">getting</span><span style="font-size: 9pt;"> these </span><span style="font-size: 12px;">working</span><span style="font-size: 9pt;"> on your VM let me know.</span></span></div>
<div style="background-color: white; font-family: Menlo; font-size: 11px; font-stretch: normal; line-height: normal;">
<br /></div>
<div style="background-color: white; font-family: Menlo; font-size: 11px; font-stretch: normal; line-height: normal;">
<span style="font-variant-ligatures: no-common-ligatures;">datamodeler-17.4.0.355.2121-no-jre.zip (unzip and go)</span></div>
<div style="background-color: white; font-family: Menlo; font-size: 11px; font-stretch: normal; line-height: normal;">
<span style="font-variant-ligatures: no-common-ligatures;">jdk-8u152-linux-x64.tar.gz (or later) (unzip in ~/java [might need to remove existing java in that directory] and go, check ~/.bashrc)</span></div>
<div style="background-color: white; font-family: Menlo; font-size: 11px; font-stretch: normal; line-height: normal;">
<span style="font-variant-ligatures: no-common-ligatures;">sqlcl-17.4.0.354.2224-no-jre.zip - include REST JDBC http://www.oracle.com/technetwork/developertools/rest-data-services/downloads/index.html - unzip and go</span></div>
<div style="background-color: white; font-family: Menlo; font-size: 11px; font-stretch: normal; line-height: normal;">
<span style="font-variant-ligatures: no-common-ligatures;"></span></div>
<div style="background-color: white; font-family: Menlo; font-size: 11px; font-stretch: normal; line-height: normal;">
<span style="font-variant-ligatures: no-common-ligatures;">sqldeveloper-17.4.0.355.2349-no-jre.zip - unzip and go</span></div>
<div style="background-color: white; font-family: Menlo; font-size: 11px; font-stretch: normal; line-height: normal;">
<span style="font-variant-ligatures: no-common-ligatures;"><br /></span></div>
<div style="background-color: white; font-family: Menlo; font-size: 11px; font-stretch: normal; line-height: normal;">
<span style="font-variant-ligatures: no-common-ligatures;">apex_5.1.4.zip (lower version already installed)</span></div>
<div style="background-color: white; font-family: Menlo; font-size: 11px; font-stretch: normal; line-height: normal;">
<span style="font-variant-ligatures: no-common-ligatures;">ords.17.4.1.353.06.48.zip (lower version already installed - but both can run on different ports/pdbs) </span></div>
<div style="background-color: white; font-family: Menlo; font-size: 11px; font-stretch: normal; line-height: normal;">
<span style="font-variant-ligatures: no-common-ligatures;">- one line admin change to be REST SQL (and REST JDBC server) note no longer prompts for sys user. (Would only have trouble running old and new if existing ORDS is installed on the CDB rather than pdb, which is not the case) existing ords.sh should work (for start stop) (put in full path to new war) - initial configure/install will change.</span></div>
<div style="background-color: white; font-family: Menlo; font-size: 11px; font-stretch: normal; line-height: normal;">
<br /></div>
<div>
<span style="font-variant-ligatures: no-common-ligatures;"><br /></span></div>
<div>
<span style="font-variant-ligatures: no-common-ligatures;">2/Showing off your Developer Day VM to remote users (one method only requiring ssh).</span></div>
<div>
<span style="font-variant-ligatures: no-common-ligatures;"><br /></span></div>
If your networking firewall etc are out of your control port 22 (ssh) probably still works.<br />
<br />
For other people to access your VM for test / development purposes you can (obviously but I had forgotten) ssh port forwarding (for 9090 8080 8081 or 1521) - requires ssh login to host machine, for example for 1521:<br />
<br />
Note the default is to keep the ssh login open (might have to if all else fails kill it to stop it).<br />
<br />
<div style="font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 100%; margin-bottom: 0in;">
<span style="font-family: "helvetica";"><span style="font-size: x-small;">1 ssh
required (no sqlplus required) (login and password on host required)</span></span></div>
<div style="line-height: 100%; margin-bottom: 0in;">
<span style="font-variant: normal;"><span style="font-family: "helvetica";"><span style="font-size: x-small;"><span style="letter-spacing: normal;"><span style="font-style: normal;"><span style="font-weight: normal;">//
</span></span></span></span></span></span><span style="font-variant: normal;"><span style="font-family: "helvetica";"><span style="font-size: x-small;"><span style="letter-spacing: normal;"><span style="font-style: normal;"><span style="font-weight: normal;">log
in to host </span></span></span></span></span></span><span style="font-variant: normal;"><span style="font-family: "helvetica";"><span style="font-size: x-small;"><span style="letter-spacing: normal;"><span style="font-style: normal;"><span style="font-weight: normal;">(desktop hosts IP my change)</span></span></span></span></span></span></div>
<div style="line-height: 100%; margin-bottom: 0in;">
<span style="font-variant: normal;"><span style="font-family: "helvetica";"><span style="font-size: x-small;"><span style="letter-spacing: normal;"><span style="font-style: normal;"><span style="font-weight: normal;">bash-4.2$
ssh -p 22 user@___the_ip_address__</span></span></span></span></span></span></div>
<div style="font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 100%; margin-bottom: 0in;">
<span style="font-family: "helvetica";"><span style="font-size: 12px;">[need password for user]</span></span></div>
<div style="font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 100%; margin-bottom: 0in;">
<span style="font-family: "helvetica";"><span style="font-size: x-small;">>ssh
-p 2222 <a href="mailto:oracle@localhost">oracle@localhost</a></span></span></div>
<div style="font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 100%; margin-bottom: 0in;">
<span style="font-family: "helvetica";"><span style="font-size: x-small;">[password
oracle]</span></span></div>
<div style="font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 100%; margin-bottom: 0in;">
<span style="font-family: "helvetica";"><span style="font-size: x-small;">. oraenv -- ie setup oracle environment</span></span></div>
<div style="font-variant-east-asian: normal; font-variant-ligatures: normal; font-variant-position: normal; line-height: 100%; margin-bottom: 0in;">
<span style="font-family: "helvetica";"><span style="font-size: 12px;">orcl12c -- the default environment may have several</span></span></div>
<div style="font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 100%; margin-bottom: 0in;">
<span style="font-family: "helvetica";"><span style="font-size: x-small;">>sql system/oracle</span></span></div>
<div style="font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 100%; margin-bottom: 0in;">
<br /></div>
<div style="font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 100%; margin-bottom: 0in;">
<span style="font-family: "helvetica";"><span style="font-size: x-small;">Or</span></span></div>
<div style="font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 100%; margin-bottom: 0in;">
<span style="font-family: "helvetica";"><span style="font-size: x-small;">2: ssh
required (sqlcl required) </span></span><span style="font-family: "helvetica"; font-size: 12px;">(login and password on host required)</span></div>
<div style="font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 100%; margin-bottom: 0in;">
<span style="font-family: "helvetica";"><span style="font-size: x-small;">[IN
ADVANCE] ssh -L 1521:localhost:1521 user@__the_ip_address__<todays ip=""></todays></span></span></div>
<div style="font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 100%; margin-bottom: 0in;">
<span style="font-family: "helvetica";"><span style="font-size: 12px;">[need password for user]</span></span></div>
<div style="font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 100%; margin-bottom: 0in;">
<span style="font-family: "helvetica";"><span style="font-size: x-small;">On your
own machine using sqlcl sqlplus sqldeveloper etc locally and your local 1521 port: (port forward from a different port if that is in use)</span></span></div>
<br />
<div style="font-variant-east-asian: normal; font-variant-ligatures: normal; font-variant-position: normal; line-height: 100%; margin-bottom: 0in;">
<span style="font-family: "helvetica";"><span style="font-size: 9pt;">sql system/oracle@localhost:1521/orcl</span></span></div>
<div style="font-variant-east-asian: normal; font-variant-ligatures: normal; font-variant-position: normal; line-height: 100%; margin-bottom: 0in;">
<span style="font-family: "helvetica";"><span style="font-size: 9pt;"><br /></span></span></div>
<div style="font-variant-east-asian: normal; font-variant-ligatures: normal; font-variant-position: normal; line-height: 100%; margin-bottom: 0in;">
3/Do not 'yum update' 2017 Developer Day VM</div>
<div style="font-variant-east-asian: normal; font-variant-ligatures: normal; font-variant-position: normal; line-height: 100%; margin-bottom: 0in;">
<br /></div>
<div style="font-variant-east-asian: normal; font-variant-ligatures: normal; font-variant-position: normal; line-height: 100%; margin-bottom: 0in;">
<span style="font-family: "helvetica";"><span style="font-size: 9pt;">Warning do not 'yum </span><span style="font-size: 12px;">update'</span><span style="font-size: 9pt;"> a 2017 </span><span style="font-size: 12px;">developer</span><span style="font-size: 9pt;"> day VM (if you do </span><span style="font-size: 12px;">you will upgrade to Oracle Linux 7.4 and you</span><span style="font-size: 9pt;"> guest desktop will not resize by mouse action (you can still resize by command line))</span></span></div>
<div style="font-variant-east-asian: normal; font-variant-ligatures: normal; font-variant-position: normal; line-height: 100%; margin-bottom: 0in;">
<span style="font-family: "helvetica";"><span style="font-size: 9pt;"><br /></span></span></div>
<div style="font-variant-east-asian: normal; font-variant-ligatures: normal; font-variant-position: normal; line-height: 100%; margin-bottom: 0in;">
<br /></div>
<div style="background-color: white; font-family: Menlo; font-size: 11px; font-stretch: normal; line-height: normal;">
<br /></div>
<div style="font-variant-east-asian: normal; font-variant-ligatures: normal; font-variant-position: normal; line-height: 100%; margin-bottom: 0in;">
</div>
<div style="background-color: white; font-family: Menlo; font-size: 11px; font-stretch: normal; line-height: normal;">
<br /></div>
<div>
<span style="font-variant-ligatures: no-common-ligatures;"><br /></span></div>
<br />
<br /></div>
Turloch O'Tierneyhttp://www.blogger.com/profile/08870427718022428504noreply@blogger.com3tag:blogger.com,1999:blog-2442647981995819981.post-35263563403514143722017-04-04T05:06:00.000-07:002017-04-04T05:06:14.745-07:00SQLDeveloper/SQLcl LDAP + url + 3rd party connection tricks<div dir="ltr" style="text-align: left;" trbidi="on">
SQLDeveloper/SQLcl LDAP + url + 3rd party connection tricks:<br />
<br />
SQLDeveloper LDAP look up only tested with (i.e. only works with) OID LDAP Very little code - issue is setup for testing non default setup (with different OID setups) before release.<br />
Note look up is at configuration save time not at live connection create time.<br />
<br />
Can be avoided:<br />
<div>
<br />Note you can use url based LDAP calls
(connection type -> advanced) - awkward - the ldap server is queried
at connect time (for host port etc).</div>
<div>
Note there is a different syntax depending on whether you are using thick(oci/C) or thin(pure java) driver.<br /></div>
<div>
These 'refer to ldap by url' connections can be exported imported etc as normal.</div>
<span><br />Old semi related LDAP blog: <br /><a data-saferedirecturl="https://www.google.com/url?hl=en&q=http://totierne.blogspot.co.uk/2009/03/sqldeveloper-ldap-success-and-failure.html&source=gmail&ust=1491392105895000&usg=AFQjCNEh0abs52ySS72Zk2nkShToP_V79g" href="http://totierne.blogspot.co.uk/2009/03/sqldeveloper-ldap-success-and-failure.html" target="_blank">http://totierne.blogspot.co.<wbr></wbr>uk/2009/03/sqldeveloper-ldap-<wbr></wbr>success-and-failure.html</a></span><br />
<br />
<span>SQLCL(+connect command) LDAP;</span><br />
<span> http://barrymcgillin.blogspot.co.uk/2015/01/sqlcl-ldap-anyone.html</span><br />
<span>ie set LDAPCON jdbc:oracle:thin:@ldap:__WHATEVER_YOU_WANT__ use #ENTRY# for whatever you want your lookup is called eg ORCL in connect system/manager@ORCL</span><br />
<span>LDAPCON can be shell/dos environmental variable. </span><br />
<span>This is a very thin helper search and replace for the raw 'explicit ldap url' method.</span><br />
<br />
<span>Actually you can put in connect system/manager@[1]</span><br />
<br />
<span>[1]_whatever_url_you_want_only_likely_to_work_for_</span><span><span>jdbc:oracle:thin:_</span></span><span><span><span>jdbc:oracle:oci</span></span>__</span><br />
<br />
<span>Some 3rd party url used to work if classpath OK</span><br />
<span>That has been deemphasised not tested</span><br />
<span>I do not think we went out of our way to break it but not tested usually eventually means does not work:</span><br />
<span>http://dermotoneill.blogspot.co.uk/2010/11/workheet-hints.html </span><br />
<span>http://dermotoneill.blogspot.co.uk/2010/11/cross-database-bridge-statement.html is a special case for getting 3rd party information into Oracle database (select on 3rd party side (limited to select i.e. more likely to work), insert on Oracle side).</span><br />
<span><br /></span>
<span>Thank you for your time,</span><br />
<span>Turloch</span><br />
<span>-SQLDeveloper Team</span><br />
<span><br /></span></div>
Turloch O'Tierneyhttp://www.blogger.com/profile/08870427718022428504noreply@blogger.com0tag:blogger.com,1999:blog-2442647981995819981.post-1642971077619522372017-04-03T05:46:00.002-07:002017-04-03T05:46:40.474-07:00Kerberos and SQLDeveloper (without Oracle Client)<div dir="ltr" style="text-align: left;" trbidi="on">
Hi Kerberos users,<br />
<br />
#1/Confirm your configuration with sqlplus.<br />
If sqlplus works -> with Oracle Client should work.<br />
<br />
If you do not want to use Oracle Client:<br />
The non Oracle Client route is a different 'pure java' code path - no sqlnet.ora configuration.<br />
<br />
#2/Cache - needs to be blank or point to a file ie not OSMFT If blank password is prompted for (nearly) each time.<br />
#3/http://www.oracle.com/technetwork/java/javase/downloads/jce8-download-2133166.html jce may be required for some common authentication/encryption algorithms.<br />
<br />
#4/Oracle Kerberos connection code is available at:<br />
https://docs.oracle.com/database/121/JJDBC/clntsec.htm#JJDBC28344<br />
<br />
#5/There is a way of tracing thin - it is documented somewhere - never used it myself (as I have access to debugging into the code) - could not find it with a few searches - from memory it involves a Man[person/process]In The Middle technique.<br />
Old style 'C' tracing (set on the server/listener side) may be of some use.<br />
<br />
#6/I wrote up this: <br />
http://totierne.blogspot.co.uk/2013/02/introduction-to-tracing.html <br />
However it was more for the text of what sql command failed rather than for connection issues.<br />
<br />
Thank you for your time,<br />
Turloch O'Tierney<br />
<br />
-SQLDeveloper Team</div>
Turloch O'Tierneyhttp://www.blogger.com/profile/08870427718022428504noreply@blogger.com0tag:blogger.com,1999:blog-2442647981995819981.post-31752722552931615312016-05-05T04:00:00.000-07:002016-08-25T06:27:08.666-07:00Developer day VM Updated: 4/25/2016 Errata<div dir="ltr" style="text-align: left;" trbidi="on">
Download 'Developer Days VM' : including patched 12.1.0.2.13:<br />
http://www.oracle.com/technetwork/database/enterprise-edition/databaseappdev-vm-161299.html<br />
<br />
Use case:<br />
Developer - VM on their machine with recent Oracle software, with no non VM install deinstall setup issues..<br />
Testing (i.e. non production) use, no non VM install deinstall setup issues...<br />
<br />
Update 25 August: enabled ORDS/Rest enabled table (hrrest.employees) :<br />
(Thought this was in the readme)<br />
http://localhost:8080/ords/hrrest/employees/<br />
<br />
Major:<br />
Shipped with second pdb[1] for from scratch ORDS setup if you want.<br />
Bump up cpus/Ram<br />
- absolute minimum/default (but slow)1 cpu 2Gig RAM,<br />
-(fast enough but impacts basic host machine (i5/8Gb))2cpu 3Gig RAM <br />
<br />
Minor:<br />
New in this release small bump in versions of (especially) ORDS and sqlcl.[4]<br />
Better setup of ORDS by default (url for select from an example table enabled)<br />
Reset does not cover initial ORDS.<br />
Drop pdb[2]/create pdb[3] and reset up ORDS from the labs if you want to rebuild ORDS configuration.<br />
<br />
Absolutely tiny:<br />
No fancy virtualbox options documented especially for this VM - out of the box: port forward from host to guest.<br />
Built with virtualbox 5.0.0 (and extras 5.0.0)<br />
Last Linux 'yum update' about 1 March (might need proxy in yum.conf) - if you update the kernel you will need to reinstall virtualbox extras to get a better UI integration guest to host.<br />
~/setsize.sh called on gnome login to set screen size and pop up terminal.<br />
APEX is too slow the first time - after that it succeeds OK.<br />
To reset firefox (eg to clear history) try:<br />
__log out/exit from firefox__ then cd ~; rm -rf ~/.mozilla ; unzip
mozillablob.zip<br />
ords.sh takes an argument path/to/the/war - so it knows which one to start/stop/ ps -ef| grep for<br />
<br />
[1]pdb -> Oracle Multitenant - big new feature in 12 - few extra resources (besides 1.5Gig disk disk) for pdb which appears to the user (with a few restrictions to DBA operations) a new database. I was thinking the VM might host many PDBs<br />
- pdb per developer in the group?<br />
- pdb per software version/product?<br />
- create pdb automatically on demand?(2 minutes)<br />
- Have one spare PDB available so requester does not have to wait 2 mins? (Have a function that returns service name of pdb to use so prebuilt pdb does not need to be renamed (rather than demanding new pdb by name))<br />
Bump up the [Core database RAM - currently 800meg]i.e. SGA/Add Extra Virtual Disk if you are going over 6 VMs...<br />
<br />
[2] To drop PDB named SCRATCHT (initially pdb named ORDS is pretty blank - just 'hr' schema)<br />
BEGIN<br />
EXECUTE IMMEDIATE 'ALTER PLUGGABLE DATABASE "SCRATCHT" CLOSE IMMEDIATE';<br />
EXECUTE IMMEDIATE 'DROP PLUGGABLE DATABASE "SCRATCHT"<br />
INCLUDING DATAFILES';<br />
END;<br />
<br />
[3] To create PDB (THE_NAME if not entered defaults to pdb name "ORDS" - if there is an "ORDS" pdb already it errors out).<br />
<br />
createnewpdb THE_NAME<br />
[type y enter to confirm details]<br />
creates pdb (including users tablespace)<br />
creates HR schema, create tnsnames.ora entry,<br />
Ensures pdb is open by default<br />
Ensures passwords do not expire (change this to suit your security requirements)<br />
tests 32k varchar is on (set in seed).<br />
<br />
[4]sqlcl is undergoing continuous development/updates - any problems confirm first on latest download from:<br />
http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html<br />
(it is less than 20 meg download).</div>
Turloch O'Tierneyhttp://www.blogger.com/profile/08870427718022428504noreply@blogger.com13tag:blogger.com,1999:blog-2442647981995819981.post-16903146775394764742016-01-28T04:03:00.000-08:002016-01-28T04:04:35.880-08:00Oracle VM errata released 27 Jan 2016<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
Oracle VM errata</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
<br /></div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
<div>
Download 7.5Gig from<br />
<br /></div>
<div style="color: black; font-family: 'Times New Roman'; font-size: medium;">
<span style="background-color: white; color: #222222; font-family: "arial" , sans-serif; font-size: x-small;">http://www.oracle.com/technetwork/database/enterprise-edition/databaseappdev-vm-161299.html</span></div>
</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
<br /></div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
Get back to me if there are any issues so I can make a better one.</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
<br /></div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
Should have told people:</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
<br /></div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
<div>
(I am a developer on (sqlcl/sqldeveloper) user of (Oracle Database/jdbc/java/Oracle Linux/bash) so my biases are in that order) </div>
<div>
<br /></div>
</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
Introduction to Oracle Database? Not used them myself but...</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
(TODO: Need to check links from outside Oracle)</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
Oracle doc - Oracle Database Concepts - https://docs.oracle.com/database/121/CNCPT/toc.htm </div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
high level and useful view of the Oracle Database.</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
<br /></div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
Oracle doc was reorganized to include</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
2 day dba https://docs.oracle.com/database/121/ADMQS/toc.htm</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
2 day developer https://docs.oracle.com/database/121/TDDDG/title.htm</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
guides.</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
<br /></div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
Fancy new database stuff in Oracle Database 12c:</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
multitenant - pluggable databases.</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
32k varchar2</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
in memory option</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
<div>
<br /></div>
<div>
1/(Oracle software: database 12.1.0.2.13 (i.e. patched as of October/November) (APEX/ORDS/sqldev/sqlcl/modeller/labs) - as of Christmas 2015 (or later) Oracle Linux as of November ).</div>
<div>
<br /></div>
<div>
2/Check the licensing (I am not a lawyer...)</div>
<div>
<br /></div>
<div>
3/Oracle Linux 7.1 - you might be able to (put a proxy in /etc/yum.conf if necessary) and yum update -> Oracle Linux 7.2. I had to remove some old kernels so they would not break the update to 7.2 - I think they are removed in the final VM so you should not have kernel issues.</div>
<div>
<br /></div>
<div>
4/Virtualbox extras - 4.0.30 - you might be able to updated to 5.x (i.e. dependencies - kernel headers installed)</div>
</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
4.0.30 should work - with warnings - in 5.</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
<br /></div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
5/Defaults to 2GigRAM/1CPU - that is the bare minimum - update possible on import or settings after import. </div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
<br /></div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
6/It port forwards from the host so:</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
sqlplus system/oracle@localhost:1521/orcl12c</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
and</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
sqlplus system/oracle@localhost:1521/orcl</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
should work on host (if you have sqlplus installed) or guest - to connect to the guest database</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
<br /></div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
7/Other new new stuff: sqlcl [startup script sql] 11 meg download (requires java) acts sort of like sqlplus </div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
<br /></div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
(Download http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html or run from guest:)</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
<div>
sql system/oracle@localhost:1521/orcl12c</div>
<div>
and</div>
<div>
sql system/oracle@localhost:1521/orcl</div>
</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
<br /></div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
8/ If you are not familiar with Oracle:</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
Example sql to confirm connection:</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
select 1 from dual;</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
[dual is a fake 1 row table in Oracle].</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
<br /></div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
9/Sqldeveloper home:</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
<br /></div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
Forum:</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
https://community.oracle.com/community/database/developer-tools/sql_developer</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
<br /></div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
10/Other Oracle Database downloads (check the licenses) </div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
- other VMs</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
- full Oracle Database</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
- Oracle database XE 11,2 (Easy install/'Cut down' 'slightly more lenient' license)</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
- instant client including sqlplus</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
<br /></div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
11/Setup decisions:</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
<br /></div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
TWO_TASK=ORCL is set in .bashrc</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
wrapper script ~/bin/sql - not used (further down the path)</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
(Other wrapper scripts are to ensure .bashrc are set for PATH/Java/Database environmental variables when for example called from icon click)</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
APEX 5 installed on pdb (rather than cdb)</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
varchar2(32k) is on</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
Default system connection in sqldeveloper is for pdb (pluggable database).</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
<br /></div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
What can go wrong:</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
-VM might not start properly - looks like a timing issue on slow machine. (I can eventually ssh in but UI broken) - 'ssh oracle@localhost' in and 'sudo shutdown -r now' might help.</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
-Overlap of icons occasionally</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
-Some things missing due to desire to reduce size of VM - for example the database creation DBCA assistant removed,</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
-patches applied to seed (rather than (as seen in the documentation) not patch seed and get dba to patch new pluggable databases on creation).</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
-ORDS startup shutdown script will be confused with two ORDS running (1 startup ords and 1 labs ords (launched from sqldeveloper) for example).</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
<br /></div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
Links:</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
For fancy stuff (SQLDeveloper) developer/manager blogs see:</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
<br /></div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
For example: javascript and aliases in sqlcl</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
<br /></div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
http://krisrice.blogspot.com</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
http://barrymcgillin.blogspot.co.uk</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
http://www.thatjeffsmith.com/sql-developer/</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
http://dermotoneill.blogspot.co.uk/</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
http://totierne.blogspot.com</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: small;">
<br /></div>
</div>
Turloch O'Tierneyhttp://www.blogger.com/profile/08870427718022428504noreply@blogger.com0tag:blogger.com,1999:blog-2442647981995819981.post-74273462470150165982015-05-07T08:02:00.000-07:002015-05-07T08:16:58.850-07:00Ways of connection - sqlcl and the connect command<div dir="ltr" style="text-align: left;" trbidi="on">
Where it looks for connections is a bit long winded:<br />
Check -optl if this does not quite match what you are seeing.<br />
<br />
Variables we support:<br />
TNS_ADMIN (for finding tnsnames.ora)<br />
LOCAL (windows=TWO_TASK)<br />
TWO_TASK (non windows i.e. my database connection information e.g. tnsnames.ora entry name or EZCONNECT)<br />
ORACLE_HOME (for finding tnsnames.ora)<br />
SQLPATH (for finding login.sql)<br />
PATH for finding .dll<br />
LD_LIBRARY_PATH for finding .so<br />
ORACLE_SID used in bequeath connection by thick oci driver.<br />
<br />
<br />
tnsnames.ora - looks for tnsnames.* for example so might pick up an old setting in a .SAV file.<br />
<br />
connect -oci username/password<br />
nothing given:if currently connected try same utl different connection.<br />
nothing given:not currently connected and -oci try bequeath<br />
<br />
try TWO_TASK/LOCAL (if these are not null go to 'something given')<br />
try localhost:1521/orcl<br />
try 127.0.0.1:1521:$ORACLE_SID<br />
<br />
if something given<br />
try LDAPCON environment variable http://totierne.blogspot.in/2015/02/introducing-ldapcon-helper-feature-for.html<br />
try tnsnames.ora<br />
try NET xml store of connections http://totierne.blogspot.in/2015/04/net-command-persistently-store-network.html<br />
try passing on to the driver untouched (could be (DESCRIPTION= or hostname resolution for example)<br />
try hostname resolution ie @hostname or @hostname:1521/hostname (in case hostname=service name) (try with or without domain eg oracle.com - or domain got from looking up resolved host)<br />
(if -oci try thick then try thin for each possibility (there are one or two that currently do not try thick))<br />
<br />
On no connection give error output for each attempt. (optl shows what it is trying whether it connects or not).<br />
<br />
If password is missing prompt for it, if connection fails and there was a prompt - prompt for everything up to 3 times.<br />
At the username prompt: user@dbname is not currently supported.<br />
<div>
<br /></div>
</div>
Turloch O'Tierneyhttp://www.blogger.com/profile/08870427718022428504noreply@blogger.com0tag:blogger.com,1999:blog-2442647981995819981.post-13854537369797304282015-05-07T07:52:00.001-07:002015-05-07T07:52:07.703-07:00SQLCL command line options<div dir="ltr" style="text-align: left;" trbidi="on">
SQLCL options:<br />
<br />
new:<br />
-oci - try looking for 12.1.0.2 oci 'thick' c based library<br />
-optl - turn on logging<br />
-sshkey -sshhost I have not used these could be related to: http://barrymcgillin.blogspot.in/2015/05/sqlcl-cloud-connections-via-secure.html seems related.<br />
<br />
From sqlplus<br />
-h -help - show help page<br />
-l -login - do not reprompts for user/password on failure<br />
-R[estrict] 1 -R 2 -R 3 - restrict sqlcl for example R 3 - do not use @<br />
-s[ilent] - suppress console output<br />
-v - version<br />
/nolog - do not log in<br />
-nologin - do not read login.sql<br />
@file.sql - run this file and come back if it does not end in exit<br />
username/password@connectionidentifier as sysdba|sysbackup|sysdg|syskm|sysasm|sysoper - login ([as role] is optional)<br />
<br />
-optl shows you logging info:<br />
where it looks for tnsnames.* and what urls it is trying<br />
$ ./sql -optl notauser/notapassword@notanid<br />
<br />
SQLcl: Release 4.1.0 Release Candidate on Thu May 07 14:34:11 2015<br />
<br />
Copyright (c) 1982, 2015, Oracle. All rights reserved.<br />
<br />
<br />
May 07, 2015 2:34:11 PM oracle.dbtools.raptor.utils.TNSHelper checkForTns<br />
INFO: Checking for tnsnames.* in :/home/notauser<br />
May 07, 2015 2:34:11 PM oracle.dbtools.raptor.utils.TNSHelper checkForTns<br />
INFO: Checking for tnsnames.* in :/etc<br />
May 07, 2015 2:34:11 PM oracle.dbtools.raptor.newscriptrunner.SQLPLUS logConnectionURL<br />
INFO: Attempting to connect using URL= "jdbc:oracle:thin:@notanid"<br />
May 07, 2015 2:34:11 PM oracle.dbtools.raptor.newscriptrunner.SQLPLUS logConnectionURL<br />
INFO: Attempting to connect using URL= "jdbc:oracle:thin:@notanid:1521/notanid"<br />
USER = notauser<br />
URL = jdbc:oracle:thin:@notanid<br />
Error Message = IO Error: Unknown host specified<br />
USER = notauser<br />
URL = jdbc:oracle:thin:@notanid:1521/notanid<br />
Error Message = IO Error: Unknown host specified<br />
<br />
Warning: You are no longer connected to ORACLE.<br />
<br />
now try the thick driver: -oci (throws an error because I have not got the .so library in the path)<br />
./sql -oci -optl notauser/notapassword@notanid<br />
<br />
SQLcl: Release 4.1.0 Release Candidate on Thu May 07 14:36:10 2015<br />
<br />
Copyright (c) 1982, 2015, Oracle. All rights reserved.<br />
<br />
<br />
May 07, 2015 2:36:10 PM oracle.dbtools.raptor.utils.TNSHelper checkForTns<br />
INFO: Checking for tnsnames.* in :/home/notauser<br />
May 07, 2015 2:36:10 PM oracle.dbtools.raptor.utils.TNSHelper checkForTns<br />
INFO: Checking for tnsnames.* in :/etc<br />
May 07, 2015 2:36:10 PM oracle.dbtools.raptor.newscriptrunner.SQLPLUS logConnectionURL<br />
INFO: Attempting to connect using URL= "jdbc:oracle:oci8:@notanid"<br />
May 07, 2015 2:36:11 PM oracle.dbtools.raptor.newscriptrunner.SQLPLUS logConnectionURL<br />
INFO: Attempting to connect using URL= "jdbc:oracle:thin:@notanid"<br />
May 07, 2015 2:36:11 PM oracle.dbtools.raptor.newscriptrunner.SQLPLUS logConnectionURL<br />
INFO: Attempting to connect using URL= "jdbc:oracle:thin:@notanid:1521/notanid"<br />
USER = notauser<br />
URL = jdbc:oracle:oci8:@notanid<br />
Error Message = no ocijdbc12 in java.library.path<br />
USER = notauser<br />
URL = jdbc:oracle:thin:@notanid<br />
Error Message = IO Error: Unknown host specified<br />
USER = notauser<br />
URL = jdbc:oracle:thin:@notanid:1521/notanid<br />
Error Message = IO Error: Unknown host specified<br />
<br />
Warning: You are no longer connected to ORACLE.<br />
<br />
Next post will be about how it attempts to connect.</div>
Turloch O'Tierneyhttp://www.blogger.com/profile/08870427718022428504noreply@blogger.com0tag:blogger.com,1999:blog-2442647981995819981.post-75383083154855048272015-05-05T08:27:00.000-07:002015-05-05T08:27:06.654-07:00Pause prompt works per page:<div dir="ltr" style="text-align: left;" trbidi="on">
bash-4.1$ bash sql scott/[the password]@[THE DATABASE}<br />
<br />
SQLcl: Release 4.1.0 Release Candidate on Tue May 05 16:21:03 2015<br />
<br />
Copyright (c) 1982, 2015, Oracle. All rights reserved.<br />
<br />
<br />
Connected to:<br />
Oracle Database 12c Enterprise Edition Release 12.x.x.x.x - 64bit Production<br />
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options<br />
<br />
<br />
SQL> set pause "Press any key to continue..."<br />
<br />
SQL> set pause on<br />
<br />
SQL> show pause<br />
PAUSE is ON and set to "Press any key to continue..."<br />
<br />
SQL> show pagesize<br />
pagesize 24<br />
<br />
<br />
SQL> select * from emp;<br />
<br />
Press any key to continue...<br />
EMPNO ENAME JOB MGR HIREDATE<br />
---------- ---------- --------- ---------- -------------------------------<br />
SAL COMM DEPTNO<br />
---------- ---------- ----------<br />
7369 SMITH CLERK 7902 17-DEC-80 <br />
800 20<br />
<br />
7499 ALLEN SALESMAN 7698 20-FEB-81 <br />
1600 300 30<br />
<br />
7521 WARD SALESMAN 7698 22-FEB-81 <br />
1250 500 30<br />
<br />
7566 JONES MANAGER 7839 02-APR-81 <br />
2975 20<br />
<br />
7654 MARTIN SALESMAN 7698 28-SEP-81 <br />
1250 1400 30<br />
<br />
7698 BLAKE MANAGER 7839 01-MAY-81 <br />
2850 30<br />
<br />
7782 CLARK MANAGER 7839 09-JUN-81 <br />
<br />
Press any key to continue...<br />
EMPNO ENAME JOB MGR HIREDATE<br />
---------- ---------- --------- ---------- -------------------------------<br />
SAL COMM DEPTNO<br />
---------- ---------- ----------<br />
2450 10<br />
<br />
7788 SCOTT ANALYST 7566 19-APR-87 <br />
3000 20<br />
<br />
7839 KING PRESIDENT 17-NOV-81 <br />
5000 10<br />
<br />
7844 TURNER SALESMAN 7698 08-SEP-81 <br />
1500 0 30<br />
<br />
7876 ADAMS CLERK 7788 23-MAY-87 <br />
1100 20<br />
<br />
7900 JAMES CLERK 7698 03-DEC-81 <br />
950 30<br />
<br />
7902 FORD ANALYST 7566 03-DEC-81 <br />
3000 20<br />
<br />
Press any key to continue...<br />
EMPNO ENAME JOB MGR HIREDATE<br />
---------- ---------- --------- ---------- -------------------------------<br />
SAL COMM DEPTNO<br />
---------- ---------- ----------<br />
7934 MILLER CLERK 7782 23-JAN-82 <br />
1300 10<br />
<br />
<br />
14 rows selected<br />
<br />
<br />
SQL> exit<br />
Disconnected from Oracle Database 12c Enterprise Edition Release 12.x.x.x.x - 64bit Production<br />
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options<br />
<div>
<br /></div>
</div>
Turloch O'Tierneyhttp://www.blogger.com/profile/08870427718022428504noreply@blogger.com0tag:blogger.com,1999:blog-2442647981995819981.post-56166930333325036772015-04-29T10:41:00.000-07:002015-04-29T10:43:05.126-07:00Command Line: sqlcl startup shutdown of pdb and non pdb databases (Should even work from a Mac - pure Java)<div dir="ltr" style="text-align: left;" trbidi="on">
Tested against release 16th April 2015 drop.<br />
<br />
Startup and shutdown of pluggable and non pluggable datbases.<br />
<br />
bash-4.1$ ./sql sys@_non_pluggable__<br />
<br />
SQLcl: Release 4.1.0 Release Candidate on <date></date><br />
<br />
Copyright (c) 1982, 2015, Oracle. All rights reserved.<br />
<br />
<br />
Connected to an Idle instance, startup command available.<br />
SQL> startup<br />
Started up<br />
Database Mounted<br />
Database Open<br />
<br />
Total System Global Area 12345 bytes <br />
Fixed Size 54321 bytes <br />
Variable Size 12345 bytes <br />
Database Buffers 54321 bytes <br />
Redo Buffers 12345 bytes <br />
SQL> shutdown<br />
Instance stopped<br />
Database closed.<br />
Database dismounted.<br />
Database shutdown.<br />
SQL> connect sys@__pluggable__ as sysdba<br />
Connected<br />
<br />
SQL> shutdown<br />
Pluggable database closed<br />
SQL> startup<br />
Pluggable database opened<br />
SQL><br />
<br />
One point to remember - configure your listener for remote (or 127.0.0.1 loopback) startup/shutdown if you are not using thick/bequeath Oracle client 'C' code, so the listener can find the database when the database is down.<br />
<br />
listener.ora entry:<br />
<br />
SID_LIST_LISTENER =<br />
(SID_LIST=<br />
(SID_DESC=<br />
(GLOBAL_DBNAME=THEDATABASE)<br />
(ORACLE_HOME=THE_ORACLE_HOME)<br />
(SID_NAME=THEDATABASE)<br />
)<br />
)<br />
<br />Should even work from a Mac - pure Java..</div>
Turloch O'Tierneyhttp://www.blogger.com/profile/08870427718022428504noreply@blogger.com1tag:blogger.com,1999:blog-2442647981995819981.post-29383636563279647112015-04-29T03:23:00.000-07:002015-04-29T03:29:29.570-07:00NET Command - persistently store network details with tab completion<div dir="ltr" style="text-align: left;" trbidi="on">
Example using <b>tab completion</b>: (need to be in sql for tab complete to work e.g. ./sql /nolog)<br />
<br />
SQL> net unique=localhost:1521/mysid;<br />
SQL> net list<br />
unique<br />
SQL> net list unique<br />
unique<br />
------<br />
localhost:1521/mysid<br />
SQL> <b>connect username/password@uni__TAB_FOR_COMPLETION__<tab complete="" to=""></tab></b><br />
<div>
SQL> connect username/password@unique</div>
<br />
tab completion works for net shortcuts and tnsnames.ora details.<br />
<br />
Behind the scenes net is very similar to the<b> alias command</b>.<br />
<br />
<b>**************************************************************</b><br />
<b>If anyone has useful alias command uses or wanted extensions</b><br />
<b>to alias command I would be interested to know. </b><br />
<b>(Jeff Smith is the Product Manager if you want to go through official channels).</b><br />
<b>**************************************************************</b><br />
<b><br /></b>
Turloch<br />
<br />
The Net help page:<br />
<br />
>help net<br />
NET<br />
------<br />
<br />
Command line only - not for sqldeveloper.<br />
<br />
NET is a command which allows you to save a network details and assign it a shortcut command.<br />
"net" - print a list of net short cuts<br />
"net list <aliasname>" - list the contents of the short cut</aliasname><br />
"net name=localhost:1521/XE;" simple net command<br />
"net drop name" - delete the short cut called name<br />
<br />
net is single line terminated by newline<br />
net ..=.. is terminated by ';'<br />
net on its own gives a list of existing short cuts.<br />
<br />
controlled by<br />
set net on|off|readonly - default ON<br />
readonly means only do try to enter a net shortcut on successful connect command<br />
set noverwrite on|off|warn - default WARN<br />
net overwrite: warn prints a warning if an override would otherwise happen.<br />
<br />
<br /></div>
Turloch O'Tierneyhttp://www.blogger.com/profile/08870427718022428504noreply@blogger.com1