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

[vinpres]

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.

[AnandVyas]

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?

[vinpres]

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

[ballardw · Accepted solution]

---

@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.