In my working environment windows Server R2, I couldn’t connect with oracle database using DSN name (Which we are creating using Administrative Tool -> Data Source (ODBC) -> System DSN in OBIEE 10g) of the schema.
I am sharing the workaround that how I have imported the tables into Administration tool in OBIEE 18.104.22.168.0 in Oracle database environment.
I went to below directories with my installed OBIEE 11g version and copied the oracle credential in the file of tnsnames.ora into this folder.
I have opened the Administration Tools and created the Test.rpd and selected ‘Import Metadata’ from file Menu.
Here I have given the following details to connect with oracle database.
Import Type: Local Machine
Connection Type: OCI 10g /11g
DSN: ORCL ( Oracle Service Name)
User Name: SH (The schema that you want to import into the physical layer)
Password: Schema password
You can view the below screenshot for your reference.
By clicking 'Next', the schema has to be connected and imported into the physical layer of Administration Tool.
If you want connect with the remote server oracle database system then we have add the corresponding machine name, service name and IP address in tnsnames.ora file. You can view the below screen shot for you reference.
But MySQL database is connecting with DSN Name with the procedure we are following to import the metadata in OBIEE 10g