Oracle 12154 Error - BSI TaxFactory 9.0.d

the_ratzenator
the_ratzenator used Ask the Experts™
on
Screenshot of Oracle 12154 error
I am having an issue trying to connect the BSI TaxFactory client to a remote database and according to my documentation, everything is correct. I am not, by any means whatsoever, an Oracle guru, nor do I want to be. I really need to get this product installed for some customers so they can get their payroll processed next week. Do any of you Oracle experts out there know what is going on?

By the way, my tnsnames.ora and sqlnet.ora files are correct according to the doc. Also, BSI TaxFactory version 8 is also installed on this system, but it was explained to me that this should have nothing to do with the error and that they both can be installed on the system simultaneously without issue.

Thanks everyone.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
Every oracle install needs their own tnsnames.ora file.  Make sure the Oracle product install BSI uses has its own file.

There is a way for a 'common' one but it is more confusing so I'll not post it since you stated you want minimal Oracle exposure.

Author

Commented:
there are multiple entries in the tnsnames.ora file due to multiple oracle based programs installed on the system. BSI uses one of the entries.
Top Expert 2011

Commented:
- when i click on the images above, it display a wrong image. there are many steps to check on ORA12154 error that you can go thru and i listed some as follows:
http://orafaq.com/wiki/ORA-12154
http://www.techonthenet.com/oracle/errors/ora12154.php
http://ora-12154.ora-code.com/

"Also, BSI TaxFactory version 8 is also installed on this system"
- does BSI TaxFactory version 8 able to connect to the same database? or it uses a different database?

"multiple entries in the tnsnames.ora"
- my suggestion is to check the syntax and verify that the databasealias entry for BSI TaxFactory  is correctly defined the same as used in the application. also search for tnsnames.ora in you computer incase there are multiple tnsnames.ora file as pointed by slightwv. you might edit a different tnsnames file.
Build an E-Commerce Site with Angular 5

Learn how to build an E-Commerce site with Angular 5, a JavaScript framework used by developers to build web, desktop, and mobile applications.

Author

Commented:
okay i will look into your suggestions and will let you know what i find. thanks

Author

Commented:
here is a view of System DSN's from the ODBC Data Source Administrator     System DSN's from the ODBC Data Source Administrator
I did find other tnsnames.ora files one in the: "C:\oracle\ora92\network\ADMIN" and a few in the following location: "C:\oracle\product\10.2.0\client_1\NETWORK\ADMIN". the instructions that I got for BSI TaxFactory 9.0.d tells me to setup and configure the TF90-DEV System DSN that you see in the screenshot above.

Here is what the PATH variable is set to in this system:

PATH=C:\oracle;C:\oracle\ora92\bin;C:\Program Files\Oracle\jre\1.3.1\bin;C:\Prog
ram Files\Oracle\jre\1.1.8\bin;C:\oracle\product\10.2.0\client_1\bin;C:\WINDOWS\
system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Common Files\Roxio
 Shared\DLLShared\;C:\Program Files\Common Files\Roxio Shared\DLLShared\;C:\Prog
ram Files\Common Files\Roxio Shared\9.0\DLLShared\;C:\Program Files\QuickTime\QT
System\;C:\PROGRA~1\COMMON~1\Kronos\ODBC520;c:\Program Files\Microsoft SQL Serve
r\90\Tools\binn\;C:\Program Files\Windows Imaging\

I am assuming the tnsnames.ora file that I am supposed to modify is the one that exists in "C:\oracle\product\10.2.0\client_1\NETWORK\ADMIN" since the TF90-DEV System DSN is using the "Oracle in OraClient10g_home1" driver, which I did and still no luck. I test the connection and I keep getting the same following error:

Unable to Connect
SQLState=08004
[Oracle][ODBC][Ora] ORA-12154: TNS:could not resolve the connect identifier specified

Also, here is the sqlnet.log contents:

***********************************************************************
Fatal NI connect error 12560, connecting to:
 (DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=C:\Program Files\BSI\TaxFactory 9.0.d\Tf.exe)(HOST=computer_name)(USER=user_name))))

  VERSION INFORMATION:
      TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
      Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production
  Time: 09-AUG-2011 08:43:35
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12560
    TNS-12560: Message 12560 not found; No message file for product=NETWORK, facility=TNS
    ns secondary err code: 0
    nt main err code: 530
    TNS-00530: Message 530 not found; No message file for product=NETWORK, facility=TNS
    nt secondary err code: 126
    nt OS err code: 0
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
The 12154 means what I've been saying it means.  Either using the wrong tnsnames.ora file or the alias you need is not in it.

I'll worry about the 12560 after we fix the 12154.

Author

Commented:
Chill out slight!!

I am looking into it

Author

