oracle-11g-r2
I am trying to connect to SQL developer as sys account. It is always giving the error invalid username/password. When I try to connect it through SQLPLUS, it gets connect with any wrong password also.
How can I connect to SQL Developer using sys account?
There are different ways to connect oracle. One of them is easy connect .
You may use
sqlplus username/password@server/SID
According to comments. You can connect oracle using easy connect but hr (human resources) account does not exists. Therefore try to use
sqlplus username/password@10.66.1.61:1521/OPTPROD
You should be able to connect your oracle system.
Try to connect with
sqlplus SYS/PASSWORD@ORCL
If you can connect with this from command line you can connect with Sql Developer.
You have two options
Connection Type : Basic
See Image
Connection Type : TNS
The catch here. Oracle Connection string for OCI expect same argument in your tnsnames.ora file. If you use basic connection you should be able to connect from everywhere without modification. But if you need to connect with other connection types, you may need to enter your IP address in your tnsnames.ora file.
Best Answer
sqlplus user/password as sysdbauses OS authentication by default, and bypasses the username and password check, so as you said, you can provide any password or username.Logging in from SQL Developer requires a remote session. For a remote SYSDBA connection, you need the following:
remote_login_passwordfiletoEXCLUSIVEorSHARED, but notNONE$ orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SIDAfter this you should be able to log in with SYS and the password you provided.