Home » Infrastructure » Windows » Help Required
Help Required [message #230442] Thu, 12 April 2007 00:50 Go to next message
khushi2000
Messages: 29
Registered: April 2007
Junior Member
Hi,
I already have oracle9i database installed on windows XP machine. How can i install d2k in the same machine without removing the database?


Regards,
Khushi
Re: Help Required [message #230445 is a reply to message #230442] Thu, 12 April 2007 00:58 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,

But why you want to remove database. there is not problem if you install both software on some machine.

You can install D2k.
Also go through below link
http://www.orafaq.com/forum/t/73929/0/



Regards
Taj
Re: Help Required [message #230455 is a reply to message #230442] Thu, 12 April 2007 01:19 Go to previous messageGo to next message
khushi2000
Messages: 29
Registered: April 2007
Junior Member
The link which you have given is invalid. I tried installing d2k on my machine . Just to confirm the oracle_home should be different i guess!!! I selected a different home for d2k. It gave message " There is an existing home already. Choosing a different home would disable all the installed oracle products" . I continued with that. After installation , i was neither able to connect to database from d2k nor was able to connect to the databse directly. It gave me meassge "sp1<lang>.msb missing ". I checked in the forum where it was mentioned that D2K should be installed prior to installing database . But wondering why there should be issues if selecting a different home? Please give me a workaround.

Khushi

Re: Help Required [message #230460 is a reply to message #230455] Thu, 12 April 2007 01:30 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
I checked in the forum where it was mentioned that D2K should be installed prior to installing database

Yes, you have to first install D2k. after that you can install database.

It gave me meassge "sp1<lang>.msb missing

becuase your ORACLE_HOME is change when you install D2K after database.
for that you have to again set ORACLE_HOME env variable.


The link which you have given is invalid.

It is valid. and working for me... don't know what happen with you.


Just to confirm the oracle_home should be different i

Yes, Oracle_home is different.


But wondering why there should be issues if selecting a different home?

Don't know exactly but may be registry value is not set.


Very well explain in above mention link
Note:
If you want to install database, forms 4.5, forms, 6i, forms 9i, forms 10g on a single machine, follow this method

Install 9i/10g Database first. 
Install Forms 4.5 on a different home
Check the connectivity
Install Forms 6i on a different home
Check the connectivity
Install Forms 9i on a different home
Check the connectivity
Install Forms 10g on a different home
Check the connectivity

regards,
Saadat Ahmad 


Re: Help Required [message #230485 is a reply to message #230442] Thu, 12 April 2007 02:08 Go to previous messageGo to next message
khushi2000
Messages: 29
Registered: April 2007
Junior Member
Thanks for your reply.I have set the oracle_home variable. Then why it is not working?Is there any way out as to how we can install D2k succesfully after installing oracle database?

Khushi
Re: Help Required [message #230491 is a reply to message #230485] Thu, 12 April 2007 02:17 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
Is there any way out as to how we can install D2k succesfully after installing oracle database?

Not After you have to first install D2K after you install oracle database.


Regards
Taj
Re: Help Required [message #230506 is a reply to message #230442] Thu, 12 April 2007 02:48 Go to previous messageGo to next message
khushi2000
Messages: 29
Registered: April 2007
Junior Member
This is very frustrating!!! Oracle should sort this out!!! Anyways, thanks for your help.
Khushi
Re: Help Required--unable to connect [message #230717 is a reply to message #230442] Thu, 12 April 2007 11:27 Go to previous messageGo to next message
khushi2000
Messages: 29
Registered: April 2007
Junior Member
I have installed d2k and then installed oracle database. I can connect to oracle database using it's sql plus env. But not able to connect from D2k . It says "TNS could not resolve the service". I copied the tnsnames.ora and sqlnet.ora in database folder to D2k folder. But still it is not working!! what else can be done?Please help

khushi
Re: Help Required--unable to connect [message #231070 is a reply to message #230717] Fri, 13 April 2007 23:33 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

You have to configure both TNSNAMES.ORA file.
one is ORACLE SERVER and other one is D2K forms.
after stop listener wait few second and restart.



Regards
Taj
Re: Help Required [message #231257 is a reply to message #230442] Mon, 16 April 2007 02:36 Go to previous messageGo to next message
khushi2000
Messages: 29
Registered: April 2007
Junior Member
I have done that. But still it is not working.
Khushi
Re: Help Required [message #231268 is a reply to message #231257] Mon, 16 April 2007 02:48 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
Khushi,

You have two tnsnames.ora file correct.
you have to modify both tnsnames.ora file to connection and try to connect one of them.

after edit tnsnames.ora file you have to stop listener services and wait few minutes after restart listener services.

NOte : Your problem is because of misconfigure tnsnames.ora file.

If still not connected then delete all tnsnames.ora files and create new one for both application. ( D2K ,Database).

Regards
Taj
Re: Help Required [message #351989 is a reply to message #230442] Sat, 04 October 2008 12:06 Go to previous messageGo to next message
shrad2001
Messages: 20
Registered: September 2008
Location: faridabad
Junior Member
hi khushi

u installed database,now u have to installed d2k easily if error displayed is no home or any other u have to change name ora92 to any other like ora921 at time of installation

now if at time of connectivity eror displayed then replace tns.ora file of d2k with tns.ora file of oracle dtabase


ok hope its work

smily
Re: Help Required [message #351993 is a reply to message #351989] Sat, 04 October 2008 12:48 Go to previous message
Michel Cadot
Messages: 57613
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Read forum guide and don't use IM speak.
Khushi is no more there since 1.5 year.

Regards
Michel
Previous Topic: ODBC not reading TNS_ADMIN
Next Topic: Installation Of Oracle8i
Goto Forum:
  


Current Time: Sun Apr 20 12:14:37 CDT 2014

Total time taken to generate the page: 0.10521 seconds