Home » Infrastructure » Windows » intalled oracle 9i (windowsw xp sp2)
intalled oracle 9i [message #346898] Wed, 10 September 2008 01:04 Go to next message
ab_trivedi
Messages: 456
Registered: August 2006
Location: Pune, India
Senior Member
All,

I have installed Oracle version 9i yesterday on e: drive, it is working fine and my SID is seclbsp. The tnsnames.ora is at E:\oracel\..\admin.

Now I want to install Developer 2000 rel 2.1 so what STEPS i have to take so that TNSNAMES.ORA problem should not come.

I will install Developer on C: drive? Is it ok?

Ashu
Re: intalled oracle 9i [message #346905 is a reply to message #346898] Wed, 10 September 2008 01:16 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10626
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You can install Developer 2000 where ever you want.
Every client will have its own version of tnsnanmes.ora.
Alternatively, you can just use aliases for the same file
or
just set TNS_ADMIN and use it.
Re: intalled oracle 9i [message #346908 is a reply to message #346905] Wed, 10 September 2008 01:22 Go to previous messageGo to next message
ab_trivedi
Messages: 456
Registered: August 2006
Location: Pune, India
Senior Member
thx for you it is easy but can you explain what is

Quote:
Alternatively, you can just use aliases for the same file


and

Quote:
just set TNS_ADMIN and use it.


Re: intalled oracle 9i [message #346912 is a reply to message #346908] Wed, 10 September 2008 01:31 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10626
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>thx for you it is easy
It is easy for all. It is no voodoo stuff Smile.
Just search this forum/google/docs.

TNS_ADMIN is the environment variable which will identify the tnsnames.ora, wherever it is.
Alias is just a "shortcut" to tnsnames.ora in another directory.
I believe it is the right term. It is called as soft link/symbolic link in Unix and "alias" in MAC.
Re: intalled oracle 9i [message #346915 is a reply to message #346908] Wed, 10 September 2008 01:37 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10626
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
And in most cases, if you are just using your local client against
your local database, you do not need tnsnames entries at all (ORACLE_SID will identify the instance).
Or atleast it used to be like that. It is been ages since I used Developer 2000.

[Updated on: Wed, 10 September 2008 01:42]

Report message to a moderator

Re: intalled oracle 9i [message #347328 is a reply to message #346915] Thu, 11 September 2008 05:30 Go to previous messageGo to next message
ab_trivedi
Messages: 456
Registered: August 2006
Location: Pune, India
Senior Member
As you know that I have already installed Oracle 9i on E:. now when I am installing Developer 2000 the forllowing message is coming .
HOME CHANGE INFORMATION

Quote:
The Oracle installed has detected that already have an existing Oracle home at E:\Oracle\ora90. selecting a different location will disable your currently installed oracle products. Choose back to select existing location ...


Now if I will change the Orcale path then Oracle will not start OR changing the path the message is coming as

Quote:
the location specified, E:\Oracle\Ora90", is already used as Oracle home for 'Oracle 82 Beta'
It cannot be used as an Orcale home for 'nt'



Pls guide OR id any document is available to install Oracle and then D2K .

Ash
Re: intalled oracle 9i [message #347338 is a reply to message #347328] Thu, 11 September 2008 05:43 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10626
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Every Oracle installation will need is own "directory".
For example
C:\oracle\ora92
C:\oracle\d2k

Just install d2k where ever you want.
Find the docs here
http://www.oracle.com/technology/documentation/forms.html

BTW, working on outdated versions is just a waste of time.
Re: intalled oracle 9i [message #347348 is a reply to message #347338] Thu, 11 September 2008 06:06 Go to previous messageGo to next message
ab_trivedi
Messages: 456
Registered: August 2006
Location: Pune, India
Senior Member
advice is nice, but I am not working in oracle platform, just to rebrush my previous knowledge, that is why installing Oracle and D2K.
I will try and ask you again if the problem persists.
Ashu
Re: intalled oracle 9i [message #347367 is a reply to message #347348] Thu, 11 September 2008 06:55 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10626
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>advice is nice, but I am not working in oracle platform,
Still,
There is no point in brushing your skills in an outdated "Platform".

Re: intalled oracle 9i [message #347906 is a reply to message #347367] Mon, 15 September 2008 00:45 Go to previous message
ab_trivedi
Messages: 456
Registered: August 2006
Location: Pune, India
Senior Member
good news is that i have instaled iDS suite.
Ashu
Previous Topic: Delete archive logs automatically using script in windows
Next Topic: Got error message while installing Oracle 9i in Win2k3
Goto Forum:
  


Current Time: Sun Sep 21 03:35:25 CDT 2014

Total time taken to generate the page: 0.04705 seconds