0

I've installed Oracle 12c, and I'm trying to create a connexion using SQL Developer but I've got errors.

Here is the parameters after installation and users parameters:

enter image description here

Like in the photo, the port is 5500 but in tnsnames.ora I have this:

ORCL =
(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

  PDBORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = pdborcl)
    )
  )

The port in here is 1521, so I'm confused which parameters use to create a connexion. It's my first installation of oracle.

enter image description here

I've changed the port to 1521. Now I've got this error:

ORA-01017:invalid username/password; logon denied

I changed username to "system". It works on SQL Developer, but on the browser I don't know how to access.

closed as off-topic by Balazs Papp, mustaccio, Marco, Colin 't Hart, RLF Mar 13 '17 at 19:16

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience. Consider revising your question so that it appeals to a broader audience. As it stands, the question is unlikely to help other users (regarding typo questions, see this meta question for background)." – Balazs Papp, mustaccio, Marco, Colin 't Hart, RLF
If this question can be reworded to fit the rules in the help center, please edit the question.

  • 3
    5500 is the port used by Databas Express, you can access that in a broswer by using the URL on the screenshot. To connect the database, use the listener port (1521). – Balazs Papp Mar 11 '17 at 19:06
1

You can use the following link to access Database Express through the browser:

https://yourhostname:5500/em

Or

https://youripaddress:5500/em

  • nothing, i'll continue with sql developer, thank you – devhicham Mar 11 '17 at 19:55
0

You Oracle 12c Express em will be https://localhost:5500/em

You can login in the Browser in this way :-

User Name # SYS
Password # SYS User Password
Connect AS # SYSDBA (not NORMAL)

I am also attaching the screen shot or Oracle 12c em Express. enter image description here

Note :- For Port number will be same in SQL Developer as you have in tnsnames.ora file . In your case it would be 1521. As already Mr. Balazs Papp told you through comments.

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