Connecting to Oracle

[SteveL]

I have installed Oracle10g client and PLSQL Developer on a new Windows7 PC.

When I run plsqlev to logon to Oracle and enter username, password, database and Connect as Normal and click OK I get a small window PL/SQL... containing an OK button. When I click this button it takes me back to the Oracle Logon screen.

Can you help with this problem please

 

[Marco Kalter]

Can you start PL/SQL Developer without connecting, go to Help > Support Info, press the 'Copy all pages' button on this info screen, and paste this text into a reply?

 

[SteveL]

Hi Marco,

Please find requested info below:

--- Info ---

PL/SQL Developer
Version 7.1.5.1398
Windows Vista 6.1 Build 7600

Physical memory : 2,027,120 kB (1,346,944 available)
Paging file : 4,054,240 kB (3,117,892 available)
Virtual memory : 2,097,024 kB (1,956,132 available)

Parameters
C:\Program Files\PLSQL Developer\plsqldev.exe

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False

Preference Files
C:\Users\steve.liddle\AppData\Roaming\PLSQL Developer\Preferences\steve.liddle\Default.ini
C:\Users\steve.liddle\AppData\Roaming\PLSQL Developer\Preferences\steve.liddle\Default.ini

Plug-Ins

Aliases
MIS
MISCentura
vm00010

Homes
OraClient10g_home5 (C:\oracle\product\10.2.0\client_5)

DLLs
C:\oracle\product\10.2.0\client_5\bin\oci.dll

TNS File
C:\oracle\product\10.2.0\client_5\Network\Admin\tnsnames.ora

Using
Home: OraClient10g_home5
DLL: C:\oracle\product\10.2.0\client_5\bin\oci.dll
OCI: version 9.2

--- Registry ---

SOFTWARE\ORACLE
inst_loc = C:\Program Files\Oracle\Inventory
VOBHOME2.0 = C:\oracle\product\10.2.0\client_5

SOFTWARE\ORACLE\KEY_OraClient10g_home1
ORACLE_HOME = C:\oracle\product\10.2.0\client_1
ORACLE_HOME_NAME = OraClient10g_home1
ORACLE_GROUP_NAME = Oracle - OraClient10g_home1

SOFTWARE\ORACLE\KEY_OraClient10g_home2
ORACLE_HOME = C:\oracle\product\10.2.0\client_2
ORACLE_HOME_NAME = OraClient10g_home2
ORACLE_GROUP_NAME = Oracle - OraClient10g_home2
ORACLE_BUNDLE_NAME = Enterprise
NLS_LANG = ENGLISH_UNITED KINGDOM.WE8MSWIN1252
StatementCacheSize = 0
OLEDB = C:\oracle\product\10.2.0\client_2\oledb\mesg
StmtCacheSize = 0
SQLPATH = C:\oracle\product\10.2.0\client_2\dbs
OO4O = C:\oracle\product\10.2.0\client_2\oo4o\mesg
ORACLE_HOME_KEY = SOFTWARE\ORACLE\KEY_OraClient10g_home2
MSHELP_TOOLS = C:\oracle\product\10.2.0\client_2\MSHELP

SOFTWARE\ORACLE\KEY_OraClient10g_home2\ODP.NET
TraceFileName = C:\ODPNET.trc
TraceLevel = 0
TraceOption = 0
StatementCacheSize = 0

SOFTWARE\ORACLE\KEY_OraClient10g_home2\OLEDB
CacheType = Memory
ChunkSize = 100
DistribTX = 1
FetchSize = 100
OSAuthent = 0
PLSQLRset = 0
PwdChgDlg = 1
SchRstLng = 10000
UserDefFn = 0
DisableRetClause = 1
VCharNull = 1
TraceCategory = 0
TraceFileName = c:\OraOLEDB.trc
TraceLevel = 0
TraceOption = 0
SPPrmDefVal = 0
StmtCacheSize = 0

SOFTWARE\ORACLE\KEY_OraClient10g_home2\OO4O
CacheBlocks = 20
FetchLimit = 100
FetchSize = 4096
HelpFile = C:\oracle\product\10.2.0\client_2\oo4o\doc\oracleo.hlp
PerBlock = 16
SliceSize = 256
TempFileDirectory = c:\temp
OO4O_HOME = C:\oracle\product\10.2.0\client_2\oo4o

SOFTWARE\ORACLE\KEY_OraClient10g_home3
ORACLE_HOME = C:\oracle\product\10.2.0\client_3
ORACLE_HOME_NAME = OraClient10g_home3
ORACLE_GROUP_NAME = Oracle - OraClient10g_home3
ORACLE_BUNDLE_NAME = Enterprise
NLS_LANG = ENGLISH_UNITED KINGDOM.WE8MSWIN1252
StatementCacheSize = 0
OLEDB = C:\oracle\product\10.2.0\client_3\oledb\mesg
StmtCacheSize = 0
SQLPATH = C:\oracle\product\10.2.0\client_3\dbs
OO4O = C:\oracle\product\10.2.0\client_3\oo4o\mesg
ORACLE_HOME_KEY = SOFTWARE\ORACLE\KEY_OraClient10g_home3
MSHELP_TOOLS = C:\oracle\product\10.2.0\client_3\MSHELP

SOFTWARE\ORACLE\KEY_OraClient10g_home3\ODP.NET
TraceFileName = C:\ODPNET.trc
TraceLevel = 0
TraceOption = 0
StatementCacheSize = 0

