DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: ORA-12230

  1. #1
    Join Date
    Feb 2001
    Location
    Scotland
    Posts
    200
    Hi there,

    I have a small test database on my laptop, which I connect to through a local TNSNAMES.ORA file and LISTENER.ORA file.

    When I am connected to the network I can access this (and all the other) database fine, however when I disconnect from the network and try to connect to the local test database I get the following error.

    "ORA-12230:Unable to connect to destination"

    I suspect it's something to do with my settings in the TNSNAMES file but I can't see what.

    It's an Oracle7.3.3 database on NT4 laptop.

    This is the part of my TNSNAMES which referenced this particular database....

    ateolq.world =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS =
    (COMMUNITY = tcp.world)
    (PROTOCOL = TCP)
    (Host = tonnera)
    (Port = 1521)
    )
    (ADDRESS =
    (COMMUNITY = tcp.world)
    (PROTOCOL = TCP)
    (Host = tonnera)
    (Port = 1526)
    )
    )
    (CONNECT_DATA = (SID = eolq)
    )
    )

    Any help would be appreciated, I am in the process of studying for my OCP exams and want to work from home.

    Cheers

    Alison

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    I would bet it has something to do with host naming. Try your IP address instead of the hostname in your tnsnames.ora. For example:
    ateolq.world =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS =
    (COMMUNITY = tcp.world)
    (PROTOCOL = TCP)
    (Host = 127.1.1.101)
    (Port = 1521)
    )
    (ADDRESS =
    (COMMUNITY = tcp.world)
    (PROTOCOL = TCP)
    (Host = 127.1.1.101)
    (Port = 1526)
    )
    )
    (CONNECT_DATA = (SID = eolq)
    )
    )
    Jeff Hunter

  3. #3
    Join Date
    Feb 2001
    Location
    Scotland
    Posts
    200
    Hi marist89

    Thanks for you help,

    I tried to change the host name from tonnera to my IP address but still come up with the same error (when connected to the network I can access the database with this IP address in my TNSNAMES)

    While unconnected I ran a TNSPING and got the following error:

    "TNS-12560: Protocol adapter Error"

    Could this be because the PROTOCOL in the TNSNAMES file is TCP, if this is the case what should I change it to.

    Cheers

    Alison

  4. #4
    Join Date
    Jul 2000
    Posts
    243
    Hi

    is your listener up? check that.

  5. #5
    Join Date
    Feb 2001
    Location
    Scotland
    Posts
    200
    I believe the listener is up.

    When I am connected to the network everything is fine, it's only when I go stand alone that the problem occurs..

    All the relevant elements exist on my laptop (database, instance, TNSNAMES, LISTENER) that is why I'm confused about the difference between being connected verses stand alone.

    Thanks for your input

    Allie

  6. #6
    Join Date
    Mar 2001
    Posts
    144
    Your IP and hostname get "activated" by a network connection so if your nic is not "activated", ie. connected, then you will not be able to connect to your database because it can't look up your ip address through the network.

    I had something similar in my other job. A small database sitting on my laptop. The way around this is to connect to the database as local (bequeath local) which I believe is available with 7.3.3.

    Here's a doc from Oracle on this :

    http://technet.oracle.com/doc/window...a55909/ch2.htm

    hth.

    Rui Amaral
    Oracle DBA - OCP 7, 8, 8i


    [Edited by ramaral on 07-18-2001 at 11:23 AM]

  7. #7
    Join Date
    Feb 2001
    Location
    Scotland
    Posts
    200
    Hi there,

    I have just been told that to get a connection to my local database while disconnected from the network I should add an IPC entry into my LISTENER file.

    Unfortunately this was all I was told and I haven't been able to get it to work, I have added a copy of my LISTENER file.

    If anyone can help I would be most grateful.

    ################
    # Filename......: listener.ora
    # Node..........: local.world
    # Date..........: 24-MAY-94 13:23:20
    ################
    LISTENER =
    (ADDRESS_LIST =
    (ADDRESS=
    (PROTOCOL= IPC)
    (KEY= oracle.world)
    )
    (ADDRESS=
    (PROTOCOL= IPC)
    (KEY= ORCL)
    )
    (ADDRESS=
    (COMMUNITY= NMP.world)
    (PROTOCOL= NMP)
    (SERVER= tonnera)
    (PIPE= ORAPIPE)
    )
    (ADDRESS=
    (COMMUNITY= TCP.world)
    (Host = tonnera)
    (PROTOCOL= TCP)
    (Port= 1521)
    )
    (ADDRESS=
    (COMMUNITY= TCP.world)
    (Host = 127.0.0.1)
    (PROTOCOL= TCP)
    (Port= 1521)
    )
    (ADDRESS=
    (COMMUNITY= TCP.world)
    (Host = tonnera)
    (PROTOCOL= TCP)
    (Port= 1526)
    )
    (ADDRESS=
    (COMMUNITY= SPX.world)
    (PROTOCOL= SPX)
    (Service= tonnera_lsnr)
    )
    (ADDRESS=
    (COMMUNITY= ipc.world)
    (PROTOCOL= SPX)
    (Service= tonnera_lsnr)
    )
    )
    STARTUP_WAIT_TIME_LISTENER = 0
    CONNECT_TIMEOUT_LISTENER = 10
    TRACE_LEVEL_LISTENER = OFF
    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = test)
    )
    (SID_DESC =
    (SID_NAME = eolq)
    )
    )

    PASSWORDS_LISTENER = (oracle)


  8. #8
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = your_oracle_home)
    (PROGRAM = extproc)
    )

    Good luck,
    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