Home » Developer & Programmer » Reports & Discoverer » Connect Oracle Report Builder 9.0.4.0.33 with Oracle 9i database (Report Builder,9.0.4.0.33)
Connect Oracle Report Builder 9.0.4.0.33 with Oracle 9i database [message #417540] Mon, 10 August 2009 02:34 Go to next message
gozuhair
Messages: 206
Registered: January 2008
Senior Member
Dear All

Could you please tell me that how can i connect Report Builder 9.0.4.0.33 with Oracle 9.2.0.1.0 database.

Thanks in advance


Regards

Zuhair
Re: Connect Oracle Report Builder 9.0.4.0.33 with Oracle 9i database [message #417649 is a reply to message #417540] Mon, 10 August 2009 15:50 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'd try with specifying username, password and database alias.

What is the problem, exactly?
Re: Connect Oracle Report Builder 9.0.4.0.33 with Oracle 9i database [message #417673 is a reply to message #417540] Mon, 10 August 2009 22:57 Go to previous messageGo to next message
gozuhair
Messages: 206
Registered: January 2008
Senior Member
I have received the following message when i connect report builder with oracle database.

scott/tiger@z

REP-0501:Unable to connect to the specified database ORA-12154:TNS could not resolve service name.

I have written the following text in tnsnames.ora file.

# TNSNAMES.ORA Network Configuration File: E:\ora_10g\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

z =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = zkhan-dfml)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = dba)
    )
  )


One more thing that i need to mention,I have also installed Oracle Report 6i and its connecting well.I have installed Oracle database in my own computer.

Regards


