topic Re: ERROR: ORACLE connection error: ORA-12545 Connection filed because target host or object does no in New SAS User

ERROR: ORACLE connection error: ORA-12545 Connection filed because target host or object does not ..

vinpres — Wed, 07 Oct 2020 08:32:29 GMT

Hi to all,

Kindly, I'm new to SAS, can any one help me with below error I getting while run a sas flow?

The error is this:

ERROR: ORACLE connection error: ORA-12545 Connection filed because target host or object does not exists.

ERROR: Error in the libname statement.

ERROR: Libname is not assigned.

Strange thing is that the above error happens randomly. It doesn't always happen when I run the SAS Flow.

What does it depend on?

Can any one help me to undestand the problem?

Thanks in advance.

Re: ERROR: ORACLE connection error: ORA-12545 Connection filed because target host or object does no

AnandVyas — Wed, 07 Oct 2020 08:39:03 GMT

Hi @vinpres

The error clearly states that connection failed as it wasn't able to connect to oracle host. Do you have the correct oracle environment variables defined for each user to properly resolve host address or are these set for a single user only?

Re: ERROR: ORACLE connection error: ORA-12545 Connection filed because target host or object does no

vinpres — Wed, 07 Oct 2020 10:26:32 GMT

Hi @AnandVyas

It's configured for one user only.

But my questions is: what means "error in the libname statement" and "Libname is not assigned"?

Thanks

Re: ERROR: ORACLE connection error: ORA-12545 Connection filed because target host or object does no

ballardw — Wed, 07 Oct 2020 17:21:56 GMT

@vinpres wrote:

Hi @AnandVyas

It's configured for one user only.

But my questions is: what means "error in the libname statement" and "Libname is not assigned"?

Thanks

It means that somewhere in a LIBNAME statement you have something that is not legal.

The "LIbname is not assigned" means that a library is not going to be available. Almost certainly because of the error referenced.

So you will not be able to use that library.