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

Home -> Community -> Usenet -> c.d.o.server -> Re: Basic Question Oracle 10g manually startup sequence, Win XP SP 2

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

From: Terminator <kramakrishnabest_at_gmail.com>
Date: 30 Jun 2005 21:16:09 -0700
Message-ID: <1120191369.806825.193340@g47g2000cwa.googlegroups.com>

  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 Received on Thu Jun 30 2005 - 23:16:09 CDT

Original text of this message

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