when reading the Oracle APEX documentation, I did not understand the reason it asks to connect to the database through sqlplus using sqlplus /nolog then connect sys as sysdba. If it will eventually connect with sys as sysdba, why not doing it from the beginning with sqlplus sys as sysdba command?
Here is what I am talking about:
https://docs.oracle.com/en/database/oracle/application-express/20.1/htmig/downloading-installing-Oracle-AE.html#GUID-7E432C6D-CECC-4977-B183-3C654380F7BF
Understanding connecting to the database through SQLPLUS
375 views Asked by Eslam At
1
There are 1 answers
Related Questions in ORACLE
- sqlplus myusername/mypassword@ORCL not working with Oracle on Docker
- Oracle setting up on k8s cluster using helm charts enterprise edition
- Oracle Managed Data Access Client can't work from IIS but work for local debug environment
- If composite indexing created - indexing is called?
- Oracle Http server ISNT-07551
- why here not creating table?
- Data migration from Oracle Database Clob to GCP Bucket
- SQL Alchemy custom type, forcing blob bind parameter
- How to send message to syslog agent in plsql
- Whatever the data available in previous record it should add to the new record
- I have an Oracle SQL query that is giving me a "ORA-00918: column ambiguously defined" error on a line that is a comment line
- 'ORA-12170: TNS:Connect timeout occurredORA-12170: TNS:Connect timeout occurred' ERROR while working on oracle with laravel
- Is their any way i can open parallel query tabs
- VSCode Libraries not showing for New Java Project
- I can't ssh to my instance, Connection refused
Related Questions in ORACLE-APEX
- How can we open 2 oracle applications at the same time on the same browser?
- VBA, Internet Explorer and Javascript
- Oracle APEX - Enabling Persistent Authentication Breaks Deep Linking
- APEX Office Print - how do I force creation of single PDF in ZIP file
- Oracle APEX 22. Location of Static Application Files
- How to Change this Pl/SQL Codes to handle multiple roles in Apex?
- Oracle Apex Chart with Time Series Axis causing formatting errors with bar width
- Oracle APEX: TypeError: apex.region(...) is null when clicking a button
- Error in Syntax - Oracle APEX - apex_authorization.is_authorized function
- Oracle Apex how to change map background dynamically
- How to have label show up at the very bottom of the bar graph? APEX ORACLE
- Oracle APEX - Moving multiple pages to a new App
- Why is backdrop-filter only working when I manually modify the original CSS file of an Apex Theme in the Browser Inspector?
- How to add the custom icon in oracle apex?
- Editable interactable grid - Display modified value after saving without primary key
Related Questions in SQLPLUS
- sqlplus myusername/mypassword@ORCL not working with Oracle on Docker
- Editor in SQLPLUS gives error when changing default editor
- sqlplus pointing to libclntsh.so.21.1 which does not exists in $ORACLE_HOME/lib
- SP2-0734:Unknown command beginning "CONSTRAINT..."
- I am not able to understand why I am getting this type of an output in SQLPlus. If someone could help me out with this it would be great
- How to add new line in sqlplus within a bash script?
- can't login via sqlplus command but manual login works
- Error appearing while creating a table in my class in oracle 21c
- Does PostgreSQL have a feature like 'Ampersand Substitution' in SQL*Plus?
- Oracle - Load local/client file to blob column
- Merge statement into table creates duplicates?
- Running .sql script file from sqlplus succeeds, but passing the sql string as standard input of sqlplus fails with SQL> SP2-0734 in powershell
- Check oracle db mode as another user faling
- ERROR: ORA-12154: TNS:could not resolve the connect identifier specified (First time installation)
- Remove initial and trailing blank line in SQL *Plus SPOOL (SET MARKUP CSV)
Related Questions in ORACLE-APEX-20.1
- How to upload file as blob to my table | Oracle Apex |
- How to reset list to blank using javascript in Oracle apex
- How do I add validation to text area in oracle apex
- How to send multiple people the mail using UTL_SMTP
- PLS-00306 : wrong number or types of arguments in call to 'SEND'
- UTL_SMTP mail send with No subject , body
- Oracle Apex: Can not call StaticID in Page's Inline CSS
- PLS-00201: identifier 'DBMS_OBFUSCATION_TOOLKIT.DESENCRYPT' must be declared
- Oracle Apex - Delete member from collection
- Oracle Apex 20 - REST source action on column in interactive report
- Oracle APEX 20.1 Inline dialog scroll to top/bottom
- Oracle APEX: using APEX_IG package to manipulate IG
- oralce apex text item save value in Session state in Interactive Report
- Oracle APEX ORA-01722 when creating Interactive Report
- Label is not floating when value set through DA Oracle apex
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Popular Tags
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
I would suspect its historical. In older releases on SQL Plus, if you ran:
on the command line, then on unix environments someone running the 'ps' command could see those details. Even in modern versions of SQL Plus where we remove that from obvious view, then digging into things like command history could expose it.
So always best never to type user or password details on the command line.