Re: [suse-oracle] Installed 9i on 8.0 Not quite useable... yet please advise

From: Juergen Froese (juergen@juergen-froese.de)
Date: Mon Oct 07 2002 - 11:23:22 CEST

  • Next message: rob: "Re: [suse-oracle] Installed 9i on 8.0 Not quite useable... yet pleaseadvise" 
    Date: Mon, 07 Oct 2002 11:23:22 +0200
From: Juergen Froese <juergen@juergen-froese.de>
Message-Id: <7990659.1033989802.[192.168.0.2]@juergen-froese.de>
Subject: Re: [suse-oracle] Installed 9i on 8.0 Not quite useable... yet please  advise

    Rob,

    it seems you are coming from Windows. There are lots of really useful
    answers right now in this mail thread, all you need to do is really follow
    them.

    Regarding this:

    > but oradim is command not found

    Yes, and that is ok. You are on Linux now, not Windows.

    > , so again Im hoping to find a list of executables so I can build and
    > access a database

    You already know and use them. dbca, sqlplus, etc.

    >
    > my build scripts look something like this
    >
    > set ORACLE_SID=<INSTANCE>

    set doesn't work on Linux, use export.

    > <ORACLEPATH>\bin\oradim -new -sid <INSTANCE> -intpwd password -startmode
    > manual -pfile <DB_DESTINATION>\Admin\<INSTANCE>\PFILE\init<INSTANCE>.ora
    > <ORACLEPATH>\bin\svrmgrl @<SETUP_PATH>\build_tablespace.sql
    > <ORACLEPATH>\bin\oradim -edit -sid <INSTANCE> -startmode auto

    This is a script using tools to create services under Windows, Linux uses
    Processes, daemons, etc.

    >
    > so is oradim away in 9i?

    No, it never existed. oradim is a plain Windows tool, nothing useful for
    Linux.

    - JP

    --On Sonntag, 6. Oktober 2002 13:54 -0500 rob <dizzy74@attbi.com> wrote:

    > Bennett Leve wrote:
    >
    >> Rob,
    >>
    >> Two issues here. The ORA-27123 problably also flagged an ORA-1034.
    >> This is likely because the database never started in a nomount state.
    >> Check the alert log to see why it failed to start. You need to do this
    >> before you exit out of DBCA as DBCA cleans up the files after the
    >> failure.
    >>
    >>
    > Ok, But the install was yesterday, so I assume the alert<sid>.log is gone
    > or never existed as the the ofa data structure (admin) and (oradata)
    > never got populated.
    >
    > So I do I call the database config asistint I tried
    >
    > dbassist
    > command not found
    >
    > Also how the heck do I find out what nice programs are avaliable to me
    > <grin> ;-)
    >
    >> As far as not being able to find the binaries you can see in your
    >> environment why this is:
    >>
    >>
    >> ORACLE_HOME=/opt/oracle/product/oracle
    >> PATH=/usr/sbin:/bin:/usr/bin:/sbin:/usr/X11R6/bin
    >>
    >> Do the following in your ".bashrc_profile".
    >>
    >> export ORACLE_HOME=/opt/oracle/product/oracle
    >> export PATH=$ORACLE_HOME/bin:$PATH
    >>
    >> This assumes that your ORACLE_HOME is truely /opt/oracle/product/oracle.
    >> You get the message file not found messages when either you have
    >> ORACLE_HOME set improperly, ORACLE_HOME is not exported or the
    >> permissions for the ORACLE_HOME/rdbms/mesg directory and files do not
    >> allow the user access to the files.
    >>
    >>
    > Yes I see now
    >
    > export ORACLE_HOME=/work/9ihome
    > export PATH=$ORACLE_HOME/bin:$PATH
    >
    > works perfectly. So I can call lsnrctl
    > sqlplus
    > tnsping
    > without error
    >
    > but oradim is command not found
    > , so again Im hoping to find a list of executables so I can build and
    > access a database
    >
    > my build scripts look something like this
    >
    > set ORACLE_SID=<INSTANCE>
    > <ORACLEPATH>\bin\oradim -new -sid <INSTANCE> -intpwd password -startmode
    > manual -pfile <DB_DESTINATION>\Admin\<INSTANCE>\PFILE\init<INSTANCE>.ora
    > <ORACLEPATH>\bin\svrmgrl @<SETUP_PATH>\build_tablespace.sql
    > <ORACLEPATH>\bin\oradim -edit -sid <INSTANCE> -startmode auto
    >
    > so is oradim away in 9i?
    > I know svrmgrl is replaced with sqlplus...
    >
    >> Also keep in mind 9.2.0.1 is not supported on Suse 8.0 and it has never
    >> been tested at Oracle. This not your issue though.
    >>
    >> -Bennett
    >>
    >>
    > Yes, this is far , far from anything resembling a production rdbms. This
    > is just a development envioriment for myself, so I can get used to
    > another OS running Oracle
    >
    > Thank you very much for answering my question
    >
    > rob
    >
    > --
    > Coming up with the correct pattern is left as an exercise for the
    > exorcists.
    > -- Larry Wall in <200002031734.JAA24356#>
    >
    >
    >
    >
    > ---------------------------------------------------------------------
    > To unsubscribe, e-mail: suse-oracle-unsubscribe@suse.com
    > For additional commands, e-mail: suse-oracle-help@suse.com
    > Please see http://www.suse.com/oracle/ before posting
    >
    >
    >

    ---------------------------------------------------------------------
    To unsubscribe, e-mail: suse-oracle-unsubscribe@suse.com
    For additional commands, e-mail: suse-oracle-help@suse.com
    Please see http://www.suse.com/oracle/ before posting

    This archive was generated by hypermail 2.1.4 : Mon Oct 07 2002 - 11:24:31 CEST