home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.oracle      Overblown overpriced overengineered SHIT      2,288 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 1,340 of 2,288   
   Douglas Hawthorne to tgagne@wide-open-west.com   
   Re: Missing ora_control1 ???   
   25 Apr 04 06:52:46   
   
   From: douglashawthorne@yahoo.com.au   
      
   "Thomas Gagné"  wrote in message   
   news:-uydne8rwuMsqRbdRVn-hA@wideopenwest.com...   
   > I've never installed Oracle, and have just worked my way through getting   
   > 9i installed on RedHat 9.   
   >   
   > When I try to start it up I get the following:   
   >   
   >     [oracle@cod1 oracle]$ sqlplus /nolog   
   >   
   >     SQL*Plus: Release 9.2.0.4.0 - Production on Sat Apr 24 23:37:05 2004   
   >   
   >     Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.   
   >   
   >     SQL> connect / as sysdba   
   >     Connected to an idle instance.   
   >     SQL> startup   
   >     ORACLE instance started.   
   >   
   >     Total System Global Area   42742804 bytes   
   >     Fixed Size                   451604 bytes   
   >     Variable Size              41943040 bytes   
   >     Database Buffers             204800 bytes   
   >     Redo Buffers                 143360 bytes   
   >     ORA-00205: error in identifying controlfile, check alert log for   
   >     more info   
   >   
   > I'm not exactly sure which file they're talking about, but I did find   
   > something that looked interesting:   
   >   
   >     [oracle@cod1 oracle]$ cat rdbms/log/alert_oracle.log   
   >     Sat Apr 24 23:37:14 2004   
   >     Starting ORACLE instance (normal)   
   >      Disable cache advisory with old cache parameters   
   >     Sat Apr 24 23:37:14 2004   
   >     Running with 1 strand for Non-Enterprise Edition   
   >     ...   
   >     Sat Apr 24 23:37:15 2004   
   >     ALTER DATABASE   MOUNT   
   >     Sat Apr 24 23:37:16 2004   
   >     ORA-00202: controlfile: 'ora_control1'   
   >     ORA-27037: unable to obtain file status   
   >     Linux Error: 2: No such file or directory   
   >     Additional information: 3   
   >     Sat Apr 24 23:37:16 2004   
   >     ORA-205 signalled during: ALTER DATABASE   MOUNT...   
   >     Any help, pointers, etc., would be apprecated.   
   >   
   > So why am I doing this?  My background is Sybase but I'm not excited   
   > about their XML support.  I've only read about Oracle's and wanted to   
   > try it out.   
   >   
   > --   
   > .tom   
   > remove email address' dashes for replies   
   > opensource middleware at    
   >    
      
   Tom,   
      
   Have you checked out the documentation at   
   http://www.dizwell.com/html/9i_-_red_hat_9.html for how to install Oracle 9i   
   on RH9 ?   
      
   It would appear that you have not created the database as yet.  You may also   
   wish to review the instructions in Chapter 2 of the "Oracle 9i Database   
   Administrator's Guide" with emphasis on the dbca utility to automate much of   
   the process as possible.   
      
   Douglas Hawthorne   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca