New answers tagged sqlplus
I found the issue. It is documented an oracle note (Doc ID 1086519.1). I used the first workaround listed which is to set CURSOR_SHARING to exact. ALTER SESSION SET CURSOR_SHARING=EXACT;
SQL is a query language that allows you to issue a single query or execute a single insert/update/delete. PL-SQL is Oracle's "Procedural Language" SQL, which allows you to write a full program (loops, variables, etc.) to accomplish multiple selects/inserts/updates/deletes. You should learn SQL first from https://www.youtube.com/watch?v=7Vtl2WggqOg, then move ...
Solved by changing the value of "kernel.shmall" in the file /etc/sysctl.conf
Make sure the database is actually running, and if not, start it. If you have an init script, then it's typically something like: sudo service oracle start This has been asked before for Oracle 11g - the answers and comments to that question may be helpful here: ORA-01034: ORACLE not available in oracle 11g
Hope this helps... (wrapped for readability) sqlplus username/password@'(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp) (HOST=hostname)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=service_name) (INSTANCE_NAME=instance_name)))'
First you have to tell Oracle to use the tnsnames.ora file at all. For this open/create file sqlnet.ora and insert row like this: NAMES.DIRECTORY_PATH = (TNSNAMES) You may add other methods for resolution, e.g. 'LDAP', see DIRECTORY_PATH. Entry tnsnames tells Oracle to use an tnsnames.ora file. Regarding the location of these two files the answer is not ...
tnsnames.ora doesn't "come with" anything. The key is not that file, as it is nothing but a names resolution file. And sqlplus is nothing but a CLI application. If you want to connect to an Oracle database (or ANY database) you must have, at a minimum, the client software for that particular database product. For oracle you need to download and install the ...
$SQLPLUS -S username/password@ip:port/servicename<< EOF SQL-STATEMENTS set sqlbl on commit EOF
That is just the paging in SQL*Plus. By default the paging value is 14, that includes a blank line at the start of each page, the line with column headers, the line with heading separators (hyphens) and the rest (11 rows) is for user data. If you increase the pagesize, the result of your query will fit in to 1 page: set pagesize 20 It has nothing to do ...
Top 50 recent answers are included