Questions tagged [sqlplus]
Command-Line Utility Program for Oracle
284 questions
1 vote
0 answers
90 views
Understanding of sqlplus STARTUP command syntax
On https://docs.oracle.com/en/database/oracle/oracle-database/19/sqpug/STARTUP.html, the document states that: Startup command ... where db options has the following syntax: [FORCE] [RESTRICT] [...
- 2,126
0 votes
1 answer
50 views
Missing or invalid option
SET SERVEROUTPUT ON; ACCEPT redeem_id CHAR PROMPT 'Enter Redeem ID: '; ACCEPT matric_num CHAR PROMPT 'Enter Matric Number: '; ACCEPT prod_id CHAR PROMPT 'Enter Product ID: '; DECLARE v_prod_name ...
- 1
0 votes
0 answers
27 views
Oracle SQLPlus taking exclusive session and not allowing to run update statements from .Net application
I connected via sqlplus like following: sqlplus user/password@SID I have a .Net application which also connects to same DB using same user and password. But once sqlplus is connected, it was unable to ...
- 451
0 votes
1 answer
682 views
SYS user getting ORA-01017 (invalid username/password; logon denied) even putting right password in Oracle 19c
→ OS: Oracle Linux Server release 8.7 → DBMS: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production - Version 19.3.0.0.0 After cloning a virtual machine that we can connect normally ...
0 votes
1 answer
69 views
sqlplus column header misaligned
In wide sqlplus reports, column headers get misaligned from the data The code that led to this output was: set linesize 32767 set trimspool on col z format a1 alter session set nls_date_format='...
- 111
0 votes
2 answers
3k views
How to install sqlplus in macOS M1 Pro ( silicon chip)
I have been searching in internet for best way to install sqlplus in MacOs apple silicon chip ( arm bases processor). please guide me some easiest method to do that. I saw that many article about ...
Developer
0 votes
1 answer
2k views
sqlplus / as sysdba Connected to an idle instance
anyone can Me help uderstand what is happends? i have oraenv corectly, use su oracle to change user, use this command to conncet as sysdba - sqlplus / as sysdba answer is: SQL*Plus: Release 19.0.0.0....
0 votes
0 answers
291 views
listener issues in oracle 19c
These are my listener.ora and tnsnames.ora files listener.ora SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = dr_DGMGRL) (ORACLE_HOME = /u01/app/oracle/product/19.0.0/...
- 105
0 votes
1 answer
64 views
Oracle colsep is adding newlines. Why?
So, I have a script: set heading off; set feedback off; set linesize 10000; set newpage NONE; set colsep '~' whenever sqlerror exit 1; WHENEVER OSERROR EXIT 255; select TO_CHAR(je.key_date, 'YYYY-MM-...
0 votes
2 answers
1k views
Unable to connect to Oracle user in pluggable database
for some reason, i am unable to connect with any user that I create. their account status is also unlocked. I want to mention one thing; the pdbs are clone of the main pdb. (as shown by their name ...
- 64
-1 votes
1 answer
335 views
How to make sqlplus parse stdin?
I have the data in the following form: 10334,99.4,4241 14354,99.5,6018 16807,93.9,2279 22042,97.5,70341 22117,96.4,70335 22138,95.7,70332 23869,94.4,135649 23937,97.5,135642 23982,96.6,135638 24055,95....
-1 votes
2 answers
1k views
How to export and Import entire oracle database using sqlplus on terminal linux machine?
I have database that i want export from one machine and import into another machine using sqlplus on linux terminal. I have tried nothing
Bruce Wayne
0 votes
2 answers
787 views
Oracle sqlplus doesn't connect to remote DB, only local
I would appriciate some help with an issue that I'm facing. I have two Oracle DB servers with same schemas. I want to run sqlplus from one server to another. I've added the tns_names entries in ...
0 votes
1 answer
94 views
How to silent the login.sql output
[nir@dba etl]$ cat login.sql col TAB# new_value TAB NOPRINT select chr(9) TAB# from dual; set markup csv on delimiter "&TAB" quote off set heading off termout off echo off feedback off ...
- 529
1 vote
1 answer
973 views
Can't log into Oracle 19c database running inside a container from the host
I have a server running Oracle 19c inside a Docker container, and I would like the ability to log into the database from the host using sqlplus. Inside the container, I am able to run this command ...
- 121