How to find the default database name

Question

3.00/5 (2 votes)

See more:

How to find(query) the default database name in Oracle Database 10g Express Edition - SQL prompt.

I tried 'XE' as database name to connect Oracle Report, but it not working.

Guide me to create new database in Oracle 10g Express Edition, & steps to connect that database with Oracle Report 10g.

Posted 3-Sep-12 18:56pm

santhya123

Updated 3-Sep-12 20:37pm

v3

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandeep Mewara · Answer 1 · 2012-09-03T19:40:00

Solution 1

Try if this works:

SQL

SELECT ora_database_name FROM dual;

Posted 3-Sep-12 19:40pm

Sandeep Mewara

Comments

santhya123 4-Sep-12 2:03am

I getting the database name as 'XE', while enter the username/password & database name(XE) in Oracle Report to connect, it was not connecting.

Throwing the Error message - 'Unable to connect the specific database'

Sandeep Mewara 4-Sep-12 2:13am

Error message suggests some issue with tour connection string (probably credentials) or server not accessible due to firewall or so.

santhya123 4-Sep-12 2:31am

Thanks for the help.

To connect with Oracle Report, whether network connection is needed?
Guide me to connect with Oracle Report 10g.