on 04-15-2009 12:01 PM
My SAP BI system is Runing on AIX server and oracle is on Windows....
I want extract data from oracle using DB Connect...
I have tried through DBCO.... I have given all the input parameters like
DB Connection
DBMS
User Name
DB password
Conn. info
Getting Error in --> SM21
Database error 12154 at CON
ORA-12154: TNS:could not resolve the connect identifier
specified
Need Help -- with all the necessary Steps
waiting for the response
Thanks in advance
>Bee
Hi Bibekanand Biswal,
Have u maintained the source system connection details properly in the TNSNAMES.ORA file ???
Basically this file will reside in the /oracle/BSP/920_64/network/admin path. Here we need to maintain
Host IP and name like the below format.
FXCS1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.16.51.12)(PORT = 1521))
)
(CONNECT_DATA =
(SID =FXCS1)
(SERVER = DEDICATED)
)
)
If u have already maintained the above things Please check with basis to check the connectivity and ask him to
provide the full access to that source system.
Regards,
Vara Prasad
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Goto Source System tab and check if your Oracle source systems get connected by clicking Check from the context menu.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.