Connecting to Oracle stage-Error

[bala_135]

Hi,

I have Oracle 10g installed.I could able connect through Dyanamic RDBMS,ODBC and used the orchbutil utility to import metadata but i cannot view data through Oracle Enterprise edtion stage i am getting the following error.

#I TOSH 000002 15:30:24(001) <main_program> orchgeneral: loaded
##I TOSH 000002 15:30:24(002) <main_program> orchsort: loaded
##I TOSH 000002 15:30:24(003) <main_program> orchstats: loaded
##W TDOR 000160 15:30:24(004) <main_program> An NLS map <ISO-8859-1> is specified, but NLS_LANG is not set. The NLS map must be set to an ICU codepage which is equivalent to the character set specified by NLS_LANG
>##E TDOR 000008 15:30:24(006) <Oracle_Enterprise_0> Missing server name. Can't connect
>##E TDOR 000140 15:30:24(007) <Oracle_Enterprise_0> APT_OraReadOperator: connect failed.
>##E TOPK 000000 15:30:24(010) <_PEEK_IDENT_> Input dataset does not have field: "EMPNO"
>##E TOPK 000000 15:30:24(011) <_PEEK_IDENT_> Input dataset does not have field: "ENAME"
>##E TOPK 000000 15:30:24(012) <_PEEK_IDENT_> Input dataset does not have field: "JOB"
>##E TOPK 000000 15:30:24(013) <_PEEK_IDENT_> Input dataset does not have field: "MGR"
>##E TOPK 000000 15:30:24(014) <_PEEK_IDENT_> Input dataset does not have field: "HIREDATE"
>##E TOPK 000000 15:30:24(015) <_PEEK_IDENT_> Input dataset does not have field: "SAL"
>##E TOPK 000000 15:30:24(016) <_PEEK_IDENT_> Input dataset does not have field: "COMM"
>##E TOPK 000000 15:30:24(017) <_PEEK_IDENT_> Input dataset does not have field: "DEPTNO"
>##E TFSR 000019 15:30:24(019) <main_program> Could not check all operators because of previous error(s)
##W TFOR 000000 15:30:24(020) <Oracle_Enterprise_0> When checking operator: Modify operator has binding for non-existent output field "EMPNO"
##W TFOR 000000 15:30:24(021) <Oracle_Enterprise_0> When checking operator: Modify operator has binding for non-existent output field "ENAME"
##W TFOR 000000 15:30:24(022) <Oracle_Enterprise_0> When checking operator: Modify operator has binding for non-existent output field "JOB"
##W TFOR 000000 15:30:24(023) <Oracle_Enterprise_0> When checking operator: Modify operator has binding for non-existent output field "MGR"
##W TFOR 000000 15:30:24(024) <Oracle_Enterprise_0> When checking operator: Modify operator has binding for non-existent output field "HIREDATE"
##W TFOR 000000 15:30:24(025) <Oracle_Enterprise_0> When checking operator: Modify operator has binding for non-existent output field "SAL"
##W TFOR 000000 15:30:24(026) <Oracle_Enterprise_0> When checking operator: Modify operator has binding for non-existent output field "COMM"
##W TFOR 000000 15:30:24(027) <Oracle_Enterprise_0> When checking operator: Modify operator has binding for non-existent output field "DEPTNO"
>##E TCOS 000029 15:30:24(028) <main_program> Creation of step finished with status = FAILED.

I walked through the error,its saying server name missing but i have given the same in the property additional connection information.
I guess i need to do some settings to make it work.Any inputs would be most appreciated.

Thanks in advance.
Regards,
Bala.

[ashwin141]

Hi Bala

Have you checked the following things ?

ORACLE_SID

Is APT_ORCHHOME/bin present in ORACLE_HOME/bin in your path?

I am not sure if in Oracle also you need to specify the schema name as in DB2. You can check for this. Though it seems silly.

And can you let us know in what form you are specifying the login and password.

Regards
Ashwin

[lstsaur]

Hi Bala,
I am not sure what you mean by "but i have given the same in the property additional connection information."

For example, if your server name is "ora10g", then make sure you populate the "ora10g" in the Remote Server under the Connection.

[bala_135]

Hi Istsaur,

Thank you very much.Its my mistake.In the property tab of the Addtional connection information i gave the connect string.I gave it in remote server it worked fine.Thanks again

Regards,
Bala.