patterndockerMinor
Oracle - Can't login with "/ as sysdba", but can with "sys as sysdba"
Viewed 0 times
canwithbutloginsyssysdbaoracle
Problem
I've been working on setting up a docker container running Oracle DB XE 18.4.0. I have the container built from Oracle's dockerfiles and it is working fine, except that I cannot login using
in a sqlplus prompt from inside the container, but
does work. The error message that I receive is
I checked that my
When installing Apex on the local instance of Oracle DB on my development environment, Everything works as expected.
I am working from a Windows 10 (1803) machine which is running docker 18.03.0-ce with a VirtualBox 6.0.2 setup.
connect / as sysdbain a sqlplus prompt from inside the container, but
connect sys as sysdbadoes work. The error message that I receive is
ORA-01017: invalid username/password; logon deniedI checked that my
$ORACLE_HOME and $ORACLE_SID environment variables were set and they look fine. I'm trying to install APEX in this container and the first error that is displayed when running the install script is the failed login error above where the script runs connect / as sysdba.When installing Apex on the local instance of Oracle DB on my development environment, Everything works as expected.
I am working from a Windows 10 (1803) machine which is running docker 18.03.0-ce with a VirtualBox 6.0.2 setup.
Solution
Thanks to @BalazsPapp who pointed this out in the comment to my question.
To use
Switching to the
To use
conn / as sysdba, I had to be logged in as the user oracle instead of root.Switching to the
oracle user and attempting to login again solved the problem.Context
StackExchange Database Administrators Q#227632, answer score: 3
Revisions (0)
No revisions yet.