Last updated on JANUARY 15, 2021

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.3 and later

A325351 PDF Oracle7 Server Administrator's Guide, Release 7.3 A325361 PDF Oracle7 Server Application Developer's Guide, Release 7.3 A325381 PDF Oracle7 Server SQL Reference, Release 7.3 A325391 PDF Oracle7 Server Messages, Release 7.3 A325401 PDF Oracle7 Server Migration, Release 7.3. This technote identifies a possible cause and resolution to Oracle. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3(or.

Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Asset Liability Management (ALM)
Oracle Financial Services Enterprise Performance Management (EPM)

Symptoms

On OFSAA 7.3.5, after moving OFSAA to a new domain, there are issues starting services. Domain changed from <hostname_old> to <hostname_new> and changes were made at all relevant places (all required ofsaa_config tables and in lookupservices.xml and dynamicservices.xml and other files related to am.sh and .cfg)
New .ear , .war files are deployed on Weblogic server after deleting old installations. However, the Revappserver log still shows the incorrect old server name:

ERROR
[REVELEUSLOG] Dec 29,20 13:18:48 : [NEWSERVICEMASTER]Get Service Port :: REMOTE:10 SMS available at [<OLD HOSTNAME>:9999]
[REVELEUSLOG] Dec 29,20 13:18:48 : [NEWSERVICEMASTER]Port = 9999
[REVELEUSLOG] Dec 29,20 13:18:48 : [NEWSERVICEMASTER] NEWMSG Getting ip for [SC:10][ST:6][SST:1][Oper:4][Version:0][EF:false][D:null][S:null][U:null][PT:6][P:nullnull]
[REVELEUSLOG] Dec 29,20 13:18:48 : [NEWSERVICEMASTER]Get Service IP ::REMOTE:10 SMS available at [<OLD HOSTNAME>:9999]
[REVELEUSLOG] Dec 29,20 13:18:48 : [NEWSERVICEMASTER]IP = <OLD HOSTNAME>
[REVELEUSLOG] Dec 29,20 13:18:48 : [NEWSERVICEMASTER]GETTING IF SERVICE IS LOCAL : DSN = *** Service code:10
[REVELEUSLOG] Dec 29,20 13:18:48 : [NEWSERVICEMASTER]GETTING IF SERVICE IS LOCAL : DSN = *** LOCAL ?? false
[REVELEUSLOG] Dec 29,20 13:18:48 : [NONE]NEWMSG CHECKING IF THE SERVICE ISLOCAL AFTER THE REASSIGNMENT.false
[REVELEUSLOG] Dec 29,20 13:18:48 : [NEWSERVICEMASTER]GETTING IF SERVICE IS LOCAL : DSN = *** Service code:10
[REVELEUSLOG] Dec 29,20 13:18:48 : [NEWSERVICEMASTER]GETTING IF SERVICE IS LOCAL : DSN = *** LOCAL ?? false
[REVELEUSLOG] Dec 29,20 13:18:48 : [NONE][DirectCommImpl] Connecting to <OLD HOSTNAME>:9999
[REVELEUSLOG] Dec 29,20 13:18:48 : [SOCKETWRAPPER]Error in setting up I/O streams with <OLD HOSTNAME>:9999java.net.UnknownHostException: <OLD HOSTNAME>
[
nohup.out from services (/u01/app/ofsaa/services) shows this error:
[SMSSERVICES]Error occurred while getting MASTER DSN Name
java.lang.Exception: Error occurred while getting MASTER DSN Name

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

Symptoms

Cause

Solution

References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums SQL Server 2005 Forums SSIS and Import/Export (2005) Oracle client and networking components

Oracle Version 7.3 Download

Author Topic Pherkad Starting Member 23 Posts Posted - 2007-04-30 : 09:50:23 hi all. In my SSIS project, i have to retrieve data from an oracle 10g database. On my personal laptop it works, but on our test-env i get the error below, when i try to test my connection to the oracle datasource. Could this because i have oracle XE installed yet on my personal laptop, and it is not installed on the computer of our test environment where the SSIS runs? If that's the reason, it sounds very strange, because it would mean i have to install an oracle environment also on the computer with SSIS, just to make a connection to another oracle server.. Error: TITLE: Connection Manager ------------------------------ Test connection failed because of an error in initializing provider. Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these components are installed. ------------------------------ BUTTONS: OK ------------------------------ Pherkad Starting Member Why is zimos voice auto tunedgeekstree. 23 Posts Posted - 2007-04-30 : 10:12:52 is it maybe the oracle instant client that i need to install on the SQL Server PC ? http://www.oracle.com/technology/software/tech/oci/instantclient/index.html eyechart Master Smack Fu Yak Hacker 3575 Posts Posted - 2007-04-30 : 10:20:58 you need to install the Oracle client first. INstant client will probably work, but I have not used it with SSIS or even with DTS. make sure you also get a copy of your tnsnames.ora so you can resolve the names of your oracle instances. -ec Pherkad Starting Member 23 Posts Posted - 2007-04-30 : 10:31:40 think i have no other choice then using the instant client. on this page the 10g standard client is only for PowerPC/Linux. Not for windows. http://www.oracle.com/technology/software/products/database/oracle10g/index.html http://www.easysoft.com/support/kb/kb00612.html or am i wrong? eyechart Master Smack Fu Yak Hacker 3575 Posts Posted - 2007-04-30 : 10:40:23 yeah, you are wrong http://www.oracle.com/technology/software/products/database/oracle10g/htdocs/10201winsoft.html -ec Pherkad Starting Member 23 Posts Posted - 2007-04-30 : 10:53:20 thanks !!!! but.. euhmmm.. 400Mb for the client? will it be such a heavy program / installation? just for allowing my server to contact a pc where an oracle runs???? how comes it's such a huge download? eyechart Master Smack Fu Yak Hacker 3575 Posts Posted - 2007-04-30 : 10:55:58 quote:Originally posted by Pherkad thanks !!!! but.. euhmmm.. 400Mb for the client? will it be such a heavy program / installation? just for allowing my server to contact a pc where an oracle runs???? how comes it's such a huge download? it just is try the instant client then. -ec Pherkad Starting Member 23 Posts Posted - 2007-05-02 : 04:43:50 now i've installed the oracle XE on a pc, called EVO610. on my pc with SSIS I installed the Oracle 10g runtime client as mentioned above. when i now try to add a Datasource (with as provider: .Net ProvidersOracleClient Data Provider), I get the error below.. (for servername, i fill in EVO610 - thus the machinename, and as user and pwd I fill in SYS and the pwd i created. error: Test connection failed because of an error in initializing provider. ORA-12514: TNS:listener does not currently know of service requested in connect descriptor what can this be? Pherkad Starting Member 23 Posts The one thing gary keller pdffasrsin. #Title:Toontrack EZDrummer application + all expansion kits crack #Tags:toontrack,ezdrummer,application,all,expansion,kits Toontrack EZDrummer application + all expansion kits crack Rating Related Downloads Downloads Toontrack.dfh.EZdrummer.VSTi.RTAS.v1.0.4.Update.incl.KeyGen-BEAT keygen 8584. Ezdrummer cracked downloadanimationsupport. EZdrummer 2 has a completely new mixer and collection of effect chain presets, both for the modern and the vintage setup. The effect engine is based around the numerous quality effects in Toontrack’s widely acclaimed EZmix 2. Each setting includes a back-end of various effect chains including the likes of compressors, reverbs, delays and EQs. Posted - 2007-05-02 : 08:19:03 damn what a mess. now it finally works. with the instant client alone, it doesn't work (no tnsnames.ora,.. was created). 1)i installed first the instant client, thereafter the runtime (both are in the big installation file above) 2)set system variables TNS_ADMIN and ORACLE_HOME manually (unbelievable that you have to do it manually) %ORACLE_HOME%=C:oracleproduct10.2.0client_2 %TNS_ADMIN%=C:oracleproduct10.2.0client_2NETWORKADMIN 3)insert in the tnsnames.ora file (of the client pc): EVO610 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.2.1.114)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = XE) ) ) #the service_name is what is configured under DEFAULT_SERVICE_LISTENER on the server pc, in the file C:oraclexeapporacleproduct10.2.0serverNETWORKADMINlistener.ora (if tnsnames are well configured and able to connect to the server, you can check in advance with cmd>tnsping xxx) 4)client pc: > odbc client administrator > add new system dsn > after clicking add, you will find a newly added 'instantclient' driver. there you can connect with the TNS name above. 5)now you can add a new data sourece in SSIS: provider: native oleDB / native ole db provider for oracle if someone has remarks or questions, don't hesitate. it was a hell to find this all out myself, under extreme time-pressure, in a jungle of ducumentation and with few Oracle Administration knowledge. Also thanks to eyechart for giving me the link to download the full 10g Client.. I don't understand why it's not on the main download page of 10g (the link in my post above).. I still wonder how you found that page. Pherkad Starting Member 23 Posts Posted - 2007-05-02 : 08:39:24 quote:I don't understand why it's not on the main download page of 10g (the link in my post above).. I still wonder how you found that page. OK, i found that you just pointed me to the enterprise/standard edition, which included a separate client runtime installation.. (it's very confusing that docs say: download the client, while you have to know that instead of downloading the client, you have to download the full installation.. and within the full installation, only install the runtime client (and/or instant client) component. SRA Starting Member 1 Post Posted - 2010-11-23 : 14:38:46 Hi - The Instant Client allowed Windows to add a Microsoft ODBC for Oracle driver. So thanks for that info. When I tried to create an Oracle Data Source Connection, I get an error that says: 'This Oracle DSN has been configure wiht an unsupported ODBC driver (version 2.575.1132.0 (xpsp.080413-0852)) Please update the ODBC driver to version 9.2.8.0 and above.' The InstantClient was version 11.2.0.1.0. Anyone know what this is all about? Thanks

Subscribe to SQLTeam.com

Oracle Version 7.3 Client Software

Resources