8.1.7 DB Instance craetion on LINUX,ORA-error
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 16

Thread: 8.1.7 DB Instance craetion on LINUX,ORA-error

  1. #1
    Join Date
    Nov 2001
    Posts
    118

    8.1.7 DB Instance craetion on LINUX,ORA-error

    Hi Everyone,

    Big headscratcher for me: I have a new LINUX server and both Oracle 9i und Oracle 8.1.7 Server software have been installed. Setting up an instance for 9i wasnít a problem, but when I try to install any instance under Oracle 8.1.7, something strange happens (Iím doing this on the command line using scripts and/or setting up by hand for testing purposes):

    Environment is set to Oracle 8, ORACLE_SID is set, directories for the instance are created, I call svrmgrl, enter connect internal, everything fine until now.

    Then I enter startup nomount pfile=[pathname to initora-file], and what I get after about 30 seconds is:
    íORA-03113: End-of-file on communication channelí.

    But it gets stranger: From now on I canít call svrmgrl with that ORACLE_SID without getting that ORA error immediately I call the svrmgrl, it doesnt even let me do a connect internal. But if I change the ORACLE_SID, I can connect internally again, until I try to do the startup nomount again, then I have the same problem with that new SID.

    At first I thought something was wrong with the init.ora, but I checked and tested everything, but everything is fine there.

    IPCS doesnít show any oracle processes either. Does anyone have any ideas on this one?

    Thanks
    Peer

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    how are your kernel settings, you might be blowing them

  3. #3
    Join Date
    Nov 2001
    Posts
    118
    Kernel settings are OK, anyway, if they weren't the Oracle 9i instance wouldn't be running.

  4. #4
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405
    LD_LIBRARY_PATH and PATH ???
    -nagarjuna

  5. #5
    Join Date
    Nov 2001
    Posts
    118
    All PATHs and other environment variables are OK for Oracle 8 environment, including JAVA paths etc.

  6. #6
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405
    Any errors in alert log file? Looks like a memory issue.
    -nagarjuna

  7. #7
    Join Date
    Apr 2003
    Posts
    353
    Shutdown 9i instance,
    startup 8 using pfile.

  8. #8
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    Originally posted by Peer Jones
    Kernel settings are OK, anyway, if they weren't the Oracle 9i instance wouldn't be running.
    i said you might have blown them, i.e they are set too low for two instances

  9. #9
    Join Date
    Nov 2001
    Posts
    118
    No alerts, but I have just noticed one thing: My $ORACLE_HOME/dbs directory is filling up with core directories (and these with files).

    In fact I get 4 new ones every time I start svrmgrl with the ORACLE_SID set to the 'wrong' instance.

    Oh, and I did check again, and the kernel parameters are set to deal with loads of instances, if need be. Sorry.

  10. #10
    Join Date
    May 2003
    Location
    Pretoria, Rep of South Africa
    Posts
    191
    Remember to set different ports for each instance. I had similar problem on big project using 816 and 9.1
    Able was I ere I saw Elba

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