Hi, just installed sqlcl and notice that it errors when I paste query with line-breaks whereas sqlplus handles the paste with line-breaks just fine. What am I doing wrong?
you state that all of the SQLPLUS connection options are supported, but when I tried LDAP resolution - it doesn't work at all with sqlcl, yet works fine with sqlplus. logging on with /nolog and running "show tns" shows the correct tns folder is in use that contains ldap.ora etc and it prints out all databases (very slow as we have 1000's of dbs registered and cannot be control-c'd!!). sqlcl generates a url like "jdbc:oracle:thin:@dln12345:1521/dln12345" (where dln12345 is our db name) and claims the host is unknown.
How do you mean, 'my oracle' ? If you mean Oracle Database or Client, then it would have a 'sqldeveloper' folder in the $ORACLE_HOME, and in that directory you would find SQLcl and it's associated sql.exe or sql.sh script. If it's not there, it take about 3 minutes to add from our free download, or using yum or brew.
Please help. It says Error Message = IO Error: The Network Adapter could not establish the connection I am new to using databases...so how can i resolve this?
Rakshit Malhotra I talk about VirtualBox solution here, pretty easy, just two downloads www.thatjeffsmith.com/archive/2012/12/i-have-oracle-sql-developer-installed-now-what/
Either a DBA has given you an account, use those credentials, or YOU have created the system yourself, in which case your default admin account is SYS or SYSTEM - SYSTEM is safer.
Hey Ricardo, what errors do you get? And how are you connecting? And where are you connecting to? As you can imagine, there are MANY variables involved here.
Try this "sys@//192.168.47.161:1521/orcl as sysdba" assuming you are trying to login as sys user, next is the ipaddress or hostname and the port number of the database and the service name. It will prompt you for a password. Enjoy
Too bad that this tool has so poor memory management. Try to insert huge files using @ command and it chugs memory until it ends with OutOfMemoryError Like always with oracle -> one step forward and two steps back. :D
Yes, I was running "large" script that contained 100k rows (50000) inserts. File itsef was was ~500M and contained KEYBLOB -s. sqlplus did not work at all because of command-line length (2500)
Will check to see if we're streaming the file in and processing, closing as we go. BUT. If you want to insert that much data, don't do INSERTs. Gen a CSV file and load via External Table or SQL*Loader.
![เป็นไปได้ไหม - WanMai [Performance Video]](http://i.ytimg.com/vi/Eh5hItD4Mr0/mqdefault.jpg)
Finally they added history.Thanks Jeff for your video
Jeff, you absolutely rock! Thank you so much for this!
Ah, thanks!
Very much appreciated! Thx Jeff, well done.
thanks!! stay tuned for more news too 😎
Nice tool. Is it possible to set e global fetch size and access the data in a page by page style like the "more" command in Linux.
Hi, just installed sqlcl and notice that it errors when I paste query with line-breaks whereas sqlplus handles the paste with line-breaks just fine. What am I doing wrong?
set sqlblanklines on
The output format is messed up just like sql plus when there's too much columns to display.
you state that all of the SQLPLUS connection options are supported, but when I tried LDAP resolution - it doesn't work at all with sqlcl, yet works fine with sqlplus. logging on with /nolog and running "show tns" shows the correct tns folder is in use that contains ldap.ora etc and it prints out all databases (very slow as we have 1000's of dbs registered and cannot be control-c'd!!). sqlcl generates a url like "jdbc:oracle:thin:@dln12345:1521/dln12345" (where dln12345 is our db name) and claims the host is unknown.
Darren Lindley barrymcgillin.blogspot.com/2015/01/sqlcl-ldap-anyone.html?m=1
thanks Jeff, good to know
Darren Lindley when I get back from vacation, I'll make sure the tns dump stops after 50 entries
how i can connect sqlcl with wallet i mean to say i wish to connect my autonomous database using sqlcl how i do that
Use set cloudconfig .. example here www.thatjeffsmith.com/archive/2019/12/sqlcl-on-oracle-cloud-infrastructure-oci/
how I know that my oracle has a SQLcl installed?
How do you mean, 'my oracle' ?
If you mean Oracle Database or Client, then it would have a 'sqldeveloper' folder in the $ORACLE_HOME, and in that directory you would find SQLcl and it's associated sql.exe or sql.sh script.
If it's not there, it take about 3 minutes to add from our free download, or using yum or brew.
hi @@JeffSmiththat , my ticket here it's to show to our costumer if has installed in oracle database SQLcl or not, just like that.
Please help. It says
Error Message = IO Error: The Network Adapter could not establish the connection
I am new to using databases...so how can i resolve this?
Rakshit Malhotra SQLcl is just a tool to connect and work with a database...you need a database first.
Jeff Smith so I need to buy some subscription of Oracle database right? Because Oracle 12c isn't available for Mac
Rakshit Malhotra most Mac users run Oracle on Docker or a VirtualBox VM
Rakshit Malhotra I talk about VirtualBox solution here, pretty easy, just two downloads www.thatjeffsmith.com/archive/2012/12/i-have-oracle-sql-developer-installed-now-what/
@Jeff Smith : how did you change this [hr@orcl[smiley]> ] it`s really cool.
Do you mean the emoji? OS X has no problems showing unicode characters, including emojis in their terminals. Windows on the other hand...not so much.
yeah that`s what.... but anyways thanks for reply..really appreciate.!!
there may be a *nix terminal emulator you could use in Windows, like Cygwin, but I've tried them (all on WIN7) with no luck.
:( it`s also not working on win10..hard luck..
unable to connect on windows. is the command same for windows cmd prompt?
shubhi gangele yes. What are you trying and what's your error message?
Jeff Smith command not recognised
shubhi gangele which command?
from where can i download the database required for sql plus?
you have a few options, i talk about them each here medium.com/oracledevs/i-installed-oracle-sql-developer-now-what-71230b9c9303
What do I give for the username?
Either a DBA has given you an account, use those credentials, or YOU have created the system yourself, in which case your default admin account is SYS or SYSTEM - SYSTEM is safer.
cannot connect I get errors when entering my credentials
Hey Ricardo, what errors do you get? And how are you connecting? And where are you connecting to? As you can imagine, there are MANY variables involved here.
show me the literal errors, and then answer my other questions :)
Ricardo Almodovar what error? Copy and paste it here
Try this "sys@//192.168.47.161:1521/orcl as sysdba" assuming you are trying to login as sys user, next is the ipaddress or hostname and the port number of the database and the service name. It will prompt you for a password. Enjoy
@@dcity-b4u if orcl is a sid then sytax would be : username@ip:port:sid
if orcl is a pdb then syntax would be : username@ip:port/pdb
copy pest not working
What are you trying, on what OS, with what version of SQLcl and Java?
Too bad that this tool has so poor memory management.
Try to insert huge files using @ command and it chugs memory until it ends with OutOfMemoryError
Like always with oracle -> one step forward and two steps back. :D
can you give an example Alvar? How do you mean 'insert huge files' using @ - do you mean just running a large script? and how large is your file?
Yes, I was running "large" script that contained 100k rows (50000) inserts. File itsef was was ~500M and contained KEYBLOB -s.
sqlplus did not work at all because of command-line length (2500)
Will check to see if we're streaming the file in and processing, closing as we go. BUT. If you want to insert that much data, don't do INSERTs. Gen a CSV file and load via External Table or SQL*Loader.