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
-
These are the way to connect to database. there is not certain reason except password or security hole. :)Osamazx– Osamazx2020-10-11 15:29:03 +00:00Commented Oct 11, 2020 at 15:29
-
Why not just connecting using "sqlplus sys as sysdba" then right the password when prompted?Eslam– Eslam2020-10-11 16:06:38 +00:00Commented Oct 11, 2020 at 16:06
-
1As you said, both work equally well and are in effect identical. The author seems prefer, as a matter of choice, the way he wrote it. If had written it they way you prefer, you can be certain someone, somewhere, would be asking why he didn't specify 'sqlplus /nolog' followed by 'connect sys as sysdba'. When writing docs like that its easier to just specify "a" sequence of commands and not get twisted up explaining all the possible variations.EdStevens– EdStevens2020-10-11 16:44:42 +00:00Commented Oct 11, 2020 at 16:44
Add a comment
|
1 Answer
I would suspect its historical. In older releases on SQL Plus, if you ran:
sqlplus my_user/my_pass
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.
1 Comment
Eslam
I did not mean to enter the password explicitly, I am just saying it can be replaced with "sqlplus sys as sysdba" then user will be asked to enter the password. What is the difference then?