How to connect to the human_resources schemas in 12c?

Unknown

This is what i have in tnsnames.ora

For the THIRD TIME

Yes - you need to have an entry in your TNSNAMES.ORA file for SERVICE_NAME = PDBORCL to connect.

Do you seen anything in there like that? I don't.

9a8s7d6f5g4h3j2k1l

Sorry, i know this is anoying for you, but u dont give exact instructions.

What should i have in that file, dont give me a clue how to do it, so i asked, do i need to edit that file, delete SERVICE_NAME = orcl and write SERVICE_NAME = pdborcl ?

sb92075

Do you realize  that Oracle provides a great free collection of books called documentation manuals.

You really should try Reading The Fine Manuals to answer your questions.

see URL below

Oracle Database Online Documentation 12c Release 1 (12.1)

9a8s7d6f5g4h3j2k1l

Like this one? -> Connecting to Oracle Database and Exploring It
So easy, but wait a min, noot working

Unknown

What should i have in that file, dont give me a clue how to do it, so i asked, do i need to edit that file, delete SERVICE_NAME = orcl and write SERVICE_NAME = pdborcl ?

Sure - go ahead and change 'orcl' to 'pdborcl'. Then you will be able to connect to PDBORCL but won't be able to connect to ORCL.

9a8s7d6f5g4h3j2k1l

Ok, i get it, i'm stupid. Hope Richard will help again.

I altered user HR, just need to know how to connect in sqlplus and Developer.

Unknown

You already know how to connect using both of those.

In sql*plus you use the entry in TNSNAMES.ORA and in sql developer you enter the information I mentioned earlier.

9a8s7d6f5g4h3j2k1l

Dude, u really dont know to explain the noobs like me.
"Yes - you need to have an entry in your TNSNAMES.ORA file for SERVICE_NAME = PDBORCL to connect."

HOW?

"and in sql developer you enter the information I mentioned earlier"

http://s2.postimg.org/ldi87oog9/image.jpg

"

sb92075

is  COPY & PASTE  broken for you?

9a8s7d6f5g4h3j2k1l

# tnsnames.ora Network Configuration File: F:\app\product\12.1.0\dbhome_1\network\admin\tnsnames.ora

# Generated by Oracle configuration tools.

ORACLR_CONNECTION_DATA =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

    )

    (CONNECT_DATA =

      (SID = CLRExtProc)

      (PRESENTATION = RO)

    )

  )

ORCL =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = Izzy)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = orcl)

    )

  )

PDBORCL =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = Izzy)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = pdborcl)

    )

  )

_______________________________

Is this good?