Unable to connect to database SQL Plus8.0

[Former Member]

Hi

I am not able to connect to database via sql.I have been trying system and default password .

All the services are up and running.

Any guess ?

[Former Member]

execute the application using the short name

E: "C:\Progra~2\Business Objects\BusinessObjects Enterprise 12.0\win32_x86\designer.exe"

you can do this using a batch file...

sometimes especial characters "programfiles(x86)" make crash the odbc drivers......in this case ora8.

[Former Member]

Restart of SAP system worked and now issue got fixed

[Former Member]

Hello sukrut,

Is this a new installation ??

Have you revised the environment variables ?? If you have TNS problems it can be due to problems with incorrect environment variables.

Regards.

[Former Member]

Actually database version is 8

I am trying to connect via system and password abc but it saying TNS names coudn't resolved.

Regards

Sukrut

[markus_doehr2]

as which user are you trying to connect? what is your ORACLE_SID set to?

--

Markus

[Former Member]

TNS related errors shd be checked with tnsnames.ora file.

Check ur SID and confirm with tnsping utility it will help you out

Vinod

[former_member204746]

also supply contents of tnsnames.ora and listener.ora

[markus_doehr2]

Without knowing anything it's impossible to help you.

We need at least the following information:

- database version

- connect string (which what user do you want to connect)?

The standard users and passwords (system/manager etc.) are changed on installation.

--

Markus