Zuhair
Re: Connect Oracle Report Builder 9.0.4.0.33 with Oracle 9i database [message #417720 is a reply to message #417673] Tue, 11 August 2009 04:49 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'd suggest you to search for use of the TNS_ADMIN environment variable. I've described it recently in the Forms forum.
Re: Connect Oracle Report Builder 9.0.4.0.33 with Oracle 9i database [message #417749 is a reply to message #417540] Tue, 11 August 2009 06:39 Go to previous messageGo to next message
gozuhair
Messages: 206
Registered: January 2008
Senior Member
As per your instruction, I have created a tns_admin environment variable by using the following method.

goto the registry and then
regedit>hkey_local_machine>software>oracle>all_homes>home1>


Actually home1 is refer to my oracle 9i database and under this home(home1)I have created a string value and name it tns_admin and give the below values to it.
E:\ora_10g\network\admin\tnsnames.ora
and then restart my computer but still facing the same error.

Kindly advise.





Re: Connect Oracle Report Builder 9.0.4.0.33 with Oracle 9i database [message #417791 is a reply to message #417749] Tue, 11 August 2009 09:47 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Did you study this thread?
Re: Connect Oracle Report Builder 9.0.4.0.33 with Oracle 9i database [message #418151 is a reply to message #417540] Thu, 13 August 2009 03:40 Go to previous messageGo to next message
gozuhair
Messages: 206
Registered: January 2008
Senior Member
As per your provided rhread ,I have done the following activities.

-delete the tns_admin string value that i created earlier from the registry.
-create folder in c drive and name as C:\0_library
-copy tnsname.ora file from Developer suite 10g folder and paste it into newly created folder.(C:\0_library)
-goto c:\temp and issue the following command like this
C:\0_library

-check the tns_admin value status like this
C:\Temp>set tns_admin
tns_admin=set tns_admin=c:\C:\0_library

-rename rest of the tnsnames.ora file(included Reports 6i and Report 9.0.4.33) other than Oracle database 9i tnsnames.ora file.

Now I am still unable t connect Report Builder 9.0.4.0.33 even my report builder 6i also not connecting due to the rename of tnsnames.ora file.

Kindly advice

Zuhair




[Updated on: Thu, 13 August 2009 04:14]

Report message to a moderator

Re: Connect Oracle Report Builder 9.0.4.0.33 with Oracle 9i database [message #418425 is a reply to message #417540] Sat, 15 August 2009 00:40 Go to previous messageGo to next message
gozuhair
Messages: 206
Registered: January 2008
Senior Member
Dear All

I have renamed all my tnsnames.ora file and finally my report builder 6i is working well by using tns_admin environment variable but Developer suite 10G (Report Builder) is still facing the same problem.

Regards


Zuhair
Re: Connect Oracle Report Builder 9.0.4.0.33 with Oracle 9i database [message #419353 is a reply to message #418425] Fri, 21 August 2009 07:37 Go to previous messageGo to next message
gauravdua
Messages: 9
Registered: January 2008
Junior Member
Hi,
Just Try this. i was also facing this problem earlier then i have added two Enviroment Variable(my computer properties- > Advanced and Eniromnet Variable).
Add in User variable below two variable and value
Vaiable and Value as
1. ORACLE_HOME and Path of Developer siute 10G (I think E:\ora_10g in yours case)
2. FND_SECURE and Path for secure folder
Create secure folder in yours home (E:\ora_10g) and place .dbc file of yours instance in that folder .Now path for secure folder will be E:\ora_10g\secure.

.dbc for the instance, you can download from au_top

I hope this will help...and please let me know ...

Regards
Gaurav Dua

[Updated on: Fri, 21 August 2009 07:39]

Report message to a moderator

Re: Connect Oracle Report Builder 9.0.4.0.33 with Oracle 9i database [message #419415 is a reply to message #417540] Fri, 21 August 2009 23:41 Go to previous messageGo to next message
gozuhair
Messages: 206
Registered: January 2008
Senior Member
Thanks for the reply,could you please tell me the path of .dbc file,I also dont know what do you mean by au_top.
I have tried to search .dbc files into my Oracle database 9i and get the following .dbc files.

datawarehouse.dbc,General_Purpose.dbc,Transaction_processing.dbc


All the above files are located in the following path of my Oracle 9i database.
e:\oracle\assistants\dbca\templates


Regards

zuhair




[Updated on: Fri, 21 August 2009 23:47]

Report message to a moderator

Re: Connect Oracle Report Builder 9.0.4.0.33 with Oracle 9i database [message #419537 is a reply to message #419415] Mon, 24 August 2009 02:15 Go to previous messageGo to next message
gauravdua
Messages: 9
Registered: January 2008
Junior Member
Hi,
We required .dbc file for instance these dbc will not help us to connect.
You can also get .dbc for yours instance from FND_TOP through telnet and FTP.Following steps can help you to know th path for the file and how to download file from server to yours local harddrive
Connect to yours server from telnet (Start- > Run -> Telnet <ip address of yours server>).login in with yours username and pwd Now type following commands
1. pwd ( It will tell path for yours home)
2. cd $APPL_TOP (It will take you to APPL_TOP)
3. cd fnd
4. pwd (you can directly go into this path by cd $FND_TOP)
4. CD secure
5. pwd ( this is required path for dbc file)
copy this path and get .dbc for yours instance from yours server to local harddisk (Say c:/)through FTP
FTP steps
1. FTP <Hostname or IP adress> (Start -> Run )
2. login
3. cd <fnd_top>(which you have copied)
4. lcd c:/
5. get <filename>.dbc
Now you have .dbc

I hope this will help you...

Regards
Gaurav Dua
Re: Connect Oracle Report Builder 9.0.4.0.33 with Oracle 9i database [message #419550 is a reply to message #417540] Mon, 24 August 2009 03:57 Go to previous messageGo to next message
gozuhair
Messages: 206
Registered: January 2008
Senior Member
My bad luck,when i try to input telnet 172.16.2.75 then one black screen is appear and show the dialog 'connecting to 175.16.2.75' and then screen will disappear within 5 seconds.

175.16.2.75 is my ip address because i have installed database in my local computer.


Re: Connect Oracle Report Builder 9.0.4.0.33 with Oracle 9i database [message #419564 is a reply to message #419550] Mon, 24 August 2009 05:01 Go to previous messageGo to next message
gauravdua
Messages: 9
Registered: January 2008
Junior Member
You are right,doing telnet to local machine never works it will disappear.Earlier i thought you have installed database on other machine.

Tell me one thing how many home are there in yours machine?
Or
Put tns entry in all the home.

Just try to connect.

In yours 'Oracle 9i database' home (e:\oracle) search for "fnd" folder.i hope secure folder should be there in fnd folder

Regards
Gaurav Dua
Re: Connect Oracle Report Builder 9.0.4.0.33 with Oracle 9i database [message #419674 is a reply to message #417540] Tue, 25 August 2009 00:40 Go to previous messageGo to next message
gozuhair
Messages: 206
Registered: January 2008
Senior Member
Dear Gauravdua

Thanks for the reply,I have got three home .the details are:
home 0 for Oracle Forms and Report 6i and its location is c:\orant
home 1 for Oracle 9i database and its location is e:\oracle
home 2 for Developer suite 10g and its location is e:\ora_10g

As per your advised, i have tried to seek fnd folder in e:\oracle that contain my oracle 9i database but fnd folder is not exist but find two folder similar to fnd folder and their names and locations are.
folder name oafnd and location is e:\oracle\doc\EM\webhelp.
folder name vpxoafndus and location is e:\oracle\network\mesg.
One more thing i have already put tns entry in all homes but unable to connect.

Regards

Zuhair




Re: Connect Oracle Report Builder 9.0.4.0.33 with Oracle 9i database [message #419898 is a reply to message #419674] Wed, 26 August 2009 02:08 Go to previous message
gauravdua
Messages: 9
Registered: January 2008
Junior Member
Hi Zuhair,

Apologies for replying late ....
Just try aftre setting environment variable as

ORACLE_HOME and Path of Developer siute 10G (i.e E:\ora_10g\BIToolsHome)

Regards
Gaurav Dua
Previous Topic: Disable Number Of Copies Option
Next Topic: how to return two values from a function call
Goto Forum:
  


Current Time: Sun Dec 04 22:32:42 CST 2016

Total time taken to generate the page: 0.11647 seconds