精华内容
下载资源
问答
  • oracle偏爱hostname

    2013-11-26 10:17:00
    记住: 只要是在使用oracle他家的产品,比如oracle database , weblogic ;或者诸如此类,等等,等等,随便别的什么东西   首先要查改: /etc/hosts 127.0.0.1 hostname...

    记住:

    只要是在使用oracle他家的产品,比如oracle database , weblogic ;或者诸如此类,等等,等等,随便别的什么东西

     

    首先要查改:

    /etc/hosts

    127.0.0.1   hostname

    展开全文
  • ORACLE_HOSTNAME

    千次阅读 2009-05-24 18:28:00
    2.4.3 Installing on Multihomed ComputersYou can install Oracle Database on a multihomed computer. A multihomed computer is associated with multiple IP addresses. This is typically achieved by having m

    2.4.3 Installing on Multihomed Computers
    You can install Oracle Database on a multihomed computer. A multihomed computer is associated with multiple IP addresses. This is typically achieved by having multiple network cards on the computer. Each IP address is associated with a host name. In addition, you can set up aliases for the host name. By default, Oracle Universal Installer uses the ORACLE_HOSTNAME environment variable setting to find the host name. If ORACLE_HOSTNAME is not set and you are installing on a computer that has multiple network cards, then Oracle Universal Installer determines the host name by using the first entry in the /etc/hosts file.

    Clients must be able to access the computer either by using this host name or by using aliases for this host name. To verify this, ping the host name from the client computers using the short name (hostname only) and the full name (hostname and domain name). Both tests must be successful.

    Setting the ORACLE_HOSTNAME Environment Variable

    Use the following procedure to set the ORACLE_HOSTNAME environment variable.

    For example, if the fully qualified host name is somehost.us.acme.com, then enter one of the following commands:

    Bourne, Bash, or Korn shell:

    $ ORACLE_HOSTNAME=somehost.us.acme.com
    $ export ORACLE_HOSTNAME

    C shell:

    % setenv ORACLE_HOSTNAME somehost.us.acme.com

    展开全文
  • 在linux上安装完oracle数据库后,如何修改ORACLE_HOSTNAME

    预备:先关闭ORACLE数据库及监听,具体方法见:http://blog.csdn.net/zxnlmj/article/details/23096877

    1、修改HOSTS文件,添加JTWF到本机IP地址的映射:


    [root@JTWF home]# gedit /etc/hosts
    最后一行为添加的:

    
    127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
    ::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
    16.54.136.81 JTWF


    2、修改/etc/sysconfig/network添加如下:

    [root@JTWF home]# gedit /etc/sysconfig/network
    NETWORKING=yes
    HOSTNAME=JTWF

    3、修改listener.ora


    su oracle
    
    gedit /home/oracle/product/11.2/db_1/network/admin/listener.ora


    修改HOST由HOST=localhost改为HOST=JTWF(随意):

    # listener.ora Network Configuration File: /home/oracle/product/11.2/db_1/network/admin/listener.ora
    # Generated by Oracle configuration tools.
    
    LISTENER =
      (DESCRIPTION_LIST =
        (DESCRIPTION =
          (ADDRESS = (PROTOCOL = TCP)(HOST = JTWF)(PORT = 1521))
        )
      )
    
    ADR_BASE_LISTENER = /home/oracle

    4、tnsnames.ora文件不修改也可,我没修改


    gedit /home/oracle/product/11.2/db_1/network/admin/tnsnames.ora 

    # tnsnames.ora Network Configuration File: /home/oracle/product/11.2/db_1/network/admin/tnsnames.ora
    # Generated by Oracle configuration tools.
    
    ORCL =
      (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
        (CONNECT_DATA =
          (SERVER = DEDICATED)
          (SERVICE_NAME = orcl)
        )
      )


    展开全文
  • The issue can be reproduced at will with the following steps... Change the hostname.2. Check DBConsole statusISSUE VERIFICATION==================Verified the issue referencing data collected records a...

    The issue can be reproduced at will with the following steps:

    1. Change the hostname.

    2. Check DBConsole status

    ISSUE VERIFICATION

    ==================

    Verified the issue referencing data collected records as noted below.

    CAUSE DETERMINATION

    ===================

    The issue is caused by the following setup: hostname changed.

    CAUSE JUSTIFICATION

    ===================

    This issue is described in Metalink Note 330130.1

    PROPOSED SOLUTION(S)

    ====================

    Recreate the DBConsole

    PROPOSED SOLUTION JUSTIFICATION(S)

    ==================================

    After the hostname changes the DBConsole must be recreated to update the repository tables.

    SOLUTION / ACTION PLAN

    ======================

    -- To implement the solution, please execute the following steps::

    Prepare the environment:

    - Open a new terminal window.

    - Go to the Oracle installation folder.

    - Set the ORACLE_HOME variable according to that folder.

    eg. export ORACLE_HOME=/opt/oracle/db1

    Please follow the steps below.

    1. Stop the dbconsole on the target node

    $ORACLE_HOME/bin/emctl stop dbconsole

    2. Delete the repository and directory structure using EMCA:

    - go to $ORACLE_HOME/bin

    - at the command prompt, enter the following command:

    $PROMPT> emca -deconfig dbcontrol db -repos drop

    - follow the instructions on the screen

    3) If this returns successfully please go to step 5, otherwise follow step 4.

    4) If the EMCA returns in any error please remove the repository manually:

    4.1) Logon SQLPLUS as user SYS and drop the sysman account and management objects:

    A. drop user sysman cascade;

    B. drop role MGMT_USER;

    C. drop user MGMT_VIEW cascade;

    D. drop public synonym MGMT_TARGET_BLACKOUTS;

    E. drop public synonym SETEMVIEWUSERCONTEXT;

    5) After repository deletion please recreate the repository and directory structure.

    - go to $ORACLE_HOME/bin

    - at the command prompt, enter the following command:

    $PROMPT> emca -config dbcontrol db -repos create

    - follow the instructions on the screen

    6) In case the dbconsole startup fails please provide the files of folder

    $ORACLE_HOME/cfgtoollogs

    and

    $ORACLE_HOME/_/sysman/log

    to metalink.

    然后,进行em后,界面出来了,但报了一个错:

    java.lang.Exception: Exception in sending Request :: null

    [oracle@oracle config]$ pwd

    /op/oracle/product/10.2.4/oracle_orcl/sysman/config

    [oracle@oracle config]$ vi emd.properties

    把该值修改为:agentTZRegion=Asia/Chongqing

    关于时区的列表参考:10.2.0\db_1\sysman\admin\supportedtzs.lst

    然后,重启OracleDBConsole

    阅读(2198) | 评论(0) | 转发(0) |

    展开全文
  • Linux修改hostname的常用操作方法是——手工在/etc/sysconfig/network中追加"HOSTNAME=xxxxx"并重启系统,这个方法在Oracle Linux 7中是不生效的。 那么在Oracle L...
  • host name方式只支持tcp/ip协议的小局域网  修改listener.ora中的如下信息  (SID_DESC = ... (ORACLE_HOME = E:\oracle\ora92) --oracle home  (SID_NAME = orcl) --sid name  )  然后在...
  • The issue can be reproduced at will with the following steps... Change the hostname.2. Check DBConsole statusISSUE VERIFICATION==================Verified the issue referencing data collected records a...
  • 在网上搜了,有的说在各个节点的oracle用户下的.bash_profile添加export ORACLE_HOSTNAME=各自的主机名; 比如两个节点的主机名node1,node2;分别添加export ORACLE_HOSTNAME=node1,export ORACLE_...
  • The issue can be reproduced at will with the following steps:1. Change the hostname.2. Check DBConsole statusISSU...
  • 修改oracle RAC public hostname ,ip

    千次阅读 2013-11-02 15:33:19
     Changing public hostname Public hostname is recorded in OCR, it is entered during installation phase. It can not be modified after the installation. The only way to modify public hostname i
  • 背景:做双机时,如果两台服务器的主机名hostname默认没有改变,则会导致一系列的问题。所以需要修改服务器的hostname。 1.#vi /etc/HOSTNAME 修改成新名称 2.#vi /etc/hosts 修改映射 3.然后同时要修改oracle...
  • 前提条件:oracle 11g + centos 6.5 报错信息: ORA-00119: invalid specification for system parameter LOCAL_LISTENER ORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=DB_03)(PORT=1521))...
  • Oracle Linux7中怎么配置hostname

    千次阅读 2017-03-03 16:45:01
    Oracle Linux7中怎么配置hostname? 来源于: How to Configure hostname in Oracle Linux 7 (文档 ID 2049221.1) 适用于: Linux OS - Version Oracle Linux 7.0 and later Linux x86 Linux x86-64 ...
  • sysctl kernel.hostname=oracledb –运行后立即生效(新会话生效),但是在系统重启后会丢失所做的修改 步骤2:配置文件 ,添加hostname,重启后永久生效 #vi /etc/sysconfig/network NETWORKING=yes HOSTNAME=o
  • Modifying the VIP Address or VIP Hostname in Oracle RAC Node http://www.oracleracexpert.com/2010/06/modifying-vip-address-or-vip-hostname.html Oracle 10g or 11g uses Virtual IP address (VIP)
  • 【翻译自mos文章】在Oracle Linux7中怎么配置hostname
  • Oracle Linux7中通过修改/etc/sysconfig/network这种方式并不能修改Oracle Linux 7的主机名。为了对Oracle Linux 7修改主机名,可以通过执行以下任何一种方法来实现: ...
  • 安装oracle后,修改hostname导致错误

    千次阅读 2009-08-28 12:39:00
    1)修改hostname为www.ixdba.net2)修改/etc/hosts,去掉原来的主机名的行,增加该行 192.168.60.253 www.ixdba.net3)重启数据库,查询instance信息 select * from v$instance; 得到新的HOST_NAME为...
  • --oracle查看链接的hostname 和IP分别是什么: select utl_inaddr.get_host_address(host_name), host_name from v$in...
  • 原帖地址:http://blog.sina.com.cn/s/blog_519029800100n6ue.html   1. 修改主机的hostname 后, 使用 dbstart 启动数据库,发现数据库可以启动,但是 listener 无法启动,报错:  TNS-1253
  • oracle查询DBname 和 hostname(instance)

    千次阅读 2012-03-16 15:36:35
    select host_name from v$instance ; select name from v$database  一个instance上有多个database。
  • 默认oracleXE 启动OracleXETNSListener和OracleServiceXE两个服务。 在修改hostname后导致OracleXETNSListener无法启动。     解决方法:修改:   .../NETWORK/ADMIN/tnsnames.ora .../NETWORK/ADMIN/...
  • In this Document   Symptoms   Cause   Solution ... Oracle Server - Enterprise Edition - Version: 11.2.0.2 and later [Release: 11.2 and later ] Information in this
  • xp+oracle 10g   静态监听器的配置 关键文件 G:/oracle/product/10.2.0/db_1/NETWORK/ADMIN/listener.ora SID_LIST_LISTENER =  (SID_LIST =  (SID_DESC =  (SID_NAME...
  • 测试环境:redhat 6.4, oracle 12c总共要修改3个地方1)[root@ora92 /]# vi /etc/hosts192.168.56.16 ora932)[root@ora92 /]# vi /etc/sysconfig/networkHOSTNAME=ora933)[oracle@ora93 ~]$vi /opt/oracle/product...
  • linux下hostname修改机器名后,删除oracle实例报错 cd /u01/oracle_home/bin/ ./dbca报 An unexpected exception has been detected in native code outside the VM 的解决方案 *******************************...

空空如也

空空如也

1 2 3 4 5 ... 20
收藏数 41,891
精华内容 16,756
关键字:

oracle的hostname