OraFAQ Forum: SQL & PL/SQL » Whether Windows XP Prof. accepts Oracle 9i Enterprise

Home » SQL & PL/SQL » SQL & PL/SQL » Whether Windows XP Prof. accepts Oracle 9i Enterprise

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

Whether Windows XP Prof. accepts Oracle 9i Enterprise [message #7181]

Tue, 27 May 2003 00:16

sachin kumar gupta
Messages: 157
Registered: March 2003

Senior Member

Hello all,

I am installing Oracle 9i Enterprise Edition on Windows XP Professional. Although in documentation it is specifically mentioned that this Oracle 9i can be installed in Windows NT only.

Also after installation, oradata direstory is created.
Global database name I mentioned as "db.localhost" & SID as "db". As I will be using the Oracle for only single desktop, I opted for Personal Oracle 9i with self database starter.

It also automatically created initdw.ora file.

But after this, it is giving TNS error. I am unable to configure my listner. I don't have any idea whether listner is to be configured or not. As far as I know I shall configure listner if I am client, but I will use Oracle for single desktop.
Plz. anyone help me where I m wrong.

Thanx in Adv.
Sachin Kr. Gupta

Report message to a moderator

Re: Whether Windows XP Prof. accepts Oracle 9i Enterprise [message #7182 is a reply to message #7181]

Tue, 27 May 2003 00:36

Maaher
Messages: 7065
Registered: December 2001

Senior Member

What TNS error are you getting?
Can you do a TNSPing to the DB?
What happens if you connect without using a connect string (to the default database)?
Is the listener up?

I've installed succesfully Personal Oracle 9i on my XP Home Edition. I've had problems with my listener once but it turned out that my firewall was blocking the listener.

MHE

Report message to a moderator

Re: Whether Windows XP Prof. accepts Oracle 9i Enterprise [message #7183 is a reply to message #7182]

Tue, 27 May 2003 01:11

Sachin
Messages: 52
Registered: May 2001

Member

I m getting ORA-12560 TNS Protocol Adapter Error.
Also I have installed the Personal Edition from Oracle 9i Enterprise Edition.
I don't have anyidea abt. listner. Kidly letme know how to configure listner for Single desktop. I was coonfiguring for IPC protocol.

Thanx & regards,
Sachin

Report message to a moderator

Re: Whether Windows XP Prof. accepts Oracle 9i Enterprise [message #7185 is a reply to message #7183]

Tue, 27 May 2003 05:40

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Well, I don't know IPC but for TCP/IP, your TNSNAMES.ORA should look like:

your_connection_name.world =
  (DESCRIPTION =
    (ADDRESS_LIST =
        (ADDRESS =
          (PROTOCOL = TCP)
          (Host = your_host)
          (Port = 1521)
        )
    )
    (CONNECT_DATA = (SID = your_database_sid)
    )
  )

Try starting the listener through LSNRCTL.EXE via a Dos box:

C:> lsnrctl start

If it gives errors it would be useful to post them here.

HTH,
MHE

Report message to a moderator

Re: Whether Windows XP Prof. accepts Oracle 9i Enterprise [message #7188 is a reply to message #7185]

Tue, 27 May 2003 06:56

sachin kumar gupta
Messages: 157
Registered: March 2003

Senior Member

Thanx!! I will try

Sachin

Report message to a moderator

Previous Topic:	easy problem
Next Topic:	Max Index on a table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 08:42:49 CDT 2024