Ora-12154

[akash]

Hi guys
I am trying to run form6i. When I used Datablock Wizard
to enter the table name, I am getting ORA-12154: TNS: could
not resolve service name.
Could any one tell me why I am getting this error and how
to resolve this.

Thanks

[shawish_sababa]

Hi

you get "ORA-12154: TNS: could not resolve service name. " becouse your:
1. db is not active.
2. problems in your tnsnames.
3. the registry definitions are not correct.

1. ask your dba if the db is up and running.
2. go to satrt>run and write "tnsping SID (insert the name of your instance)" if you have problems there check yo tnsnames. if o.k. then go to phase 3.
3. run regedit, look at your forms oracle home .look at the value in ORACLE_HOME. you find there the dirction for the tnsnames.ora the forms is useing. i think you need to change it.

hope this helps

[JMac]

Also check the Host String you're using to connect to the database - a mistyped host string means SQL*Net or Net8 can't find the database! It also returns this error.

[akash]

Hi
I am working on NT, Oracle 8.1.5, Forms 6i.
Database is up, I can go to SQL prompt and I can do all the
DBA stuff, like creating users etc. etc.

When I am typing TNSPING ZOOM
It is not showing anythig.

My TNSNAMES file look like this
# C:\ORACLE\ORA81\NETWORK\ADMIN\TNSNAMES.ORA Configuration File:C:\Oracle\Ora81\network\admin\tnsnames.ora
# Generated by Oracle Net8 Assistant

ZOOMDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = NMP)(SERVER = VCS1)(PIPE = ORAPIPE))
)
(CONNECT_DATA =
(SERVICE_NAME = zoomdb)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)


NOW WHAT??

Thanks

[pipo]

1) try tnsping zoomdb, not zoom, your entry is called zoomdb
2) do you specifically need to use ORAPIPE and NMP ??? can't you use TCP ???
3) what is in the listener.ora file ??

[akash]

Hi Guys
I just check Oracle_Home.

ORACLE_HOME "C\ORACLE\ORA81\D2K"
ORACLE_HOME_NAME "DEVELOPER"
SHARED_ORACLE_NAME " C:\ORACLE\ORA81\D2K"

tHANKS

[akash]

Hi Pipo

I tried TNSPING ZOOMDB
But nothing is coming.

My listner.ora is ...

# C:\ORACLE\ORA81\NETWORK\ADMIN\LISTENER.ORA Configuration File:C:\Oracle\Ora81\network\admin\listener.ora
# Generated by Oracle Net8 Assistant

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = null)(PORT = 1521))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\Oracle\Ora81)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = zoomdb)
(ORACLE_HOME = C:\Oracle\Ora81)
(SID_NAME = ZOOM)
)
)

[sambavan]

Check your TNSNAMES.ora file under ORACLE_HOME/network/admin and confirm that you have a tns service entry in there for your zoomdb. If not create one and try again.

BTW, check your SID_NAME. Is it ZOOM or ZOOMDB?

Sam

[akash]

Hi Sambavan
Database Name is ZOOMDB and Sid is ZOOM

Could you please tell me how to create TNS names service.
I have given my TNSNAMES.ora file

Thanks

[sambavan]

Oops ... My mistake. Yeah you do have the tnsnames.ora file. What I would like you to do is that check for the tnsnames.ora files under the Forum6i home. Do you have the Forum6i installed under the same home as that of the server? I hope not. Any how. If they are under different home directories, I'ld want you to check the

FORM6i'HOME/network/admin/tnsnames.ora and make sure that they have entries in there for the database instance. If not add the entries and try again. Normally, all the oracle applications would have a tnsnames.ora file under their installation. That is what would be used to connect to the database instances, not the ones under other homes. So, you would have to make sure that they are configured appropriately.

Please let me know of the status.
Sam