|
|
|
|
| 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   |
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 #417749 is a reply to message #417540] |
Tue, 11 August 2009 06:39 |
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
Kindly advise.
|
|
|
|
|
|
| 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 |
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
-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 #419353 is a reply to message #418425] |
Fri, 21 August 2009 07:37 |
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 |
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 |
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 #419564 is a reply to message #419550] |
Mon, 24 August 2009 05:01 |
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 |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
