-
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
Akash
-
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
-
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.
-
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
Akash
-
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 ??
-
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)
)
)
Akash
-
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
Thanx
Sam
Life is a journey, not a destination!
-
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
Akash
-
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
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|