Starting 9ir2 in SuSE linux problems
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Starting 9ir2 in SuSE linux problems

  1. #1
    Join Date
    Aug 2000
    Location
    Alberta
    Posts
    82

    Starting 9ir2 in SuSE linux problems

    I installed 9ir2 on suse 7.3 pro, installation went ok except for a glitch near the end when it asked me to open a root window and run the root.sh script. At the time I didnt know that the suid was (somehow) changed in the su command and I could not su to root, so I logged out and back in as root, ran the root.sh script and then ran "relink all" as oracle. All seemed ok.

    The problem is, I can open sqlplus, but I cant connect as / locally to create a database. I went thru dbca and had it create scripts to create a db, then tried run them a step at a time. The problem is I keep getting "ORA-12545: Connect failed because target host or object does not exist" errors, and I'm not sure why.

    I'm not that used to the 'nix world here so I'm not sure what to try next. Ive tried running "./oracle start" from /etc/init.d as root and get the following:

    #############################################################################
    # Begin of O R A C L E startup section #
    #############################################################################


    SETTINGS start from /etc/sysconfig/oracle - !!! MISSING !!!
    - Set Kernel Parameters for Oracle: yes
    - Start Oracle OCFS: no
    - Start Oracle OCM: no
    - Start Oracle GSD: no
    - Start Oracle Database: yes
    - Start Oracle Listener: yes
    - Start Oracle Webserver: no
    - Start Oracle CManager: no
    - Start Oracle Agent: yes
    - Start Oracle Internet Filesystem: no
    - Start Oracle Directory Manager: no


    Setting kernel parameters for Oracle, see file
    /etc/rc.config.d/oracle.rc.config for explanations.

    Shared memory: SHMMAX=3294967296 SHMMNI=4096 SHMALL=2097152
    Semaphore values: SEMMSL=1250 SEMMNS=32000 SEMOPM=100 SEMMNI=256
    Other values: FILE_MAX_KERNEL=131072 IP_LOCAL_PORT_RANGE=1024 65000

    ULIMIT values: MAX_CORE_FILE_SIZE_SHELL=unlimited
    FILE_MAX_SHELL=65536 PROCESSES_MAX_SHELL=16384

    Kernel parameters set for Oracle: done


    - Starting Oracle Cluster Filesystem... unused
    - Starting Oracle Cluster Manager... unused
    - Starting Oracle GSD... unused

    + Starting Database(s)...
    SQL*Plus: Release 9.2.0.1.0 - Production on Tue Sep 16 11:38:20 2003

    Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

    SQL> ERROR:
    ORA-12545: Connect failed because target host or object does not exist


    SQL> ORA-12545: Connect failed because target host or object does not exist
    SQL>
    Database "wbs" warm started.
    Status of Oracle database(s) start: done

    - Starting Listener... done
    - Starting Apache... unused
    - Starting Agent... done
    - Starting Connection Manager... unused
    - Starting Oracle Internet Filesystem... unused
    - Starting Oracle Internet Directory... unused

    #############################################################################
    # End of O R A C L E section #
    #############################################################################

    As you can see, it says the db is warm started, but I still cant connect without getting the ORA-12545 error

    I've deleted and recreated the password file as well.

    any suggestions?

    TIA
    Glen A. S.

  2. #2
    Join Date
    Aug 2003
    Posts
    54
    Hey,

    are you in Alberta??? Calgary ????

  3. #3
    Join Date
    Aug 2000
    Location
    Alberta
    Posts
    82
    yeah - north of Edmonton

    do you know how to fix this?
    Glen A. S.

  4. #4
    Join Date
    Aug 2003
    Posts
    54
    I did install Redhat Linux Advance server 2.1, I never done on suse. Seem like you are on the right track and my only advise is that reinstall Oracle and when you get to the root.sh, don't log out open another windows and su - and run the scripts

  5. #5
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    I do SuSE 7 and 8.

    If you got to the root.sh, all the chosen Oracle software was installed and compiled.

    You're good to go.

    The errors you're having are TNS errors (sql*net). Did you create/configure a tnsnames.ora or listener.ora file?

    What are the results of the following command:

    ps -ef|grep _smon

    Should look something like this if your database is running:

    oracle 1890 1 0 15:00 ? 00:00:00 ora_smon_LINTEST
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  6. #6
    Join Date
    Aug 2000
    Location
    Alberta
    Posts
    82
    Originally posted by KenEwald
    I do SuSE 7 and 8.

    If you got to the root.sh, all the chosen Oracle software was installed and compiled.

    You're good to go.

    **thats what I though (and was hoping!)

    The errors you're having are TNS errors (sql*net). Did you create/configure a tnsnames.ora or listener.ora file?

    **yes, but didnt think an entry in tnsnames was neccesary yet, in any case, I created one with netmgr and also made sure the listern was running, even added an database for the listener to listen for, but this should be unnecessary as well...

    What are the results of the following command:

    ps -ef|grep _smon

    Should look something like this if your database is running:

    oracle 1890 1 0 15:00 ? 00:00:00 ora_smon_LINTEST
    this is where my problem is, all I get back is the ps -ef|grep _smon!

    so how do I get oracle itself running?

    thanks!
    Glen A. S.

  7. #7
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    OK, let's get your database started.

    If the database creation scripts completed successfully, login as the oracle user, set your $ORACLE_HOME and $ORACLE_SID environment variables, and add $ORACLE_HOME/bin to your $PATH.

    I posted a script for this earlier today, you may want to check that out. It will end up looking something like this:

    Select an Environment to Set :

    1) LINT11i 8.l.7
    2) LINTEST 9.2.0.3
    3)
    4) SLGX 8.1.7.2 Shareplex

    Q) Quit

    Enter choice :
    2
    ORACLE_SID is set to LINTEST
    oracle@lintest:~> sqlplus

    SQL*Plus: Release 9.2.0.3.0 - Production on Tue Sep 16 16:56:22 2003

    Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

    Enter user-name: / as sysdba
    Connected to an idle instance.

    SQL> startup
    ORACLE instance started.

    Total System Global Area 219746960 bytes
    Fixed Size 451216 bytes
    Variable Size 201326592 bytes
    Database Buffers 16777216 bytes
    Redo Buffers 1191936 bytes
    Database mounted.
    Database opened.
    SQL>


    Once you get here, your database is running.

    Next thing is to configure the listener.ora file and tnsnames.ora files.
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  8. #8
    Join Date
    Aug 2000
    Location
    Alberta
    Posts
    82
    Perhaps I didn't make myself clear enough. The problem is, I am still getting a "ORA-12545:connect failed because target host or object does not exist" and I'm not sure why as the ORACLE_HOME,ORACLE_BASE and ORACLE_SID entries are all showing up ok when I do an env command. I've created an entry for tnsnames for the db, but that should be unneccesary as it is a local database.

    If I run ./oracle start from /etc/init.d it goes thru the oracle startup and tells me that the database is warm started, but if I do a ps-ef|grep smon it shows nothing, which tells me that oracle itself has not started.

    Glen A. S.

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