0

I'm new to database and Oracle, but I need to learn it.

I just following this tutorial to install Oracle 12c, I almost on at the end of the steps.

I have finishing install the database with GUI interface, and now I want to start the database that I have installed with this following command:

sqlplus /nolog

and yea, I have entered to the database, and then I run this following command to connect as sys: connect sys as sysdba

But it prompt Enter password:

Unfortunately, I don't know what is the default password for that.

I have try the password with CHANGE_ON_ INSTALL base on this following documentation, but it seems not work actually.

enter image description here

So, what is the default password..?, or any way to bypass that password and then change it if I forgot..?

EDIT: I following @Tejash----ORA-00980 instructions to use this command to directly log into DB as a sysdba:

sqlplus / as sysdba

And the result is like this: enter image description here What username should I use..?, I have try it with sys and sysdba but it still prompt a Enter password:

EDIT 2: Here is my sqlnet.ora and tnsnames.ora files enter image description here and here is my $ORACLE_SID and $ORACLE_HOME values. enter image description here

  • 2
    You get an ORA-12547, so I assume the problem is not caused by wrong password. In Oracle 12 there is no default password, you (or whoever created the database) has to provide the initial password when the database is created. – Wernfried Domscheit Jun 24 at 6:09
  • Hi Man @WernfriedDomscheit, I have edited my questions, can you help me with that please..? – Harvest 1018 Jun 24 at 14:08
  • No, it prompts you for a new username, i.e. sqlplus asks for a new connection to a new database. – Wernfried Domscheit Jun 24 at 14:18
1

If you are on the same system where Oracle database is installed and you have logged in to the system using a correct privileged user then you can bypass the password.

Please note that the path of the ORACLE_HOME and ORACLE_SID is properly configured. Also, TNSLISTNER and SQLNET files are properly configured.

You can directly log into DB as a sysdba using the following command:

sqlplus / as sysdba

enter image description here

  • Hi, I have try to following your intructions, and I post the result on my edited questions, please check it out :) – Harvest 1018 Jun 24 at 10:48
  • 1
    Can you please post your SQLNET.ora and TNSNAMES.ora files? Also, Please share the values of ORACLE_HOME and ORACLE_SID? – Tejash Jun 24 at 11:26
  • I have made new EDIT 2, please check it out :) – Harvest 1018 Jun 24 at 14:04
  • 1
    Are you sure $ORACLE_SID is correct? – Tejash Jun 24 at 14:20
  • 1
    I think recreate your password file will help docs.oracle.com/cd/B28359_01/server.111/b28310/dba007.htm Just have in mind if it is a production box, backup it up before to recreate it. – dbamex Jun 25 at 16:38

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.