Onames -setting up oracle named servers
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Onames -setting up oracle named servers

  1. #1
    Join Date
    Sep 2000
    Posts
    384
    $ more sqlnet.ora
    # Generated by Oracle Net8 Assistant

    NAMES.PREFERRED_SERVERS =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = megvserv)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = megvserv)(PORT = 1521))
    )

    NAMESCTL.TRACE_FILE = NCTL


    $ more names.ora
    names.server_name=megvserv
    names.addresses= (ADDRESS =(PROTOCOL =TCP)(HOST=megvserv)(PORT=1575))
    names.use_plug_and_play = TRUE
    NAMES.ADMIN_REGION =
    (REGION =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST =megvserv )(PORT = 1575))
    (CONNECT_DATA = (SID = rman)(Server = Dedicated))
    )
    (USERID = names)
    (PASSWORD = names)
    (NAME = LOCAL_REGION)
    (REFRESH = 86400)
    (RETRY = 60)
    (EXPIRE = 600)
    (VERSION = 134230016)
    )

    $ more listener.ora
    # LISTENER.ORA Configuration File:/opt/app/oracle/product/8.1.6/netw
    stener.ora
    # Generated by Oracle Net8 Assistant

    USE_PLUG_AND_PLAY_LISTENER = TRUE
    CONNECT_TIMEOUT_LISTENER=0

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = megvserv)(PORT = 1521))
    )
    )
    (DESCRIPTION =
    (PROTOCOL_STACK =
    (PRESENTATION = GIOP)
    (SESSION = RAW)
    )
    (ADDRESS = (PROTOCOL = TCP)(HOST = megvserv)(PORT = 2481))
    )
    )


    $ namesctl

    Oracle Names Control for Solaris: Version 8.1.6.0.0 - Production on 22-AUG-2001
    09:36:21

    (c) Copyright 1998, 1999, Oracle Corporation. All rights reserved.

    NNL-00018: warning: could not contact default name server
    Welcome to NAMESCTL, type "help" for information.

    NAMESCTL> start
    Starting "/opt/app/oracle/product/8.1.6/bin/names"...

    $ namesctl set server megvserv

    Oracle Names Control for Solaris: Version 8.1.6.0.0 - Production on 22-AUG-2001
    10:12:39

    (c) Copyright 1998, 1999, Oracle Corporation. All rights reserved.

    NNL-00018: warning: could not contact default name server
    NNC-00003: error opening stream (DESCRIPTION=(CONNECT_DATA=(SID=*)(SERVICE_NAME=
    megvserv))(ADDRESS=(PROTOCOL=TCP)(HOST=megvserv)(PORT=1521)))


    I am not able to proceed further .is there any configuration problems in any of sqlnet.ora /names.ora /etc ...

    Can anyone tell me where exactly i am going wrong ...
    Radhakrishnan.M

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    I think the port # for a name server is 1527 or something. Try changing the port#. If that doesn't work then try. Were you getting any tns errors. If so what are they? Why would you want to have an SID with name "rman", which is a v.bad practice as there is an oracle utility called rman too.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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