ORA-12230

[alison]

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

[marist89]

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)
)
)

[alison]

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

[shawish_sababa]

Hi

is your listener up? check that.

[alison]

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

[ramaral]

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]

[alison]

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)

[sambavan]

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