Solved

Oracle Financials with Oracle 8.0

Posted on 1998-02-18
6
845 Views
Last Modified: 2012-05-04
Hi,

Can I use Oracle Financials 10.6 with Oracle 8.0.  In my machine i have Financials and Developer 2000 loaded and also Oracle 8.0 (Single user version). I am not able to run developer 2000 or Financials. When clicked on Financials, the Financials screen appears with the following error:
APP 01516 : Invalid application username, password or database.
Username:applsyspub
Password:pub
Database:objdb

When trying to connect to Database in Forms, gives the error:
ORA-12154:TNS:Could not resolve service name
ORA-03121:no interface driver connected. function not performed.

Can anyone help to resolve this problem?

Thanks,
ysgr
0
Comment
Question by:ysgr
6 Comments
 
LVL 3

Expert Comment

by:poncejua
ID: 1082389
Hi ysgr,

When logging into the applications from the 10SC Client you've got the error APP-01516: invalid username password
 
 
Problem Explanation:
====================
 
TNSNAMES.ORA
OACONFIG.ORA
ORACLE.INI
--> all these files in order.
 
Access to SQL*Plus when LOCAL=TNSNAMES
 
No access to SQL*Plus when LOCAL=ORACLE.INI
 

Solution Description:
=====================
 
Perform the following:
 
   1. From the desktop, open the properties for the Icon that runs            
     applications
 
   2. For the command line put:
 
      <O_Drive>:\ORAWIN\BIN\AIAP24.EXE
            <A_Drive>:\apps10\fnd75\forms\us\FNDSCSGN.FMX
            <gwyuid>@<connect_string>
            FNDNAM=<fndnam>
      where:
         <O_Drive> is the local or network drive where ORAWIN is.
         <A_Drive> is the local or network drive where APPS10 is.
         <gwyuid> is the public account userID/password
         <connect_string> is the Two_Task or TNS names Alias
         <fndnam> is the Applications APPLSYS userID
 
 
Note:
 
      Ensure that within the oracle.ini file, the 'local'                    
       parameter is set to the correct <machine_name><oracle_sid>

I hope this helps you, if not please do not hesitate to contact me directly to my e-mail address: jmponcemartinez@hotmail.com

Best Regards,

Juan Manuel Ponce Martinez
DBA - Buenos Aires - Argentina
0
 

Author Comment

by:ysgr
ID: 1082390
HI,

i tried your suggestion, was not able to  get the <oracle_sid>, But putting all the lines in properties still gives the same error. anyway thanks for your help.

gurushree
0
 
LVL 2

Expert Comment

by:manand062397
ID: 1082391
Are you able to connect from sqlplus?
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 1

Accepted Solution

by:
csomu earned 50 total points
ID: 1082392
Hi ysgr,

Your problem is Sqlnet has not been properly configured.You actually don't need Sqlnet as it is on the same Machine, but then your LOCAL parameter in oracle.ini and oaconfig.ora should be set properly , i.e., it should point to the ORACLE_SID of your financials database.

To avoid all this you can configure your sqlnet using sqlnet easy configuration tool and then use that alias name or database name ,while connecting from forms.Then you should use that alias name as the value for LOCAL parameter in oracle.ini and oaconfig.ora

Regds
Somu
0
 

Author Comment

by:ysgr
ID: 1082393
Hi,

Thanks for ur suggestion.
I tried configuring using SQLNET easy configuration., but even then gives the same error,
APP 01516 : Invalid application username, password or database.
Username:applsyspub
Password:pub
Database:objdb

I added a new alias using SQLNET easy config, the alias name created is objdb, the protocol TCP/IP, and i used the default SID ORCL, while adding the alias.In INI LOCAL= objdb.  Is anything missing or wrong in adding alias?  

ysgr
0
 
LVL 1

Expert Comment

by:csomu
ID: 1082394
Hi ysgr,

Yes have made a mistake.The ORACLE SId is not ORCL if it is a demo version of Oracle Applications then the SID is GLOBAL otherwise if it is a production version it depends on what name you gave while creating the database.

So make sure you give the right name for the ORACLE_SID in the sqlnet easy config.

Regds
Somu
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to recover a database from a user managed backup

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question