Commented:
certain programs on the system use Oracle 9i and one uses 10 can I am going to reinstall the driver, but do I have to install both or can I just install 10 and recreate my Data Sources to point to the 10 driver?

Author

Commented:
okay, i just uninstalled both the Oracle 9 and 10, reinstalled 10. I copied over from a known working system the sqlnet.ora and the tnsnames.ora files, recreated the data sources, i test the connection and it is now connecting succesfully.

Author

Commented:
How do i get rid of programs pointing to the old "Oracle in OraHome92" driver if it does not want to be removed. Registry maybe?

Author

Commented:
nevermind, I found it. I deleted the registry instances from the following location that pointed to the old data source records:

HKEY_LOCAL_MACHINE\SOFTWARE\ODBC
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
I'm chill.  You just reposted the same error in http:#a36337190 "[Oracle][ODBC][Ora] ORA-12154: TNS:could not resolve the connect identifier specified".

I wish I had been around before you uninstalled/installed everything.  It really wasn't necessary.  I'm afraid you might have introduced 'new' issues.

So,  all that done, where do we stand?

Author

Commented:
this is where I stand -  I f-ing hate Oracle.

Okay, now that I got that out I got the TaxFactory issue taken care of using Oracle 10 client. However, I found out why they were using two different Oracle clients (9 and10) because they are using different programs that require access to a local database server and a remote one in another state. So, the sqlnet.ora file is  configured for the oracle 9i client for the remote db server. Is there a way to tell the sqlnet.ora that multiple domains need to be accessed? Also, I keep getting an error when installing oracle 9i about Microsoft Transaction Service. This is ridiculously annoying. Thanks
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
Don't blame Oracle for a bad implementations.

We find SQL Server just as confusing....


It has been many years since I messed with Oracle domain structures but I believe you can probably do all this with a single client unless there is some version specific reason.

I believe the sqlnet.ora file just sets the 'default' domain.  If memory serves you can manually configure the complete domain in the tnsnames.ora file.

For example if names.default_domain is set to:  someremote.domain.for.something

you should still be able to fully qualify the db alias in the tnsnames.ora file:
somealias.some.domain = ...


I'm not running domains right now so cannot test this for you.  Just going from memory.

Author

Commented:
I keep getting "the specified key was not found while trying to GetValue" when installing the Oracle Services for Microsoft Transaction Server. Do I even need this? This is not an MTS server, it is a client but the documentation I have says to install it to use the Oracle MTS Recovery Service
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
Never used the MTS Recovery Service but what you say makes sense.  If it isn't an MTS server not sure why you would need something related to it.

I'll be glad to review the docs if you can provide the link for the version you are following and I'll see if I can make sense of it.

I'm still not sure you need both client versions.

Author

Commented:
Okay, i deleted the oracle registry entry from HKLM\Software\Oracle and that took care of the MTS error. Honestly, I think I have everything under control now. I am going to keep this open still in case anything comes up. Thanks Slight, I didnt mean to come off like an ass but I got these payroll folk over here with a look of trepidation on their faces.
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
No need to apologize.  We've all had those days...

Once when I had a down system and had to completely had to rebuild a machine I had another department lead constantly bothering me with the proverbial 'how much longer'.

I kept telling her, it will take as long as it takes.

Thinking it would change my answer, she brought my manager down to the data center and had him ask me, my response:

I turned and looked directly at my manager (department head standing right beside him) and said:  I would have probably been done by now if I didn't have to stop every 5 minutes when she (pointing to head) asks me.

Believe it or not, I kept that job!  The 'head' was a little annoying to others... I think my manager actually liked it...

Author

Commented:
WAIT!! How can I get mulitple domains to be accessed by on Oracle client? Is there a way I can edit the sqlnet.ora file to do this so we do not have multiple Oracle client versions running? thanks

Author

Commented:
I know I already asked that but I wanted to reiterate
Most Valuable Expert 2012
Distinguished Expert 2018
Commented:
>>How can I get mulitple domains to be accessed by on Oracle client?

Tried to explain that in http:#a36345628

Still going from memory:  The sqlnet.ora file specifies the 'default' domain.

For a test, pick one of the installs (I suggest 10g).  Comment out the names.default_domain from the sqlnet.ora files.

Hard code them in the tnsnames.ora file.

For example if the default domain in the 9i install is 'myserver.com' and the tnsnames.ora entry in the 9i install is 'mydatabase'.

In the 10g sqlnet.ora file, comment out the default domain in the sqlnet.ora file.  In the tnsnames.ora file add and entry for:

mydatabase.myserver.com = (
... the rest of the correct info
)

Author

Commented:
i got it working. I just had to put the fully qualified host name in the tnsnames.ora file to point to the DB server in the other domain not listed int he sqlnet.ora file. I will award you points slightwv somewhat leading me in the right direction.

Author

Commented:
because i felt like it goddammit

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial