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,338 of 2,288   
   =?ISO-8859-1?Q?Thomas_Gagn=E9?= to All   
   Missing ora_control1 ???   
   24 Apr 04 23:46:43   
   
   From: tgagne@wide-open-west.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    
      
      
   --- 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