Search code examples
oracle-databasedatabase-connectionoracle-sqldeveloperioerror

make a new connection with Oracle sql developer


I know this question has been asked frequently. However, none of the answers from them worked for me. So, I am posting the question. I tried to make a new connection in sql developer using my Oracle account's username and password that I used while trying to download the oracle software. However, it gives me an IO Error whenever I use those details. I tried options like "system" in username and the password of Oracle account. However, it still is not working.

help would be appreciated.

It gives me this message every time I try to log in.


Solution

  • Are you really trying to connect to a local database with your oracle ´s website account?

    You need to get a valid username/password from the guy who has installed the database on your local computer

    If it is you, then you provided a password for the « system » user during install

    Edit :

    How did I miss it! Your current issue is not about an invalid login/password if it was you would get an « invalid username » message.

    The message you get is « could not establish connection ». This message means the database « orcl » is not accessible on localhost:1521.

    You must:

    • create the database orcl, if not already done

    • configure a listener to make the database accessible

    See https://docs.oracle.com/cd/E11882_01/server.112/e10897/network.htm#ADMQS0411