Oracle Connection Error

hi
i'm an oracle cleint
we have in the company many databases on many servers
some of them 10g , 9i , but one of them only 11g
i can connect to all of them
except "Orcl8" the one installed on 11g server
in spite it is included in the tns_names
also , i can connect to it via : Toad , but as direct connection via HOST
but when i'm trying to connect to it via oracle forms 6i or reports 6i , or even sql_plus
it fail
how do i resolve this issue
please note :
the mensioned 11g database "Orcl8"  has same : user_name , SID of another one "Orcl5" on 10g
is it may reason of the failure ?
because when i'm connectiong via Toad , "Orcl5" underlisted in the available database names
but for "orcl8" it is not underlisted , but it connect to it via its host & sid
NiceMan331Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

johnsoneSenior Oracle DBACommented:
What version of Oracle is installed on the client?
What is the error you are receiving?

My guess is that you are going to need 11 installed on the client side.  Forward compatibility is not guaranteed with Oracle.  You can definitely connect to a 10 database with the 11 software, and I believe you can connect to 9 as well.
NiceMan331Author Commented:
What version of Oracle is installed on the client?
i installed database 11.2
but no dvelopper installed , i'm using copied folder of oracle 6i ( not installed in my machine , it only copied )
What is the error you are receiving?
ORA-28040 No matching authentication protocol
johnsoneSenior Oracle DBACommented:
I would think that you need to actually install it.  Copying the software tree just gets the software and not the registry settings.

A quick search turns up this piece of documentation -> http://docs.oracle.com/cd/E11882_01/network.112/e10835/sqlnet.htm#NETRF196  That may apply as you are using an old version of Forms.
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

slightwv (䄆 Netminder) Commented:
Getting 6i to connect to 11g is starting to stretch things.

Software becomes obsolete for a reason...  It cannot remain backward compatible forever.

If you are on the correct 6i patchset, it looks like you might be able to connect to 11g as long as the database chracterset isn't AL32UTF8.

This thread seems talk about everything:
https://community.oracle.com/thread/2406827
NiceMan331Author Commented:
i'm sorry
i mistake
the database is 12, not 11
and the nls_language  is AL16UTF16 as per details
and i don't have permission to alter it
NLS_RDBMS_VERSION	12.1.0.1.0
NLS_NCHAR_CONV_EXCP	FALSE
NLS_LENGTH_SEMANTICS	BYTE
NLS_COMP	BINARY
NLS_DUAL_CURRENCY	$
NLS_TIMESTAMP_TZ_FORMAT	DD-MON-RR HH.MI.SSXFF AM TZR
NLS_TIME_TZ_FORMAT	HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_FORMAT	DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_FORMAT	HH.MI.SSXFF AM
NLS_SORT	BINARY
NLS_DATE_LANGUAGE	AMERICAN
NLS_DATE_FORMAT	DD-MON-RR
NLS_CALENDAR	GREGORIAN
NLS_NUMERIC_CHARACTERS	.,
NLS_NCHAR_CHARACTERSET	AL16UTF16
NLS_CHARACTERSET	WE8MSWIN1252
NLS_ISO_CURRENCY	AMERICA
NLS_CURRENCY	$
NLS_TERRITORY	AMERICA
NLS_LANGUAGE	AMERICAN

Open in new window

NiceMan331Author Commented:
but look
here is the specification of the "orcl5" , which i can connect to it

NLS_RDBMS_VERSION	12.1.0.1.0
NLS_NCHAR_CONV_EXCP	FALSE
NLS_LENGTH_SEMANTICS	BYTE
NLS_COMP	BINARY
NLS_DUAL_CURRENCY	$
NLS_TIMESTAMP_TZ_FORMAT	DD-MON-RR HH.MI.SSXFF AM TZR
NLS_TIME_TZ_FORMAT	HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_FORMAT	DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_FORMAT	HH.MI.SSXFF AM
NLS_SORT	BINARY
NLS_DATE_LANGUAGE	AMERICAN
NLS_DATE_FORMAT	DD-MON-RR
NLS_CALENDAR	GREGORIAN
NLS_NUMERIC_CHARACTERS	.,
NLS_NCHAR_CHARACTERSET	AL16UTF16
NLS_CHARACTERSET	WE8MSWIN1252
NLS_ISO_CURRENCY	AMERICA
NLS_CURRENCY	$
NLS_TERRITORY	AMERICA
NLS_LANGUAGE	AMERICAN

Open in new window


i quess that the problem is in the SID Name , because they have same names "orcldb"
same user name , same passowrd
only the host is different
johnsoneSenior Oracle DBACommented:
Can we take a step back?  I'm getting confused.

Let's remove Forms from the equation.

There are 2 databases orcl5 and orcl8.  You have 11g client installed (not copied) on your machine.  Using SQL*Plus you can connect to orcl5, but when you try to connect to orcl8 you get ORA-28040.

Same SID on 2 different hosts with the same user and password combinations is not an issue.

Is all that correct?  If so, please post the tns entries for both databases.

Honestly, I think trying to get Forms 6 to connect to Oracle 12, isn't going to happen.  Way too many versions in between there.
NiceMan331Author Commented:
Johnson , yes every thing is correct as what you say , today our DBA did something in the server , then I success to connect , but he didn't tell me what he actually adjust there , any how I just need to understand the issue , then do you advice to install forms 11 in my PC ?
johnsoneSenior Oracle DBACommented:
If you are working on new development, I would go with the latest version of forms.  Whatever that is.  I haven't actively used it in many years, so I'm not sure what the current version is.

If you are trying to run forms generated in forms 6, then you'll have to use that version.  I highly recommend moving to a newer version as soon as you can.  It will be quite a conversion since you are so many levels behind.  There are conversion tools that come with forms, but it won't get everything.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
NiceMan331Author Commented:
Yes you are correct , some forms must be run under 6i , some of them not necessary , now if I installed  the latest version , I'm worry if the forms built under 6i would not work under the latest one
johnsoneSenior Oracle DBACommented:
No, they would not.  They would need to be recompiled.  The upgrade guide has the details on how to do that.  My guess is there is going to be quite a bit of manual process to get forms that old running on the latest version.  But, you are going to have probably just as many issues with getting forms 6 connecting to a 12 database.

You have to realize that you are working with a version of forms that has to be at pushing 15 years old.  You seem to be upgrading your databases, why aren't you following suit on the forms?
NiceMan331Author Commented:
That's because the ERP we are using in the server is forms 6i , and I have to use forms 6i to develop any thing , but some forms is not related to the ERP and I can use an upgraded one
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.