OraFAQ Forum: Windows » Help Required

Home » Infrastructure » Windows » Help Required

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Help Required [message #230442]

Thu, 12 April 2007 00:50

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

Report message to a moderator

Re: Help Required [message #230445 is a reply to message #230442]

Thu, 12 April 2007 00:58

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

Report message to a moderator

Re: Help Required [message #230455 is a reply to message #230442]

Thu, 12 April 2007 01:19

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

Report message to a moderator

Re: Help Required [message #230460 is a reply to message #230455]

Thu, 12 April 2007 01:30

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Code: [Select all] [Show/ hide]

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

Report message to a moderator

Re: Help Required [message #230485 is a reply to message #230442]

Thu, 12 April 2007 02:08

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

Report message to a moderator

Re: Help Required [message #230491 is a reply to message #230485]

Thu, 12 April 2007 02:17

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

Report message to a moderator

Re: Help Required [message #230506 is a reply to message #230442]

Thu, 12 April 2007 02:48

khushi2000
Messages: 29
Registered: April 2007

Junior Member

This is very frustrating!!! Oracle should sort this out!!! Anyways, thanks for your help.
Khushi

Report message to a moderator

Re: Help Required--unable to connect [message #230717 is a reply to message #230442]

Thu, 12 April 2007 11:27

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

Report message to a moderator

Re: Help Required--unable to connect [message #231070 is a reply to message #230717]

Fri, 13 April 2007 23:33

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

Report message to a moderator

Re: Help Required [message #231257 is a reply to message #230442]

Mon, 16 April 2007 02:36

khushi2000
Messages: 29
Registered: April 2007

Junior Member

I have done that. But still it is not working.
Khushi

Report message to a moderator

Re: Help Required [message #231268 is a reply to message #231257]

Mon, 16 April 2007 02:48

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

Report message to a moderator

Re: Help Required [message #351989 is a reply to message #230442]

Sat, 04 October 2008 12:06

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

Report message to a moderator

Re: Help Required [message #351993 is a reply to message #351989]

Sat, 04 October 2008 12:48

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Read forum guide and don't use IM speak.
Khushi is no more there since 1.5 year.

Regards
Michel

Report message to a moderator

Previous Topic:	ODBC not reading TNS_ADMIN
Next Topic:	Installation Of Oracle8i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 01 19:15:20 CDT 2025