Discussions
Categories
- 385.1K All Categories
- 2.6K Data
- 605 Big Data Appliance
- 2K Data Science
- 452.2K Databases
- 222.4K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 32 Multilingual Engine
- 576 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 575 SQLcl
- 4K SQL Developer Data Modeler
- 187.8K SQL & PL/SQL
- 21.5K SQL Developer
- 12 Data Integration
- 12 GoldenGate
- 297.7K Development
- 3 Application Development
- 18 Developer Projects
- 140 Programming Languages
- 294.4K Development Tools
- 118 DevOps
- 3.1K QA/Testing
- 646.5K Java
- 30 Java Learning Subscription
- 37K Database Connectivity
- 185 Java Community Process
- 107 Java 25
- 22.2K Java APIs
- 138.3K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 22 Java Essentials
- 174 Java 8 Questions
- 86K Java Programming
- 82 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
- 206 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 587 LiveLabs
- 41 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.6K JHeadstart
- 5.8K Other Languages
- 2.3K Chinese
- 197 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 240 Portuguese
I have tried making new connection in SQL developer even after downloading the Oracle 21c database.
But I am unable to make connection as there is a option that asks "Load a TNS file". After that again I tried searching the TNS file That I was unable to find. Also I tried making a new connection with basic connection type but it failed to connect.
Answers
-
You don't need a TNS file, you can simply make a 'basic' connection.
When you say that failed, can you give details? Like, what is the error message?
And, this site supports screenshots. Take one of your connection properties and show us what you're doing.
Otherwise, you're asking us to guess.
-
my error is still the same... since none of my friend know or work on this that's why I have to ask directly and I am trying to learn this too. That's why I am adamant in questioning again and again... even after downloading oracle xe 21c the error is still the same.
-
IF you have installed XE, the the SID will not be ORCL. I think the installation creates a plugable database called XEPDB
-
the outcome is still the same. plz suggest another way.
-
I found these files here but while searching I didn't find the option to load it.( It was missing the product file while searching.)
-
It's a preference. You don't need this to connect, but it can make things easier.
-
here is this product file but I m unable to access it as I also shared the ss in previous message... I can't see the product folder in pavilion and same happened after following the preference path.(I tried the preference part earlier but I tried it again but same condition.)
in this ss I see JDBC driver test failed. plz tell. I tested the oracle client.
-
Here is an error, the name of the PDB is XEPDB1. Try one more time with this PDBname and enter it in the "Service Name" field, not the SID.
-
Yes I did as I just started a oracle sql tutorial. but I installed the sql developer first then oracle 21c xe. plz help fast. my whole day just go into waiting and trying for new ideas to run this oracle sql dev.
-
The location of your oracle client should be something like c:/users/pavilion/Oracle, without the network admin directory.
As you can see from the test log, it is looking for ./jdbc/lib within the oracle client directory.
Although probably isn't related to your main problem.
