Re: OracleXE 10g listener service can't start after server joined domain and changed computer name.
Date: Thu, 17 Apr 2008 20:02:20 -0700 (PDT)
Message-ID: <185e0b22-e440-4765-b54f-dc957cb4c746@l42g2000hsc.googlegroups.com>
On Apr 18, 3:09 am, Frank van Bortel <frank.van.bor..._at_gmail.com>
wrote:
> Amber wrote:
>
> >> Copy and paste the output you get here.
>
> > SQL*PLUS: Release 10.2.0.1.0 - Production on...........
> > Copyright........
> > Connected to an idel process.
> > SQL>
>
> that is not copy/paste...
>
> Anyway, copy and paste this:
>
> startup
C:\Documents and Settings\GUXIAOBO>sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on 星期五 4月 18 09:57:38 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
已连接到空闲例程。
If I change SQLNET.AUTHENTICATION_SERVICES = (NTS) to SQLNET.AUTHENTICATION_SERVICES = (NONE) in sqlnet.org,
the output is the following:
C:\Documents and Settings\GUXIAOBO>sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on 星期五 4月 18 10:00:07 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR: ORA-01031: insufficient privileges
请输入用户名: sys
输入口令:
ERROR: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist Received on Thu Apr 17 2008 - 22:02:20 CDT