SOFTWARE\ORACLE\KEY_OraClient10g_home3\OLEDB
CacheType = Memory
ChunkSize = 100
DistribTX = 1
FetchSize = 100
OSAuthent = 0
PLSQLRset = 0
PwdChgDlg = 1
SchRstLng = 10000
UserDefFn = 0
DisableRetClause = 1
VCharNull = 1
TraceCategory = 0
TraceFileName = c:\OraOLEDB.trc
TraceLevel = 0
TraceOption = 0
SPPrmDefVal = 0
StmtCacheSize = 0

SOFTWARE\ORACLE\KEY_OraClient10g_home3\OO4O
CacheBlocks = 20
FetchLimit = 100
FetchSize = 4096
HelpFile = C:\oracle\product\10.2.0\client_3\oo4o\doc\oracleo.hlp
PerBlock = 16
SliceSize = 256
TempFileDirectory = c:\temp
OO4O_HOME = C:\oracle\product\10.2.0\client_3\oo4o

SOFTWARE\ORACLE\KEY_OraClient10g_home4
ORACLE_HOME = C:\oracle\product\10.2.0\client_4
ORACLE_HOME_NAME = OraClient10g_home4
ORACLE_GROUP_NAME = Oracle - OraClient10g_home4
ORACLE_BUNDLE_NAME = Enterprise
NLS_LANG = ENGLISH_UNITED KINGDOM.WE8MSWIN1252
SQLPATH = C:\oracle\product\10.2.0\client_4\dbs
ORACLE_HOME_KEY = SOFTWARE\ORACLE\KEY_OraClient10g_home4

SOFTWARE\ORACLE\KEY_OraClient10g_home5
ORACLE_HOME = C:\oracle\product\10.2.0\client_5
ORACLE_HOME_NAME = OraClient10g_home5
ORACLE_GROUP_NAME = Oracle - OraClient10g_home5
ORACLE_BUNDLE_NAME = Enterprise
NLS_LANG = ENGLISH_UNITED KINGDOM.WE8MSWIN1252
StatementCacheSize = 0
OLEDB = C:\oracle\product\10.2.0\client_5\oledb\mesg
StmtCacheSize = 0
SQLPATH = C:\oracle\product\10.2.0\client_5\dbs
OO4O = C:\oracle\product\10.2.0\client_5\oo4o\mesg
ORACLE_HOME_KEY = SOFTWARE\ORACLE\KEY_OraClient10g_home5
MSHELP_TOOLS = C:\oracle\product\10.2.0\client_5\MSHELP

SOFTWARE\ORACLE\KEY_OraClient10g_home5\ODP.NET
TraceFileName = C:\ODPNET.trc
TraceLevel = 0
TraceOption = 0
StatementCacheSize = 0

SOFTWARE\ORACLE\KEY_OraClient10g_home5\OLEDB
CacheType = Memory
ChunkSize = 100
DistribTX = 1
FetchSize = 100
OSAuthent = 0
PLSQLRset = 0
PwdChgDlg = 1
SchRstLng = 10000
UserDefFn = 0
DisableRetClause = 1
VCharNull = 1
TraceCategory = 0
TraceFileName = c:\OraOLEDB.trc
TraceLevel = 0
TraceOption = 0
SPPrmDefVal = 0
StmtCacheSize = 0

SOFTWARE\ORACLE\KEY_OraClient10g_home5\OO4O
CacheBlocks = 20
FetchLimit = 100
FetchSize = 4096
HelpFile = C:\oracle\product\10.2.0\client_5\oo4o\doc\oracleo.hlp
PerBlock = 16
SliceSize = 256
TempFileDirectory = c:\temp
OO4O_HOME = C:\oracle\product\10.2.0\client_5\oo4o

--- Path ---

C:\oracle\product\10.2.0\client_5\bin
C:\oracle\product\10.2.0\client_4\bin
C:\oracle\product\10.2.0\client_3\bin
C:\oracle\product\10.2.0\client_2\bin
C:\oracle\product\10.2.0\client_1
C:\Centura2005
C:\Windows\system32
C:\Windows
C:\Windows\System32\Wbem
C:\Windows\System32\WindowsPowerShell\v1.0\
C:\Program Files\Intel\DMIX
C:\Program Files\NTRU Cryptosystems\NTRU TCG Software Stack\bin\
C:\Program Files\Wave Systems Corp\Gemalto\Access Client\v5\
C:\Program Files\Common Files\Roxio Shared\DLLShared\
C:\Program Files\Common Files\Roxio Shared\10.0\DLLShared\
C:\Program Files\TortoiseSVN\bin

--- TNS names ---

MISCentura =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = vm00036)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

vm00010 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = vm00010)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

MIS =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.2.56.144)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = mis.assetco)
)
)

 

[Marco Kalter]

Can you connect with C:\oracle\product\10.2.0\client_5\bin\sqlplus.exe?

 

[SteveL]

Hi Marco,

Sorry in my delay to reply to your last comment but I was working away last week.

I have just tried what you suggested - when I run sqlplusw I get the Log On screen. When I enter User Name, Password, Host String and click OK the Log On screen does not log me on and dissappears without giving any message.

Regards,

Steve

 

[Marco Kalter]

Can you try this solution?

 

[SteveL]

Hi Marco,

Yes that's solved the problem.

Thanks very much for your time and help with this problem.

Regards,

Steve