Discussions
Categories
- 196.8K All Categories
- 2.2K Data
- 235 Big Data Appliance
- 1.9K Data Science
- 449.9K Databases
- 221.6K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 549 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 532 SQLcl
- 4K SQL Developer Data Modeler
- 186.9K SQL & PL/SQL
- 21.3K SQL Developer
- 295.4K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.1K Development Tools
- 104 DevOps
- 3.1K QA/Testing
- 645.9K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 154 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 158 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 203 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 401 LiveLabs
- 37 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.6K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 230 Portuguese
How to connect to Oracle sql developer XE
Respected Sir/Mam ,
I am Venkatesh Nishtala working in a private organization at Chennai ,India.
I have installed Oracle Sql Developer XE in my personal laptop few days ago. While installing it did not ask any username or password to be entered.
At the time of connecting to DB it is asking the User Name and Password and other credentials like Host Name, port and service Name.
Can anybody assist me what to give regarding these.
I have installed regarding my practice purpose.
Please let me know the credentials or what is the alternative way to get connected .
Your early response is highly appreciated.
Thanks in Advance,
Venkatesh
Answers
-
There is no Oracle SQL Developer XE.
There is an oracle database edition, called XE (eXpress Edition) that is free to use, and there is also a tool called Oracle SQL Developer that allows you to connect to any Oracle database (XE, EE, SE).
In order to connect to a database using SQL Developer, you need to know (at least to connect in a simple way) 5 things
- Server name or IP where the database is running
- Port where the Listener is listening
- Name of the Service
- Username
- Password
If you want yo connect to an existing Database in your organization, someone must provide you this data. If you want to use a local XE database you must have installed it previously, and you should know those 5 pieces of information. The server should be your computer, listener usually runs on port 1521.
Please make us know exactly what have you installed, I deduct from you message that you just installed SQL Developer but no database,
