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: Oracle 9i / AIX / trying to start DB / ORA-01031

Re: Oracle 9i / AIX / trying to start DB / ORA-01031

From: HansF <News.Hans_at_telus.net>
Date: Mon, 24 Oct 2005 23:46:03 GMT
Message-Id: <pan.2005.10.24.23.44.42.735463@telus.net>


There are a few possibilities, depending on how this was set up and what config was used.

  1. From any use on that box that has the ORACLE_HOME and ORACLE_SID set up properly

sqlplus 'sys/<password> as sysdba'

should get you in.

2) From the userid that installed the database and software you might be able to getis, with if configured for it, with

sqlplus '/ as sysdba'

Either way make sure you have quoted the entire string (as SQLPlus expects to see 'user/pass AS SYSDBA' as arg[1]) OR defer the userid stuff like

sqlplus /nolog
rem and after you're in
connect / as sysdba

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** I no longer assist with top-posted newsgroup queries ***
Received on Mon Oct 24 2005 - 18:46:03 CDT

Original text of this message

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