DBAsupport.com Forums - Powered by vBulletin
Page 2 of 5 FirstFirst 1234 ... LastLast
Results 11 to 20 of 44

Thread: Cant create Database using dbassist

  1. #11
    Join Date
    Jul 2000
    Posts
    70
    And how do I check for other ORacle processes running on the background?
    I did a ps and all it showed me were the 2 processes, one for the sh and the other ps
    Is that where Im supposed to see Oracle processes too?

  2. #12
    Join Date
    Nov 2000
    Posts
    71
    You spoke abot a .bash_login file. You on a LINUX platform not on a UNIX (HP or SUN)!!!!

  3. #13
    Join Date
    Nov 2000
    Posts
    71
    It's depend from the platform

    If you are on LINUX

    ps aux | grep ora

  4. #14
    Join Date
    Jul 2000
    Posts
    70
    Im sorry, I am on Linux!
    Yes I am on Linux,
    does that make a lot of difference?

  5. #15
    Join Date
    Dec 2000
    Posts
    6
    Linux. Yes, it makes a difference. I've got to drop out
    of this discussion, I don't know bash or Linux kernel
    or memory parameters at all.

    Good luck.

  6. #16
    Join Date
    Jul 2000
    Posts
    70
    ok, I did that, logged in as user ORACLE
    i dont see any oracle processes running.
    One thing though,
    I make changes to the .bash_profile, but when I do a reboot, I dont see the changes take effect.
    For instance, I set
    ORACLE_HOME=/u01/app/oracle/...
    export ORACLE_HOME

    but then when I reboot and do an echo $ORACLE_HOME
    I see nothing.
    SO its obviously not reading the profile file from the users home directory, but somewhere else,
    any ideas???

  7. #17
    Join Date
    Nov 2000
    Posts
    71
    there is not a big difference fore the concepts but for the location of the file you have to modify.
    However those are the parameters you must have stted before installin Oracle:

    SHMMIN 1
    SHMMNI 100
    SHMSEG 10
    SEMMNS 200
    SEMMNI 70
    SEMMSL 100

    The values are indicative!!! Those is what i can suggest you.
    If you have not setted those paramenters you won't ever be able to build and run an instance.
    I hope to have helped you

  8. #18
    Join Date
    Dec 2000
    Posts
    6
    There is a system-wide .profile, which is usually in /etc,
    but I'm not so certain in Linux. But it really doesn't matter,
    because the system-wide .profile doesn't get executed
    *after* yours.

    Here's a suggestion (and this is in Korn shell syntax, similar
    but not exactly the same as Bash). Manually set your
    environment, either in a set-env script or at the command
    line:
    export ORACLE_HOME=/whatever/full/path/is
    export PATH=$ORACLE_HOME/bin:.:
    export ORACLE_SID=<sid name>

    Before you run the installer echo these values:
    env | grep ORACLE
    to make sure they're set.

    In the *same* window (that is important), now run the installer.

    The other option is to build the database yourself. The wizard is
    notorious for this kind of problem. There are scripts out there
    that will build the db, you'll have to edit them a bit. There's a
    good set of scripts on the O'Reilly Oracle Database Admin book.
    I might have one floating around here, as well. I'll look.

  9. #19
    Join Date
    Nov 2000
    Posts
    71
    Even if you try to build the instance manually you'll get the same error because Oracle does Know how many resources you machine has!!
    Settigs I've got are not alternative but REQUIRED before running an Oracle installation.
    However I forgot a parameter above and it is the follow:

    SHMMAX

    However look for Linux installation guide in the section linux environment.
    If i remember well there tou should find all what i've suggested you.

  10. #20
    Join Date
    Jul 2000
    Posts
    70
    OK Ive made the settings to the PATH as told.
    Do I need to declare ORACLE_SID too before creating the database?
    I also made the changes to the shmmax and all those variables.
    Now do I need to run the Installer or the dbassist program?
    Im trying to create a database.
    Would installer do that too?


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width