Discussions
Categories
- 197.1K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.7K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 555 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.3K SQL Developer
- 296.3K Development
- 17 Developer Projects
- 139 Programming Languages
- 293K Development Tools
- 110 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 158 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 466 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
How to connect to the human_resources schemas in 12c?
Answers
-
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.
-
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 ?
-
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
-
Like this one? -> Connecting to Oracle Database and Exploring It
So easy, but wait a min, noot working -
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.
-
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.
-
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.
-
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
"
-
is COPY & PASTE broken for you?
-
# 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?