Error on report Builder (Unable to Connect to the specifed Database, ORA-12541: TNS: no listener)


Unable to Connect to the specifed Database
ORA-12541: TNS: no listener

1

You may get this problem due to the TNS listener not entered or a wrong user name, password, database or Incorrect Database name

For TNS names Entry
Get the TNS entry in the tnsnames file.

Go to the location C:\DevSuiteHome_1\NETWORK\ADMIN\tnsnames.ora (check your location where DevSuiteHome is installed)

If there is not a file named tnsnames.ora create a file and that should be inside DevSuiteHome.

This DevSuiteHome that where your Oracle k2k gets installed .

You can refer to the sample file(tnsnames.ora ) in sample folder for reference.

Below is the format where

TEST → Database

Hostname → Hostname has to be given(IP address or Host address)

1523 → Port number

TEST → SID

 

TEST=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=Hostname)
(PORT=1523)
)
(CONNECT_DATA=
(SID=TEST)
)
)

 

About pacesettergraam

A good and realistic person

Posted on February 16, 2014, in Oracle and tagged , . Bookmark the permalink. Leave a comment.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: