This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 31st, when you will be able to use this site as normal.

    Forum Stats

  • 3,890,899 Users
  • 2,269,649 Discussions
  • 7,916,821 Comments

Discussions

[INS-20802] Oracle Net Configuration Assistant failed

24

Answers

  • 947157
    947157 Member Posts: 33
    edited Jul 15, 2012 2:37PM
    I am trying to install Oracle on the Server, there is no client. Firewall is disabled anyway.


    [[email protected] nitro]# iptables --list
    Chain INPUT (policy ACCEPT)
    target prot opt source destination

    Chain FORWARD (policy ACCEPT)
    target prot opt source destination

    Chain OUTPUT (policy ACCEPT)
    target prot opt source destination

    Edited by: keymoo on 15-Jul-2012 11:37 (added iptables)
  • sb92075
    sb92075 Member Posts: 42,196 Blue Diamond
    Post results from following OS commands

    lsnrctl status
    lsnrctl service

    COPY commands & results then PASTE all back here
  • 947157
    947157 Member Posts: 33
    edited Jul 15, 2012 3:27PM
    Where is that program?

    [[email protected] nitro]# lsnrctl status
    -bash: lsnrctl: command not found

    [[email protected] nitro]# lsnrctl service
    -bash: lsnrctl: command not found

    [[email protected] home]# whereis lsnrctl
    lsnrctl:


    I found it using locate

    [[email protected] bin]# ./lsnrctl status

    LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 15-JUL-2012 20:25:47

    Copyright (c) 1991, 2009, Oracle. All rights reserved.

    Message 1053 not found; No message file for product=network, facility=TNSTNS-12541: Message 12541 not found; No message file for product=network, facility=TNS
    TNS-12560: Message 12560 not found; No message file for product=network, facility=TNS
    TNS-00511: Message 511 not found; No message file for product=network, facility=TNS
    Linux Error: 111: Connection refused

    Edited by: keymoo on 15-Jul-2012 12:26 (found lsnrctl)
  • sb92075
    sb92075 Member Posts: 42,196 Blue Diamond
    you must be logged on the OS as the same OS user who owns ORACLE_HOME directory tree

    id
    env | sort

    COPY commands above & results then PASTE all back here
  • 947157
    947157 Member Posts: 33
    The graphical installer has been run using the oracle user. I notice that the ORACLE_BASE directory might be wrong but I don't know why. I don't have a /u01 directory. Here are the commands you wanted:

    login as: oracle
    [email protected]'s password:
    Last login: Sun Jul 15 16:49:09 2012

    [[email protected] ~]$ lsnrctl
    -bash: lsnrctl: command not found

    [[email protected] ~]$ id
    uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba)

    [[email protected] ~]$ env|sort
    _=/bin/env
    CLASSPATH=/u01/app/oracle/product/11.2.0/db_1/jlib:/u01/app/oracle/product/11.2. 0/db_1/rdbms/jlib
    CVS_RSH=ssh
    G_BROKEN_FILENAMES=1
    HISTSIZE=1000
    HOME=/home/oracle
    HOSTNAME=nitrogen.localdomain
    INPUTRC=/etc/inputrc
    LANG=en_US.UTF-8
    LD_LIBRARY_PATH=/u01/app/oracle/product/11.2.0/db_1/lib:/lib:/usr/lib
    LESSOPEN=|/usr/bin/lesspipe.sh %s
    LOGNAME=oracle
    LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;0 1:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.b tm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31: *.taz=00;31:*.lzh=00;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:* .bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00;3 5:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:
    MAIL=/var/spool/mail/oracle
    ORACLE_BASE=/u01/app/oracle
    ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1
    ORACLE_HOSTNAME=ol5-112.localdomain
    ORACLE_SID=DB11G
    ORACLE_UNQNAME=DB11G
    PATH=/u01/app/oracle/product/11.2.0/db_1/bin:/usr/sbin:/usr/kerberos/bin:/usr/lo cal/bin:/bin:/usr/bin:/home/oracle/bin
    PWD=/home/oracle
    SHELL=/bin/bash
    SHLVL=1
    SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
    SSH_CLIENT=10.0.0.57 31962 22
    SSH_CONNECTION=10.0.0.57 31962 10.0.0.7 22
    SSH_TTY=/dev/pts/4
    TERM=xterm
    TMPDIR=/tmp
    TMP=/tmp
    USER=oracle
    [[email protected] ~]$
  • sb92075
    sb92075 Member Posts: 42,196 Blue Diamond
    find / -name lsnrctl 2>/dev/null

    COPY command above & results then PASTE all back here
  • 947157
    947157 Member Posts: 33
    [[email protected] /]$ find / -name lsnrctl 2>/dev/null
    /app/oracle/product/11.2.0/db_1/bin/lsnrctl
  • sb92075
    sb92075 Member Posts: 42,196 Blue Diamond
    export ORACLE_BASE=/app/oracle
    export ORACLE_HOME=/app/oracle/product/11.2.0/db_1
    export PATH=/app/oracle/product/11.2.0/db_1/bin:/usr/sbin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/oracle/bin

    lsnrctl status
    lsnrctl service
  • 947157
    947157 Member Posts: 33
    My GUI screen still looks like this http://i.imgur.com/CxIVz.png


    [[email protected] /]$ lsnrctl status

    LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 15-JUL-2012 21:54:31

    Copyright (c) 1991, 2009, Oracle. All rights reserved.

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
    TNS-12541: TNS:no listener
    TNS-12560: TNS:protocol adapter error
    TNS-00511: No listener
    Linux Error: 2: No such file or directory
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ol5-112.localdomain)(PORT=1521)))
    TNS-12535: TNS:operation timed out
    TNS-12560: TNS:protocol adapter error
    TNS-00505: Operation timed out
    Linux Error: 110: Connection timed out
    [[email protected] /]$ lsnrctl service

    LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 15-JUL-2012 21:55:20

    Copyright (c) 1991, 2009, Oracle. All rights reserved.

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
    TNS-12541: TNS:no listener
    TNS-12560: TNS:protocol adapter error
    TNS-00511: No listener
    Linux Error: 2: No such file or directory
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ol5-112.localdomain)(PORT=1521)))
    TNS-12535: TNS:operation timed out
    TNS-12560: TNS:protocol adapter error
    TNS-00505: Operation timed out
    Linux Error: 110: Connection timed out
  • sb92075
    sb92075 Member Posts: 42,196 Blue Diamond
    lsnrctl start

    COPY command & results then PASTE all back here
This discussion has been closed.