Re: Basic Question Oracle 10g manually startup sequence, Win XP SP 2

Terminator wrote:
> 1. Try to see the status of the listener and restart the listener if
> needed.
> 2. Then set the [path=C:\Oracle\product\10.1.0\Db_1\BIN]
> 3. Then set the [ORACLE_SID=SID]
> 4. Then set the [ORACLE_HOME=C:\Oracle\product\10.1.0\Db_1]
> 5. Then do the [SQL> "/as sysdba"] at the SQL prompt.
> 6. If it still not connects then recreate the password file with ORAPWD
> utility.
> syntax:- orapwd file=<fname> password=<password> entries=<users>
> force=<y/n>
> 7. Then try the following procedures as below:-
> C:\>sqlplus
>
> SQL*Plus: Release 10.1.0.2.0 - Production on Mon Jul 1 09:49:53 2002
>
> Copyright (c) 1982, 2004, Oracle. All rights reserved.
>
> Enter user-name: sys as sysdba
> Enter password:
>
> Connected to:
> Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
> With the Partitioning, OLAP and Data Mining options
>
> SQL>
>
>
> Regards
> Terminator
>

Did you actually *read* the OP? He shut down the oracle service. No magic with password files or sqlplus will get it back. Net start or oradim is what he needs, so you're advice is potentially dangerous.

But that's what your nickname is about, right? ;-)

Holger Received on Fri Jul 01 2005 - 01:40:52 CDT