Re: Just a very simple question - ORA-01034

"cpchan" <cpchaney_at_netvigator.com> writes:
> (2) I ran this command for backup an Oracle database's data records only :
>
> tar -cvf /dev/rmt/0 <the directory of the data record of the Oracle
> database>
> (3) And then ran this command for restore :
>
> tar -xvf /dev/rmt/0 <the same directory>
> (4) Then I tried to login the Oracle through the SQL Plus on my Windows 98

There is two smallish mistakes:

1. tar does not restore owners of files without usage of p parameter when extracting so you`ll want to do something like find <the same directory> -exec chown oracle.dba {} \; where oracle is the oracle db owner account and dba is her primary group.
2. the command that starts the database at OS startup resides somewhere in /etc directory, I have no solaris handy so I can`t check right now but there is something like /etc/rcX.d directory where X goes from 0 to 6 and at directory whose number is returned with command grep -E '^id' /etc/inittab you`ll want to create a /bin/sh script that boots the db. usually something like this su - oracle -c /etc/orastartup.sh and contents of /etc/orastartup might be like this

   ---

   #!/bin/sh ORACLE_HOME=<the same directory> ORACLE_TERM=vt100 ORACLE_SID=sid export ORACLE_HOME ORACLE_TERM ORACLE_SID $ORACLE_HOME/app/oracle/product/versionnumber/bin/svrmgrl << END_OF_COMMANDS connect internal as SYSDBA startup open END_OF_COMMANDS $ORACLE_HOME/app/oracle/product/versionnumber/bin/lsnrctl start exit 0

   ---

   But I have no access to oracle documentation so this might be syntactically and semantically bullshit. And it`s friday night and I`ve had a few beers.. :)

        As example read some other shell scripts from the same 
        /etc/rcX.d directory (in some OS`s it`s /sbin/rcX.d ???)
        as there you`ll need to condition on command line parameter
        that tells if the command needs to start,stop or restart
        wanted service and you do not want your oracle db
        to be left at mercy of "kill -9" of operating systems cleanup
        procedures after everything should have been terminated anyway :)

        The best thing about unix is that everything really is there
        in human readable form and you actually can re-write it all. 
        And it is not difficult. Just read the man page. Like
        "man init" 

-- 
Antti Järvinen, costello_at_iki.fi
            "concerto for two faggots and orchestra"