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
371 Views Asked by Eslam At
1
There are 1 best solutions below
Related Questions in ORACLE
- Column displays each count
- MAX and GROUP BY - SQL
- Best Practice for adding columns to a Table in Oracle database
- Updating an Oracle row with value from same row
- Retrieving data from Oracle database
- Ibatis execute update sql on oracle, it is not working and no exceptions
- Building an sql execution plan history
- Implementation of Rank and Dense Rank in MySQL
- how to update the date field for this specific condition using oracle query?
- Oracle stored procedure wrapping compile error with inline comments
- Android: How to connect oracle database using Android Java code?
- SQL Conditional Join on Columns
- Multi value wildcard search in ibatis
- Get count of consecutive days meeting a given criteria
- How to update the metadata of a layer in Oracle imported through FME Workbench?
Related Questions in ORACLE-APEX
- Import dmp file created in Oracle 11g (WE8ISO8859P1) to Oracle 11g XE database (AL32UTF8)
- oracle apex. Create an Export Stored procedure
- Update multiple values in an oracle table using values from an APEX collection
- Adding functionality to a button at the end of each row of the interactive report
- Apex. Calling proc within htp.prn?
- Refresh SQL query while selecting node in tree every time to display results at some text area in the same page
- Showing just the legend of an Oracle Apex/AnyChart Pie Chart
- Oracle Apex dynamically enable/disable text field depending on LOV selected value
- Oracle APEX: Add list boxes on demand
- SQL error: Missing keyword?
- Apex code for inline style
- Apex Application Item is not maintained across sessions
- Oracle sql convert timestamp into format
- APEX: Adding Select List to Tabular Form and then processing based on values
- Access oracle application express from macs on the same network
Related Questions in SQLPLUS
- Ignoring User Exists Error in Oracle
- In Oracle 11g how do you time weight average data hourly between two dates?
- ORA-06502 Error Only in SQLPLUS
- Connect to two DB using Oracle wallet without TNS_ADMIN path change
- Which tables do not have indexes in Oracle?
- Why is SPOOL writing my output with LINESIZE set to 32767?
- accented letters and sql plus/AIX
- How to know what SETS are ON in SQL PLUS?
- Installing rlwrap on linux - without root permission
- Hide SQL > statements in the spool file
- SQL*Plus spool only data and exclude errors
- Recover error WshShell.exec
- How to log queries taking long time
- How to specify tablespace_name in SQLPlus Oracle select
- Write to a file in PL/SQL without spools or utl_file
Related Questions in ORACLE-APEX-20.1
- Understanding connecting to the database through SQLPLUS
- accees csv file stored on server using oracle apex 20.1
- Sql Script file (apex_epg_config.sql) is missing in Oracle Apex 20.2
- Create web source module oracle apex 20.0
- How to count total amount of pending tickets for each day this week in oracle-sql?
- Oracle Apex Select List LOV conditional query
- Error while installing APEX : existing state of package "APEX_200200.WWV_FLOW_SECURITY" has been invalidated
- Oracle UNIQUE constraint allows same value in different case
- Oracle APEX 20.1 :Unable to Import Applications
- apex select2 plugin not work well with oracle apex 20.1
- oracle apex sorting data on chart with Custom sort in underlying query
- get rows only contains specific value in a specific column in Interactive Grid in oracle apex 20.1 with plsql or javascript
- Does anyone know why I am getting this APEX interactive report/X-Content-Type-Options:nosniff issue or how I can resolve it?
- UTL_SMTP mail send with No subject , body
- How to send multiple people the mail using UTL_SMTP
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)
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?
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.