Oracle for Windows XP with INTEL inside 2004-09-20 - By Sinardy Xing
Hi Graeme,
Thanks for your info
It is not a server but it is my notebook, I create the DB with the DB assist, after the creation my db looks ok I even upgrade my catalog with catparr.sql, and create few tables, then I decide to configure the listener, I don 't know why the listener is not working, so I remove the listener, tnsnames and sqlnet files, because I just want to connect to my database directly without using listener, now my database give me ORA-12560 (See ORA-12560.ora-code.com):
btw, I found from AskTom, he said I need to use ORADIM to register my DB, I delete and recreate my services with oradim, I also recreate the password file, then I can connect with sys as sysdba.
Thanks for the tips for the first time connect using Sys account not system.
regards,
Sinardy
-- --Original Message-- --
From: Graeme.Farmer@(protected) [mailto:Graeme.Farmer@(protected)]
Sent: 20 September 2004 14:15
To: Sinardy Xing
Cc: oracle-l@(protected); oracle-l-bounce@(protected)
Subject: Re: Oracle for Windows XP with INTEL inside
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@(protected) >
Sent by: oracle-l-bounce@(protected)
20/09/2004 02:08 PM
Please respond to
SinardyXing@(protected)
To
<oracle-l@(protected) >
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 (See ORA-09352.ora-code.com) on version 7.x of the database, an ORA-12203 (See ORA-12203.ora-code.com) on version 8.0.x of the database, or an ORA-12560 (See ORA-12560.ora-code.com) 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 (See ORA-12560.ora-code.com): 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
|
|
