Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Oracle for Windows XP with INTEL inside

Re: Oracle for Windows XP with INTEL inside

From: <Graeme.Farmer_at_mincom.com>
Date: Mon, 20 Sep 2004 16:15:17 +1000
Message-ID: <OF7414F5DA.5757038B-ON4A256F15.0021F9BF-4A256F15.00225C1C@mincom.com>


Are you connecting to the host machine via RDP (MS Terminal Services Client)?
If so, you cannot connect via the method you described (unless you are on MS Server 2003 and you specify connection to the CONSOLE when initiating your RDP session).

Also, you cannot connect "system as sysdba" (unless you specifically grant the SYSDBA privilege to SYSTEM which is not standard practice). You should connect "SYS AS SYSDBA".

If you DO connect over RDP on <Win2003 then to connect as SYSDBA you will need to start the listener, configure remote_login_passwordfile=exclusive in the (s)pfile and connect "SYS@<SID> AS SYSDBA".

Good luck.

Graeme

"Sinardy Xing" <SinardyXing_at_bkgcomsvc.com> Sent by: oracle-l-bounce_at_freelists.org
20/09/2004 02:08 PM
Please respond to
SinardyXing_at_bkgcomsvc.com

To
<oracle-l_at_freelists.org>
cc

Subject
Oracle for Windows XP with INTEL inside

Hi guys,
Is that true that you cannot connect to Oracle 9.2.0 on Intel + XP machine "WITHOUT A LISTENER?" I got this from metalink


Problem: You could get an ORA-09352 on version 7.x of the database, an ORA-12203 on version 8.0.x of the database, or an ORA-12560 on version 8.1.x of the database.

Solution: This is because the bequeath connection is not supported on NT terminal server. Note 66397.1 (INTEL: Windows NT Terminal Server Support) shows the certification.


Can you please tell me how to startup Oracle 9.2.0 wihtout using listener? (on Win XP).

This is my attempt


run... cmd

C:\> set ORACLE_SID=mytest (I also try set the variable on the System Property, Advanced Tab, User variables)  

C:\> sqlplus /nolog  

SQL> connect system as sysdba
password:.... manager  

ORA-12560: TNS: erro....  


 

Thanks in advance

regards,

Sinardy

--

http://www.freelists.org/webpage/oracle-l

--

This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please notify the sender and delete the transmission. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise.

--

http://www.freelists.org/webpage/oracle-l Received on Mon Sep 20 2004 - 01:11:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US