Toad World® Forums

Problem with First Connection to Oracle

Hi Guys,

I am new at Oracle and Toad ,as well. I Installed Oracle 10 Ex on my computer local disk/C:(Windows 7) and I tried to connect to database by Toad but it didn’t worked!
I tried to log in as system user with my password and following parameters:

User/Schema:system
Password:******
Database:XE

Connect as : Noramal
Conect Using:XE

The SQLNET Editor in green checked mark
TSNName Editor in green checked mark
BUT: the LDAP Editor is getting RED cross and it’s button is not active!
I got this erroe:
ORA-12154:TSN:could not resolve the connect identifier specified(XE)

I also tried Direct connection method with
Host: Mycomputer
Port:1521
But I did not know what should I enter for Server Name or SID?! so I got this warnning message:
Please enter Host,Port,and SID/Service Name.

This is what I have in tsnname.ora file:

XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Mycomputer)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)

and the sqlnet.ora looks like this:

This file is actually generated by netca. But if customers choose to

install “Software Only”, this file wont exist and without the native

authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES = (NTS)

could you please let me know what is wrong and how I can connect with Toad to oracle.I also have to say that I am able to connect to my database with Oracle SQL Developer.

Best regards
Behrouz

Message was edited by: Behseini

Hi there

Connections to Oracle databases via TNS are a bit of a pain until you get all the components in the link configured correctly. One issue that is often overlooked is DNS resolution of the system name that is hosting the Oracle database.

If you are just using a single PC for Oracle and Toad then the following options should fix the TNS connection issue:-

If you are using a FIXED IP address for the PC then substitute the IP address for the HOST name in the TNSNAMES file. (example below)

DATA1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = DATA1)
)

If you are using DHCP for you IP address then you need to use IP address 127.0.0.1 and have an entry in the HOSTS file of :- 127.0.0.1 localhost

The TNSNAMES.ora file is found in the (oracle_home)/NETWORK/ADMIN DIRECTORY and the windows hosts file is in the C:/windows/system32/drivers/etc directory.

Hope this fixes your probs.

Regards

[ Attachment(s) from Bzehrou included below]

Message from: Behseini

Hi Catbiter,
Thanks for your help ,however I still have the problem
I correct the TNSNAMES.ora as bellow

XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
but I still getting the Error ORA:06413 Connection Not Open error!
as attached images
Thanks again
Behrouz


Historical Messages

Author: Bzehrou
Date: Sun Feb 13 03:05:35 PST 2011
Hi Catbiter,
Thanks for your help ,however I still have the problem
I correct the TNSNAMES.ora as bellow

XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
but I still getting the Error ORA:06413 Connection Not Open error!
as attached images
Thanks again
Behrouz

__

Author: Win Chester
Date: Mon Feb 07 07:42:25 PST 2011

Hi there

Connections to Oracle databases via TNS are a bit of a pain until you get all
the components in the link configured correctly. One issue that is often
overlooked is DNS resolution of the system name that is hosting the Oracle
database.

If you are just using a single PC for Oracle and Toad then the following options
should fix the TNS connection issue:-

If you are using a FIXED IP address for the PC then substitute the IP address
for the HOST name in the TNSNAMES file. (example below)

DATA1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = DATA1)
)

If you are using DHCP for you IP address then you need to use IP address
127.0.0.1 and have an entry in the HOSTS file of :- 127.0.0.1 localhost

The TNSNAMES.ora file is found in the (oracle_home)/NETWORK/ADMIN DIRECTORY and
the windows hosts file is in the C:/windows/system32/drivers/etc directory.

Hope this fixes your probs.

Regards

__

Author: Bzehrou
Date: Sat Feb 05 23:22:15 PST 2011
Hi Guys,

I am new at Oracle and Toad ,as well. I Installed Oracle 10 Ex on my computer
local disk/C:(Windows 7) and I tried to connect to database by Toad but it
didn’t worked!
I tried to log in as system user with my password and following parameters:

Hi Catbiter,
Thanks for your help ,however I still have the problem
I correct the TNSNAMES.ora as bellow

XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
but I still getting the Error ORA:06413 Connection Not Open error!
as attached images
Thanks again
Behrouz

Hi Catbiter,
Thanks for your help ,however I still have the problem
I correct the TNSNAMES.ora as bellow

XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
but I still getting the Error ORA:06413 Connection Not Open error!
as attached images
Thanks again
Behrouz

Message from: mj_010101_312

Not sure if this was resolved – I ran into the same problem but got this fixed
by ensure the install path to TOAD not including any special char such as ( and
… I have 64 bit machine and the path to program files folder end with (x86) and
that dcause the problem!


Historical Messages

Author: mj_010101_312
Date: Wed Aug 03 13:34:23 PDT 2011

Not sure if this was resolved – I ran into the same problem but got this fixed
by ensure the install path to TOAD not including any special char such as ( and
… I have 64 bit machine and the path to program files folder end with (x86) and
that dcause the problem!

__

Author: Bzehrou
Date: Sun Feb 13 03:05:35 PST 2011
Hi Catbiter,
Thanks for your help ,however I still have the problem
I correct the TNSNAMES.ora as bellow

XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
but I still getting the Error ORA:06413 Connection Not Open error!
as attached images
Thanks again
Behrouz

__

Author: Bzehrou
Date: Sun Feb 13 03:05:35 PST 2011
[ Attachment(s) from Bzehrou included below] Message from: Behseini Hi Catbiter,
Thanks for your help ,however I still have the problem I correct the
TNSNAMES.ora as bellow XE = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =
127.0.0.1)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME =
XE) ) ) but I still getting the Error ORA:06413 Connection Not Open error! as
attached images Thanks again Behrouz _______________________________________
Historical Messages Author: Bzehrou Date: Sun Feb 13 03:05:35 PST 2011 Hi
Catbiter, Thanks for your help ,however I still have the problem I correct the
TNSNAMES.ora as bellow XE = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =
127.0.0.1)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME =
XE) ) ) but I still getting the Error ORA:06413 Connection Not Open error! as
attached images Thanks again Behrouz __ Author: Win Chester Date: Mon Feb 07
07:42:25 PST 2011 Hi there Connections to Oracle databases via TNS are a bit of
a pain until you get all the components in the link configured correctly. One
issue that is often overlooked is DNS resolution of the system name that is
hosting the Oracle database. If you are just using a single PC for Oracle and
Toad then the following options should fix the TNS connection issue:- If you are
using a FIXED IP address for the PC then substitute the IP address for the HOST
name in the TNSNAMES file. (example below) DATA1 = (DESCRIPTION = (ADDRESS =
(PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1522)) (CONNECT_DATA = (SERVER =
DEDICATED) (SERVICE_NAME = DATA1) ) If you are using DHCP for you IP address
then you need to use IP address 127.0.0.1 and have an entry in the HOSTS file of
:- 127.0.0.1 localhost The TNSNAMES.ora file is found in the
(oracle_home)/NETWORK/ADMIN DIRECTORY and the windows hosts file is in the
C:/windows/system32/drivers/etc directory. Hope this fixes your probs. Regards
__ Author: Bzehrou Date: Sat Feb 05 23:22:15 PST 2011 Hi Guys, I am new at
Oracle and Toad ,as well. I Installed Oracle 10 Ex on my computer local
disk/C:(Windows 7) and I tried to connect to database by Toad but it didn’t
worked! I tried to log in as system user with my password and following
parameters:
__

Author: Win Chester
Date: Mon Feb 07 07:42:25 PST 2011

Hi there

Connections to Oracle databases via TNS are a bit of a pain until you get all
the components in the link configured correctly. One issue that is often
overlooked is DNS resolution of the system name that is hosting the Oracle
database.

If you are just using a single PC for Oracle and Toad then the following options
should fix the TNS connection issue:-

If you are using a FIXED IP address for the PC then substitute the IP address
for the HOST name in the TNSNAMES file. (example below)

DATA1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = DATA1)
)

If you are using DHCP for you IP address then you need to use IP address
127.0.0.1 and have an entry in the HOSTS file of :- 127.0.0.1 localhost

The TNSNAMES.ora file is found in the (oracle_home)/NETWORK/ADMIN DIRECTORY and
the windows hosts file is in the C:/windows/system32/drivers/etc directory.

Hope this fixes your probs.

Regards

__

Author: Bzehrou
Date: Sat Feb 05 23:22:15 PST 2011
Hi Guys,

I am new at Oracle and Toad ,as well. I Installed Oracle 10 Ex on my computer
local disk/C:(Windows 7) and I tried to connect to database by Toad but it
didn’t worked!
I tried to log in as system user with my password and following parameters:

It is not Toad, it is the wrong version of the Oracle client. Dont use anything
less then 10.0.4. The bug is there. Any application running in a directory with
parentheses in it, has problems with this client.

Groetjes,
Wim

On Wed, Aug 3, 2011 at 22:34, mj_010101_312 wrote:

Message from: mj_010101_312

Not sure if this was resolved – I ran into the same problem but got this
fixed by ensure the install path to TOAD not including any special char such
as ( and … I have 64 bit machine and the path to program files folder end
with (x86) and that dcause the problem!


Historical Messages

Author: mj_010101_312
Date: Wed Aug 03 13:34:23 PDT 2011

Not sure if this was resolved -- I ran into the same problem but got this
fixed by ensure the install path to TOAD not including any special char such
as ( and .. I have 64 bit machine and the path to program files folder end
with (x86) and that dcause the problem!

__

Author: Bzehrou
Date: Sun Feb 13 03:05:35 PST 2011
Hi Catbiter,
Thanks for your help ,however I still have the problem
I correct the TNSNAMES.ora as bellow

XE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = XE)
    )
  )
but I still getting the Error ORA:06413 Connection Not Open error!
as attached images
Thanks again
Behrouz

__

Author: Bzehrou
Date: Sun Feb 13 03:05:35 PST 2011
[ Attachment(s) from Bzehrou included below] Message from: Behseini Hi
Catbiter, Thanks for your help ,however I still have the problem I correct
the TNSNAMES.ora as bellow XE = (DESCRIPTION = (ADDRESS = (PROTOCOL =
TCP)(HOST = 127.0.0.1)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED)
(SERVICE_NAME = XE) ) ) but I still getting the Error ORA:06413 Connection
Not Open error! as attached images Thanks again Behrouz
_______________________________________ Historical Messages Author: Bzehrou
Date: Sun Feb 13 03:05:35 PST 2011 Hi Catbiter, Thanks for your help
,however I still have the problem I correct the TNSNAMES.ora as bellow XE =
(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE) ) ) but I still
getting the Error ORA:06413 Connection Not Open error! as attached images
Thanks again Behrouz __ Author: Win Chester Date: Mon Feb 07 07:42:25 PST
2011 Hi there Connections to Oracle databases via TNS are a bit of a pain
until you get all the components in the link configured correctly. One issue
that is often overlooked is DNS resolution of the system name that is
hosting the Oracle database. If you are just using a single PC for Oracle
and Toad then the following options should fix the TNS connection issue:- If
you are using a FIXED IP address for the PC then substitute the IP address
for the HOST name in the TNSNAMES file. (example below) DATA1 = (DESCRIPTION
= (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1522))
(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = DATA1) ) If you are
using DHCP for you IP address then you need to use IP address 127.0.0.1 and
have an entry in the HOSTS file of :- 127.0.0.1 localhost The TNSNAMES.ora
file is found in the (oracle_home)/NETWORK/ADMIN DIRECTORY and the windows
hosts file is in the C:/windows/system32/drivers/etc directory. Hope this
fixes your probs. Regards __ Author: Bzehrou Date: Sat Feb 05 23:22:15 PST
2011 Hi Guys, I am new at Oracle and Toad ,as well. I Installed Oracle 10 Ex
on my computer local disk/C:(Windows 7) and I tried to connect to database
by Toad but it didn't worked! I tried to log in as system user with my
password and following parameters:
__

Author: Win Chester
Date: Mon Feb 07 07:42:25 PST 2011

Hi there

Connections to Oracle databases via TNS are a bit of a pain until you get
all the components in the link configured correctly. One issue that is often
overlooked is DNS resolution of the system name that is hosting the Oracle
database.

If you are just using a single PC for Oracle and Toad then the following
options should fix the TNS connection issue:-

If you are using a FIXED IP address for the PC then substitute the IP
address for the HOST name in the TNSNAMES file. (example below)

DATA1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = DATA1)
)

If you are using DHCP for you IP address then you need to use IP address
127.0.0.1 and have an entry in the HOSTS file of :- 127.0.0.1
localhost

The TNSNAMES.ora file is found in the (oracle_home)/NETWORK/ADMIN DIRECTORY
and the windows hosts file is in the C:/windows/system32/drivers/etc
directory.

Hope this fixes your probs.

Regards

__

Author: Bzehrou
Date: Sat Feb 05 23:22:15 PST 2011
Hi Guys,

I am new at Oracle and Toad ,as well. I Installed Oracle 10 Ex on my
computer local disk/C:(Windows 7) and I tried to connect to database by Toad
but it didn't worked!
I tried to log in as system user with my password and following parameters:

Not sure if this was resolved – I ran into the same problem but got this fixed by ensure the install path to TOAD not including any special char such as ( and … I have 64 bit machine and the path to program files folder end with (x86) and that dcause the problem!

Message from: susan1

I have installed Oracle 10g on the local server and everything works perfectly.
… I am using the code below


Historical Messages

Author: James Salerno
Date: Wed Aug 31 04:09:50 PDT 2011
I have installed Oracle 10g on the local server and everything works perfectly.
… I am using the code

__

Author: James Salerno
Date: Wed Aug 31 04:09:33 PDT 2011
I have installed Oracle 10g on the local server and everything works perfectly.
… I am using the code below

__

Author: mj_010101_312
Date: Wed Aug 03 13:34:23 PDT 2011

Not sure if this was resolved – I ran into the same problem but got this fixed
by ensure the install path to TOAD not including any special char such as ( and
… I have 64 bit machine and the path to program files folder end with (x86) and
that dcause the problem!

__

Author: Wim de lange
Date: Wed Aug 03 13:34:23 PDT 2011
It is not Toad, it is the wrong version of the Oracle client. Dont use anything
less then 10.0.4. The bug is there. Any application running in a directory with
parentheses in it, has problems with this client. Groetjes, Wim On Wed, Aug
3, 2011 at 22:34, mj_010101_312 wrote: Message from: mj_010101_312 Not sure
if this was resolved – I ran into the same problem but got this fixed by ensure
the install path to TOAD not including any special char such as ( and … I have
64 bit machine and the path to program files folder end with (x86) and that
dcause the problem! _______________________________________ Historical Messages
Author: mj_010101_312 Date: Wed Aug 03 13:34:23 PDT 2011 Not sure if this was
resolved – I ran into the same problem but got this fixed by ensure the install
path to TOAD not including any special char such as ( and … I have 64 bit
machine and the path to program files folder end with (x86) and that dcause the
problem! __ Author: Bzehrou Date: Sun Feb 13 03:05:35 PST 2011 Hi Catbiter,
Thanks for your help ,however I still have the problem I correct the
TNSNAMES.ora as bellow XE = (DESCRIPTION = (ADDRESS = (PROTOCOL =
TCP)(HOST = 127.0.0.1)(PORT = 1521)) (CONNECT_DATA = (SERVER =
DEDICATED) (SERVICE_NAME = XE) ) ) but I still getting the
Error ORA:06413 Connection Not Open error! as attached images Thanks again
Behrouz __ Author: Bzehrou Date: Sun Feb 13 03:05:35 PST 2011 [ Attachment(s)
from Bzehrou included below] Message from: Behseini Hi Catbiter, Thanks for your
help ,however I still have the problem I correct the TNSNAMES.ora as bellow XE =
(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE) ) ) but I still getting
the Error ORA:06413 Connection Not Open error! as attached images Thanks again
Behrouz _______________________________________ Historical Messages Author:
Bzehrou Date: Sun Feb 13 03:05:35 PST 2011 Hi Catbiter, Thanks for your help
,however I still have the problem I correct the TNSNAMES.ora as bellow XE =
(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE) ) ) but I still getting
the Error ORA:06413 Connection Not Open error! as attached images Thanks again
Behrouz __ Author: Win Chester Date: Mon Feb 07 07:42:25 PST 2011 Hi there
Connections to Oracle databases via TNS are a bit of a pain until you get all
the components in the link configured correctly. One issue that is often
overlooked is DNS resolution of the system name that is hosting the Oracle
database. If you are just using a single PC for Oracle and Toad then the
following options should fix the TNS connection issue:- If you are using a FIXED
IP address for the PC then substitute the IP address for the HOST name in the
TNSNAMES file. (example below) DATA1 = (DESCRIPTION = (ADDRESS = (PROTOCOL =
TCP)(HOST = 192.168.1.5)(PORT = 1522)) (CONNECT_DATA = (SERVER = DEDICATED)
(SERVICE_NAME = DATA1) ) If you are using DHCP for you IP address then you need
to use IP address 127.0.0.1 and have an entry in the HOSTS file of :- 127.0.0.1
localhost The TNSNAMES.ora file is found in the (oracle_home)/NETWORK/ADMIN
DIRECTORY and the windows hosts file is in the C:/windows/system32/drivers/etc
directory. Hope this fixes your probs. Regards __ Author: Bzehrou Date: Sat Feb
05 23:22:15 PST 2011 Hi Guys, I am new at Oracle and Toad ,as well. I Installed
Oracle 10 Ex on my computer local disk/C:(Windows 7) and I tried to connect to
database by Toad but it didn’t worked! I tried to log in as system user with
my password and following parameters: __ Author: Win Chester Date: Mon Feb 07
07:42:25 PST 2011 Hi there Connections to Oracle databases via TNS are a bit of
a pain until you get all the components in the link configured correctly. One
issue that is often overlooked is DNS resolution of the system name that is
hosting the Oracle database. If you are just using a single PC for Oracle and
Toad then the following options should fix the TNS connection issue:- If you are
using a FIXED IP address for the PC then substitute the IP address for the HOST
name in the TNSNAMES file. (example below) DATA1 = (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1522))
(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME =
DATA1) ) If you are using DHCP for you IP address then you need to use IP
address 127.0.0.1 and have an entry in the HOSTS file of :- 127.0.0.1
localhost The TNSNAMES.ora file is found in the (oracle_home)/NETWORK/ADMIN
DIRECTORY and the windows hosts file is in the C:/windows/system32/drivers/etc
directory. Hope this fixes your probs. Regards __ Author: Bzehrou Date: Sat Feb
05 23:22:15 PST 2011 Hi Guys, I am new at Oracle and Toad ,as well. I Installed
Oracle 10 Ex on my computer local disk/C:(Windows 7) and I tried to connect to
database by Toad but it didn’t worked! I tried to log in as system user with
my password and following parameters:
__

Author: mj_010101_312
Date: Wed Aug 03 13:34:23 PDT 2011
Message from: mj_010101_312 Not sure if this was resolved – I ran into the same
problem but got this fixed by ensure the install path to TOAD not including any
special char such as ( and … I have 64 bit machine and the path to program
files folder end with (x86) and that dcause the problem!
_______________________________________ Historical Messages Author:
mj_010101_312 Date: Wed Aug 03 13:34:23 PDT 2011 Not sure if this was resolved
– I ran into the same problem but got this fixed by ensure the install path to
TOAD not including any special char such as ( and … I have 64 bit machine and
the path to program files folder end with (x86) and that dcause the problem! __
Author: Bzehrou Date: Sun Feb 13 03:05:35 PST 2011 Hi Catbiter, Thanks for your
help ,however I still have the problem I correct the TNSNAMES.ora as bellow XE =
(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE) ) ) but I still getting
the Error ORA:06413 Connection Not Open error! as attached images Thanks again
Behrouz __ Author: Bzehrou Date: Sun Feb 13 03:05:35 PST 2011 [ Attachment(s)
from Bzehrou included below] Message from: Behseini Hi Catbiter, Thanks for your
help ,however I still have the problem I correct the TNSNAMES.ora as bellow XE =
(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE) ) ) but I still getting
the Error ORA:06413 Connection Not Open error! as attached images Thanks again
Behrouz _______________________________________ Historical Messages Author:
Bzehrou Date: Sun Feb 13 03:05:35 PST 2011 Hi Catbiter, Thanks for your help
,however I still have the problem I correct the TNSNAMES.ora as bellow XE =
(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE) ) ) but I still getting
the Error ORA:06413 Connection Not Open error! as attached images Thanks again
Behrouz __ Author: Win Chester Date: Mon Feb 07 07:42:25 PST 2011 Hi there
Connections to Oracle databases via TNS are a bit of a pain until you get all
the components in the link configured correctly. One issue that is often
overlooked is DNS resolution of the system name that is hosting the Oracle
database. If you are just using a single PC for Oracle and Toad then the
following options should fix the TNS connection issue:- If you are using a FIXED
IP address for the PC then substitute the IP address for the HOST name in the
TNSNAMES file. (example below) DATA1 = (DESCRIPTION = (ADDRESS = (PROTOCOL =
TCP)(HOST = 192.168.1.5)(PORT = 1522)) (CONNECT_DATA = (SERVER = DEDICATED)
(SERVICE_NAME = DATA1) ) If you are using DHCP for you IP address then you need
to use IP address 127.0.0.1 and have an entry in the HOSTS file of :- 127.0.0.1
localhost The TNSNAMES.ora file is found in the (oracle_home)/NETWORK/ADMIN
DIRECTORY and the windows hosts file is in the C:/windows/system32/drivers/etc
directory. Hope this fixes your probs. Regards __ Author: Bzehrou Date: Sat Feb
05 23:22:15 PST 2011 Hi Guys, I am new at Oracle and Toad ,as well. I Installed
Oracle 10 Ex on my computer local disk/C:(Windows 7) and I tried to connect to
database by Toad but it didn’t worked! I tried to log in as system user with
my password and following parameters: __ Author: Win Chester Date: Mon Feb 07
07:42:25 PST 2011 Hi there Connections to Oracle databases via TNS are a bit of
a pain until you get all the components in the link configured correctly. One
issue that is often overlooked is DNS resolution of the system name that is
hosting the Oracle database. If you are just using a single PC for Oracle and
Toad then the following options should fix the TNS connection issue:- If you are
using a FIXED IP address for the PC then substitute the IP address for the HOST
name in the TNSNAMES file. (example below) DATA1 = (DESCRIPTION = (ADDRESS =
(PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1522)) (CONNECT_DATA = (SERVER =
DEDICATED) (SERVICE_NAME = DATA1) ) If you are using DHCP for you IP address
then you need to use IP address 127.0.0.1 and have an entry in the HOSTS file of
:- 127.0.0.1 localhost The TNSNAMES.ora file is found in the
(oracle_home)/NETWORK/ADMIN DIRECTORY and the windows hosts file is in the
C:/windows/system32/drivers/etc directory. Hope this fixes your probs. Regards
__ Author: Bzehrou Date: Sat Feb 05 23:22:15 PST 2011 Hi Guys, I am new at
Oracle and Toad ,as well. I Installed Oracle 10 Ex on my computer local
disk/C:(Windows 7) and I tried to connect to database by Toad but it didn’t
worked! I tried to log in as system user with my password and following
parameters:
__

Author: Bzehrou
Date: Sun Feb 13 03:05:35 PST 2011
Hi Catbiter,
Thanks for your help ,however I still have the problem
I correct the TNSNAMES.ora as bellow

XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
but I still getting the Error ORA:06413 Connection Not Open error!
as attached images
Thanks again
Behrouz

__

Author: Bzehrou
Date: Sun Feb 13 03:05:35 PST 2011
[ Attachment(s) from Bzehrou included below] Message from: Behseini Hi Catbiter,
Thanks for your help ,however I still have the problem I correct the
TNSNAMES.ora as bellow XE = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =
127.0.0.1)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME =
XE) ) ) but I still getting the Error ORA:06413 Connection Not Open error! as
attached images Thanks again Behrouz _______________________________________
Historical Messages Author: Bzehrou Date: Sun Feb 13 03:05:35 PST 2011 Hi
Catbiter, Thanks for your help ,however I still have the problem I correct the
TNSNAMES.ora as bellow XE = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =
127.0.0.1)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME =
XE) ) ) but I still getting the Error ORA:06413 Connection Not Open error! as
attached images Thanks again Behrouz __ Author: Win Chester Date: Mon Feb 07
07:42:25 PST 2011 Hi there Connections to Oracle databases via TNS are a bit of
a pain until you get all the components in the link configured correctly. One
issue that is often overlooked is DNS resolution of the system name that is
hosting the Oracle database. If you are just using a single PC for Oracle and
Toad then the following options should fix the TNS connection issue:- If you are
using a FIXED IP address for the PC then substitute the IP address for the HOST
name in the TNSNAMES file. (example below) DATA1 = (DESCRIPTION = (ADDRESS =
(PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1522)) (CONNECT_DATA = (SERVER =
DEDICATED) (SERVICE_NAME = DATA1) ) If you are using DHCP for you IP address
then you need to use IP address 127.0.0.1 and have an entry in the HOSTS file of
:- 127.0.0.1 localhost The TNSNAMES.ora file is found in the
(oracle_home)/NETWORK/ADMIN DIRECTORY and the windows hosts file is in the
C:/windows/system32/drivers/etc directory. Hope this fixes your probs. Regards
__ Author: Bzehrou Date: Sat Feb 05 23:22:15 PST 2011 Hi Guys, I am new at
Oracle and Toad ,as well. I Installed Oracle 10 Ex on my computer local
disk/C:(Windows 7) and I tried to connect to database by Toad but it didn’t
worked! I tried to log in as system user with my password and following
parameters:
__

Author: Win Chester
Date: Mon Feb 07 07:42:25 PST 2011

Hi there

Connections to Oracle databases via TNS are a bit of a pain until you get all
the components in the link configured correctly. One issue that is often
overlooked is DNS resolution of the system name that is hosting the Oracle
database.

If you are just using a single PC for Oracle and Toad then the following options
should fix the TNS connection issue:-

If you are using a FIXED IP address for the PC then substitute the IP address
for the HOST name in the TNSNAMES file. (example below)

DATA1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = DATA1)
)

If you are using DHCP for you IP address then you need to use IP address
127.0.0.1 and have an entry in the HOSTS file of :- 127.0.0.1 localhost

The TNSNAMES.ora file is found in the (oracle_home)/NETWORK/ADMIN DIRECTORY and
the windows hosts file is in the C:/windows/system32/drivers/etc directory.

Hope this fixes your probs.

Regards

__

Author: Bzehrou
Date: Sat Feb 05 23:22:15 PST 2011
Hi Guys,

I am new at Oracle and Toad ,as well. I Installed Oracle 10 Ex on my computer
local disk/C:(Windows 7) and I tried to connect to database by Toad but it
didn’t worked!
I tried to log in as system user with my password and following parameters:

I have installed Oracle 10g on the local server and everything works perfectly. I am using the code below

I have installed Oracle 10g on the local server and everything works perfectly. I am using the code

Message from: sudhir

try to change connection as: sysdba to else may be that will work


Historical Messages

Author: Sudhir Chautrvedi
Date: Tue Mar 06 08:07:16 PST 2012
try to change connection as: sysdba to else may be that will work
__

Author: James Salerno
Date: Wed Aug 31 04:09:50 PDT 2011
I have installed Oracle 10g on the local server and everything works perfectly.
… I am using the code

__

Author: James Salerno
Date: Wed Aug 31 04:09:33 PDT 2011
I have installed Oracle 10g on the local server and everything works perfectly.
… I am using the code below

__

Author: James Salerno
Date: Wed Aug 31 04:09:33 PDT 2011
Message from: susan1 I have installed Oracle 10g on the local server and
everything works perfectly. … I am using the code below
_______________________________________ Historical Messages Author: James
Salerno Date: Wed Aug 31 04:09:50 PDT 2011 I have installed Oracle 10g on the
local server and everything works perfectly. … I am using the code __ Author:
James Salerno Date: Wed Aug 31 04:09:33 PDT 2011 I have installed Oracle 10g on
the local server and everything works perfectly. … I am using the code below
__ Author: mj_010101_312 Date: Wed Aug 03 13:34:23 PDT 2011 Not sure if this was
resolved – I ran into the same problem but got this fixed by ensure the install
path to TOAD not including any special char such as ( and … I have 64 bit
machine and the path to program files folder end with (x86) and that dcause the
problem! __ Author: Wim de lange Date: Wed Aug 03 13:34:23 PDT 2011 It is not
Toad, it is the wrong version of the Oracle client. Dont use anything less then
10.0.4. The bug is there. Any application running in a directory with
parentheses in it, has problems with this client. Groetjes, Wim On Wed, Aug
3, 2011 at 22:34, mj_010101_312 wrote: Message from: mj_010101_312 Not sure
if this was resolved – I ran into the same problem but got this fixed by ensure
the install path to TOAD not including any special char such as ( and … I have
64 bit machine and the path to program files folder end with (x86) and that
dcause the problem! _______________________________________ Historical Messages
Author: mj_010101_312 Date: Wed Aug 03 13:34:23 PDT 2011 Not sure if this was
resolved – I ran into the same problem but got this fixed by ensure the install
path to TOAD not including any special char such as ( and … I have 64 bit
machine and the path to program files folder end with (x86) and that dcause the
problem! __ Author: Bzehrou Date: Sun Feb 13 03:05:35 PST 2011 Hi Catbiter,
Thanks for your help ,however I still have the problem I correct the
TNSNAMES.ora as bellow XE = (DESCRIPTION = (ADDRESS = (PROTOCOL =
TCP)(HOST = 127.0.0.1)(PORT = 1521)) (CONNECT_DATA = (SERVER =
DEDICATED) (SERVICE_NAME = XE) ) ) but I still getting the
Error ORA:06413 Connection Not Open error! as attached images Thanks again
Behrouz __ Author: Bzehrou Date: Sun Feb 13 03:05:35 PST 2011 [ Attachment(s)
from Bzehrou included below] Message from: Behseini Hi Catbiter, Thanks for your
help ,however I still have the problem I correct the TNSNAMES.ora as bellow XE =
(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE) ) ) but I still getting
the Error ORA:06413 Connection Not Open error! as attached images Thanks again
Behrouz _______________________________________ Historical Messages Author:
Bzehrou Date: Sun Feb 13 03:05:35 PST 2011 Hi Catbiter, Thanks for your help
,however I still have the problem I correct the TNSNAMES.ora as bellow XE =
(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE) ) ) but I still getting
the Error ORA:06413 Connection Not Open error! as attached images Thanks again
Behrouz __ Author: Win Chester Date: Mon Feb 07 07:42:25 PST 2011 Hi there
Connections to Oracle databases via TNS are a bit of a pain until you get all
the components in the link configured correctly. One issue that is often
overlooked is DNS resolution of the system name that is hosting the Oracle
database. If you are just using a single PC for Oracle and Toad then the
following options should fix the TNS connection issue:- If you are using a FIXED
IP address for the PC then substitute the IP address for the HOST name in the
TNSNAMES file. (example below) DATA1 = (DESCRIPTION = (ADDRESS = (PROTOCOL =
TCP)(HOST = 192.168.1.5)(PORT = 1522)) (CONNECT_DATA = (SERVER = DEDICATED)
(SERVICE_NAME = DATA1) ) If you are using DHCP for you IP address then you need
to use IP address 127.0.0.1 and have an entry in the HOSTS file of :- 127.0.0.1
localhost The TNSNAMES.ora file is found in the (oracle_home)/NETWORK/ADMIN
DIRECTORY and the windows hosts file is in the C:/windows/system32/drivers/etc
directory. Hope this fixes your probs. Regards __ Author: Bzehrou Date: Sat Feb
05 23:22:15 PST 2011 Hi Guys, I am new at Oracle and Toad ,as well. I Installed
Oracle 10 Ex on my computer local disk/C:(Windows 7) and I tried to connect to
database by Toad but it didn’t worked! I tried to log in as system user with
my password and following parameters: __ Author: Win Chester Date: Mon Feb 07
07:42:25 PST 2011 Hi there Connections to Oracle databases via TNS are a bit of
a pain until you get all the components in the link configured correctly. One
issue that is often overlooked is DNS resolution of the system name that is
hosting the Oracle database. If you are just using a single PC for Oracle and
Toad then the following options should fix the TNS connection issue:- If you are
using a FIXED IP address for the PC then substitute the IP address for the HOST
name in the TNSNAMES file. (example below) DATA1 = (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1522))
(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME =
DATA1) ) If you are using DHCP for you IP address then you need to use IP
address 127.0.0.1 and have an entry in the HOSTS file of :- 127.0.0.1
localhost The TNSNAMES.ora file is found in the (oracle_home)/NETWORK/ADMIN
DIRECTORY and the windows hosts file is in the C:/windows/system32/drivers/etc
directory. Hope this fixes your probs. Regards __ Author: Bzehrou Date: Sat Feb
05 23:22:15 PST 2011 Hi Guys, I am new at Oracle and Toad ,as well. I Installed
Oracle 10 Ex on my computer local disk/C:(Windows 7) and I tried to connect to
database by Toad but it didn’t worked! I tried to log in as system user with
my password and following parameters: __ Author: mj_010101_312 Date: Wed Aug 03
13:34:23 PDT 2011 Message from: mj_010101_312 Not sure if this was resolved – I
ran into the same problem but got this fixed by ensure the install path to TOAD
not including any special char such as ( and … I have 64 bit machine and the
path to program files folder end with (x86) and that dcause the problem!
_______________________________________ Historical Messages Author:
mj_010101_312 Date: Wed Aug 03 13:34:23 PDT 2011 Not sure if this was resolved
– I ran into the same problem but got this fixed by ensure the install path to
TOAD not including any special char such as ( and … I have 64 bit machine and
the path to program files folder end with (x86) and that dcause the problem! __
Author: Bzehrou Date: Sun Feb 13 03:05:35 PST 2011 Hi Catbiter, Thanks for your
help ,however I still have the problem I correct the TNSNAMES.ora as bellow XE =
(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE) ) ) but I still getting
the Error ORA:06413 Connection Not Open error! as attached images Thanks again
Behrouz __ Author: Bzehrou Date: Sun Feb 13 03:05:35 PST 2011 [ Attachment(s)
from Bzehrou included below] Message from: Behseini Hi Catbiter, Thanks for your
help ,however I still have the problem I correct the TNSNAMES.ora as bellow XE =
(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE) ) ) but I still getting
the Error ORA:06413 Connection Not Open error! as attached images Thanks again
Behrouz _______________________________________ Historical Messages Author:
Bzehrou Date: Sun Feb 13 03:05:35 PST 2011 Hi Catbiter, Thanks for your help
,however I still have the problem I correct the TNSNAMES.ora as bellow XE =
(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE) ) ) but I still getting
the Error ORA:06413 Connection Not Open error! as attached images Thanks again
Behrouz __ Author: Win Chester Date: Mon Feb 07 07:42:25 PST 2011 Hi there
Connections to Oracle databases via TNS are a bit of a pain until you get all
the components in the link configured correctly. One issue that is often
overlooked is DNS resolution of the system name that is hosting the Oracle
database. If you are just using a single PC for Oracle and Toad then the
following options should fix the TNS connection issue:- If you are using a FIXED
IP address for the PC then substitute the IP address for the HOST name in the
TNSNAMES file. (example below) DATA1 = (DESCRIPTION = (ADDRESS = (PROTOCOL =
TCP)(HOST = 192.168.1.5)(PORT = 1522)) (CONNECT_DATA = (SERVER = DEDICATED)
(SERVICE_NAME = DATA1) ) If you are using DHCP for you IP address then you need
to use IP address 127.0.0.1 and have an entry in the HOSTS file of :- 127.0.0.1
localhost The TNSNAMES.ora file is found in the (oracle_home)/NETWORK/ADMIN
DIRECTORY and the windows hosts file is in the C:/windows/system32/drivers/etc
directory. Hope this fixes your probs. Regards __ Author: Bzehrou Date: Sat Feb
05 23:22:15 PST 2011 Hi Guys, I am new at Oracle and Toad ,as well. I Installed
Oracle 10 Ex on my computer local disk/C:(Windows 7) and I tried to connect to
database by Toad but it didn’t worked! I tried to log in as system user with
my password and following parameters: __ Author: Win Chester Date: Mon Feb 07
07:42:25 PST 2011 Hi there Connections to Oracle databases via TNS are a bit of
a pain until you get all the components in the link configured correctly. One
issue that is often overlooked is DNS resolution of the system name that is
hosting the Oracle database. If you are just using a single PC for Oracle and
Toad then the following options should fix the TNS connection issue:- If you are
using a FIXED IP address for the PC then substitute the IP address for the HOST
name in the TNSNAMES file. (example below) DATA1 = (DESCRIPTION = (ADDRESS =
(PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1522)) (CONNECT_DATA = (SERVER =
DEDICATED) (SERVICE_NAME = DATA1) ) If you are using DHCP for you IP address
then you need to use IP address 127.0.0.1 and have an entry in the HOSTS file of
:- 127.0.0.1 localhost The TNSNAMES.ora file is found in the
(oracle_home)/NETWORK/ADMIN DIRECTORY and the windows hosts file is in the
C:/windows/system32/drivers/etc directory. Hope this fixes your probs. Regards
__ Author: Bzehrou Date: Sat Feb 05 23:22:15 PST 2011 Hi Guys, I am new at
Oracle and Toad ,as well. I Installed Oracle 10 Ex on my computer local
disk/C:(Windows 7) and I tried to connect to database by Toad but it didn’t
worked! I tried to log in as system user with my password and following
parameters: __ Author: Bzehrou Date: Sun Feb 13 03:05:35 PST 2011 Hi Catbiter,
Thanks for your help ,however I still have the problem I correct the
TNSNAMES.ora as bellow XE = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =
127.0.0.1)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME =
XE) ) ) but I still getting the Error ORA:06413 Connection Not Open error! as
attached images Thanks again Behrouz __ Author: Bzehrou Date: Sun Feb 13
03:05:35 PST 2011 [ Attachment(s) from Bzehrou included below] Message from:
Behseini Hi Catbiter, Thanks for your help ,however I still have the problem I
correct the TNSNAMES.ora as bellow XE = (DESCRIPTION = (ADDRESS = (PROTOCOL =
TCP)(HOST = 127.0.0.1)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED)
(SERVICE_NAME = XE) ) ) but I still getting the Error ORA:06413 Connection Not
Open error! as attached images Thanks again Behrouz
_______________________________________ Historical Messages Author: Bzehrou
Date: Sun Feb 13 03:05:35 PST 2011 Hi Catbiter, Thanks for your help ,however I
still have the problem I correct the TNSNAMES.ora as bellow XE = (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) (CONNECT_DATA =
(SERVER = DEDICATED) (SERVICE_NAME = XE) ) ) but I still getting the Error
ORA:06413 Connection Not Open error! as attached images Thanks again Behrouz __
Author: Win Chester Date: Mon Feb 07 07:42:25 PST 2011 Hi there Connections to
Oracle databases via TNS are a bit of a pain until you get all the components in
the link configured correctly. One issue that is often overlooked is DNS
resolution of the system name that is hosting the Oracle database. If you are
just using a single PC for Oracle and Toad then the following options should fix
the TNS connection issue:- If you are using a FIXED IP address for the PC then
substitute the IP address for the HOST name in the TNSNAMES file. (example
below) DATA1 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =
192.168.1.5)(PORT = 1522)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME =
DATA1) ) If you are using DHCP for you IP address then you need to use IP
address 127.0.0.1 and have an entry in the HOSTS file of :- 127.0.0.1 localhost
The TNSNAMES.ora file is found in the (oracle_home)/NETWORK/ADMIN DIRECTORY and
the windows hosts file is in the C:/windows/system32/drivers/etc directory. Hope
this fixes your probs. Regards __ Author: Bzehrou Date: Sat Feb 05 23:22:15 PST
2011 Hi Guys, I am new at Oracle and Toad ,as well. I Installed Oracle 10 Ex on
my computer local disk/C:(Windows 7) and I tried to connect to database by Toad
but it didn’t worked! I tried to log in as system user with my password and
following parameters: __ Author: Win Chester Date: Mon Feb 07 07:42:25 PST 2011
Hi there Connections to Oracle databases via TNS are a bit of a pain until you
get all the components in the link configured correctly. One issue that is often
overlooked is DNS resolution of the system name that is hosting the Oracle
database. If you are just using a single PC for Oracle and Toad then the
following options should fix the TNS connection issue:- If you are using a FIXED
IP address for the PC then substitute the IP address for the HOST name in the
TNSNAMES file. (example below) DATA1 = (DESCRIPTION = (ADDRESS = (PROTOCOL =
TCP)(HOST = 192.168.1.5)(PORT = 1522)) (CONNECT_DATA = (SERVER = DEDICATED)
(SERVICE_NAME = DATA1) ) If you are using DHCP for you IP address then you need
to use IP address 127.0.0.1 and have an entry in the HOSTS file of :- 127.0.0.1
localhost The TNSNAMES.ora file is found in the (oracle_home)/NETWORK/ADMIN
DIRECTORY and the windows hosts file is in the C:/windows/system32/drivers/etc
directory. Hope this fixes your probs. Regards __ Author: Bzehrou Date: Sat Feb
05 23:22:15 PST 2011 Hi Guys, I am new at Oracle and Toad ,as well. I Installed
Oracle 10 Ex on my computer local disk/C:(Windows 7) and I tried to connect to
database by Toad but it didn’t worked! I tried to log in as system user with
my password and following parameters:
__

Author: mj_010101_312
Date: Wed Aug 03 13:34:23 PDT 2011

Not sure if this was resolved – I ran into the same problem but got this fixed
by ensure the install path to TOAD not including any special char such as ( and
… I have 64 bit machine and the path to program files folder end with (x86) and
that dcause the problem!

__

Author: Wim de lange
Date: Wed Aug 03 13:34:23 PDT 2011
It is not Toad, it is the wrong version of the Oracle client. Dont use anything
less then 10.0.4. The bug is there. Any application running in a directory with
parentheses in it, has problems with this client. Groetjes, Wim On Wed, Aug
3, 2011 at 22:34, mj_010101_312 wrote: Message from: mj_010101_312 Not sure
if this was resolved – I ran into the same problem but got this fixed by ensure
the install path to TOAD not including any special char such as ( and … I have
64 bit machine and the path to program files folder end with (x86) and that
dcause the problem! _______________________________________ Historical Messages
Author: mj_010101_312 Date: Wed Aug 03 13:34:23 PDT 2011 Not sure if this was
resolved – I ran into the same problem but got this fixed by ensure the install
path to TOAD not including any special char such as ( and … I have 64 bit
machine and the path to program files folder end with (x86) and that dcause the
problem! __ Author: Bzehrou Date: Sun Feb 13 03:05:35 PST 2011 Hi Catbiter,
Thanks for your help ,however I still have the problem I correct the
TNSNAMES.ora as bellow XE = (DESCRIPTION = (ADDRESS = (PROTOCOL =
TCP)(HOST = 127.0.0.1)(PORT = 1521)) (CONNECT_DATA = (SERVER =
DEDICATED) (SERVICE_NAME = XE) ) ) but I still getting the
Error ORA:06413 Connection Not Open error! as attached images Thanks again
Behrouz __ Author: Bzehrou Date: Sun Feb 13 03:05:35 PST 2011 [ Attachment(s)
from Bzehrou included below] Message from: Behseini Hi Catbiter, Thanks for your
help ,however I still have the problem I correct the TNSNAMES.ora as bellow XE =
(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE) ) ) but I still getting
the Error ORA:06413 Connection Not Open error! as attached images Thanks again
Behrouz _______________________________________ Historical Messages Author:
Bzehrou Date: Sun Feb 13 03:05:35 PST 2011 Hi Catbiter, Thanks for your help
,however I still have the problem I correct the TNSNAMES.ora as bellow XE =
(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE) ) ) but I still getting
the Error ORA:06413 Connection Not Open error! as attached images Thanks again
Behrouz __ Author: Win Chester Date: Mon Feb 07 07:42:25 PST 2011 Hi there
Connections to Oracle databases via TNS are a bit of a pain until you get all
the components in the link configured correctly. One issue that is often
overlooked is DNS resolution of the system name that is hosting the Oracle
database. If you are just using a single PC for Oracle and Toad then the
following options should fix the TNS connection issue:- If you are using a FIXED
IP address for the PC then substitute the IP address for the HOST name in the
TNSNAMES file. (example below) DATA1 = (DESCRIPTION = (ADDRESS = (PROTOCOL =
TCP)(HOST = 192.168.1.5)(PORT = 1522)) (CONNECT_DATA = (SERVER = DEDICATED)
(SERVICE_NAME = DATA1) ) If you are using DHCP for you IP address then you need
to use IP address 127.0.0.1 and have an entry in the HOSTS file of :- 127.0.0.1
localhost The TNSNAMES.ora file is found in the (oracle_home)/NETWORK/ADMIN
DIRECTORY and the windows hosts file is in the C:/windows/system32/drivers/etc
directory. Hope this fixes your probs. Regards __ Author: Bzehrou Date: Sat Feb
05 23:22:15 PST 2011 Hi Guys, I am new at Oracle and Toad ,as well. I Installed
Oracle 10 Ex on my computer local disk/C:(Windows 7) and I tried to connect to
database by Toad but it didn’t worked! I tried to log in as system user with
my password and following parameters: __ Author: Win Chester Date: Mon Feb 07
07:42:25 PST 2011 Hi there Connections to Oracle databases via TNS are a bit of
a pain until you get all the components in the link configured correctly. One
issue that is often overlooked is DNS resolution of the system name that is
hosting the Oracle database. If you are just using a single PC for Oracle and
Toad then the following options should fix the TNS connection issue:- If you are
using a FIXED IP address for the PC then substitute the IP address for the HOST
name in the TNSNAMES file. (example below) DATA1 = (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1522))
(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME =
DATA1) ) If you are using DHCP for you IP address then you need to use IP
address 127.0.0.1 and have an entry in the HOSTS file of :- 127.0.0.1
localhost The TNSNAMES.ora file is found in the (oracle_home)/NETWORK/ADMIN
DIRECTORY and the windows hosts file is in the C:/windows/system32/drivers/etc
directory. Hope this fixes your probs. Regards __ Author: Bzehrou Date: Sat Feb
05 23:22:15 PST 2011 Hi Guys, I am new at Oracle and Toad ,as well. I Installed
Oracle 10 Ex on my computer local disk/C:(Windows 7) and I tried to connect to
database by Toad but it didn’t worked! I tried to log in as system user with
my password and following parameters:
__

Author: mj_010101_312
Date: Wed Aug 03 13:34:23 PDT 2011
Message from: mj_010101_312 Not sure if this was resolved – I ran into the same
problem but got this fixed by ensure the install path to TOAD not including any
special char such as ( and … I have 64 bit machine and the path to program
files folder end with (x86) and that dcause the problem!
_______________________________________ Historical Messages Author:
mj_010101_312 Date: Wed Aug 03 13:34:23 PDT 2011 Not sure if this was resolved
– I ran into the same problem but got this fixed by ensure the install path to
TOAD not including any special char such as ( and … I have 64 bit machine and
the path to program files folder end with (x86) and that dcause the problem! __
Author: Bzehrou Date: Sun Feb 13 03:05:35 PST 2011 Hi Catbiter, Thanks for your
help ,however I still have the problem I correct the TNSNAMES.ora as bellow XE =
(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE) ) ) but I still getting
the Error ORA:06413 Connection Not Open error! as attached images Thanks again
Behrouz __ Author: Bzehrou Date: Sun Feb 13 03:05:35 PST 2011 [ Attachment(s)
from Bzehrou included below] Message from: Behseini Hi Catbiter, Thanks for your
help ,however I still have the problem I correct the TNSNAMES.ora as bellow XE =
(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE) ) ) but I still getting
the Error ORA:06413 Connection Not Open error! as attached images Thanks again
Behrouz _______________________________________ Historical Messages Author:
Bzehrou Date: Sun Feb 13 03:05:35 PST 2011 Hi Catbiter, Thanks for your help
,however I still have the problem I correct the TNSNAMES.ora as bellow XE =
(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE) ) ) but I still getting
the Error ORA:06413 Connection Not Open error! as attached images Thanks again
Behrouz __ Author: Win Chester Date: Mon Feb 07 07:42:25 PST 2011 Hi there
Connections to Oracle databases via TNS are a bit of a pain until you get all
the components in the link configured correctly. One issue that is often
overlooked is DNS resolution of the system name that is hosting the Oracle
database. If you are just using a single PC for Oracle and Toad then the
following options should fix the TNS connection issue:- If you are using a FIXED
IP address for the PC then substitute the IP address for the HOST name in the
TNSNAMES file. (example below) DATA1 = (DESCRIPTION = (ADDRESS = (PROTOCOL =
TCP)(HOST = 192.168.1.5)(PORT = 1522)) (CONNECT_DATA = (SERVER = DEDICATED)
(SERVICE_NAME = DATA1) ) If you are using DHCP for you IP address then you need
to use IP address 127.0.0.1 and have an entry in the HOSTS file of :- 127.0.0.1
localhost The TNSNAMES.ora file is found in the (oracle_home)/NETWORK/ADMIN
DIRECTORY and the windows hosts file is in the C:/windows/system32/drivers/etc
directory. Hope this fixes your probs. Regards __ Author: Bzehrou Date: Sat Feb
05 23:22:15 PST 2011 Hi Guys, I am new at Oracle and Toad ,as well. I Installed
Oracle 10 Ex on my computer local disk/C:(Windows 7) and I tried to connect to
database by Toad but it didn’t worked! I tried to log in as system user with
my password and following parameters: __ Author: Win Chester Date: Mon Feb 07
07:42:25 PST 2011 Hi there Connections to Oracle databases via TNS are a bit of
a pain until you get all the components in the link configured correctly. One
issue that is often overlooked is DNS resolution of the system name that is
hosting the Oracle database. If you are just using a single PC for Oracle and
Toad then the following options should fix the TNS connection issue:- If you are
using a FIXED IP address for the PC then substitute the IP address for the HOST
name in the TNSNAMES file. (example below) DATA1 = (DESCRIPTION = (ADDRESS =
(PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1522)) (CONNECT_DATA = (SERVER =
DEDICATED) (SERVICE_NAME = DATA1) ) If you are using DHCP for you IP address
then you need to use IP address 127.0.0.1 and have an entry in the HOSTS file of
:- 127.0.0.1 localhost The TNSNAMES.ora file is found in the
(oracle_home)/NETWORK/ADMIN DIRECTORY and the windows hosts file is in the
C:/windows/system32/drivers/etc directory. Hope this fixes your probs. Regards
__ Author: Bzehrou Date: Sat Feb 05 23:22:15 PST 2011 Hi Guys, I am new at
Oracle and Toad ,as well. I Installed Oracle 10 Ex on my computer local
disk/C:(Windows 7) and I tried to connect to database by Toad but it didn’t
worked! I tried to log in as system user with my password and following
parameters:
__

Author: Bzehrou
Date: Sun Feb 13 03:05:35 PST 2011
Hi Catbiter,
Thanks for your help ,however I still have the problem
I correct the TNSNAMES.ora as bellow

XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
but I still getting the Error ORA:06413 Connection Not Open error!
as attached images
Thanks again
Behrouz

__

Author: Bzehrou
Date: Sun Feb 13 03:05:35 PST 2011
[ Attachment(s) from Bzehrou included below] Message from: Behseini Hi Catbiter,
Thanks for your help ,however I still have the problem I correct the
TNSNAMES.ora as bellow XE = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =
127.0.0.1)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME =
XE) ) ) but I still getting the Error ORA:06413 Connection Not Open error! as
attached images Thanks again Behrouz _______________________________________
Historical Messages Author: Bzehrou Date: Sun Feb 13 03:05:35 PST 2011 Hi
Catbiter, Thanks for your help ,however I still have the problem I correct the
TNSNAMES.ora as bellow XE = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =
127.0.0.1)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME =
XE) ) ) but I still getting the Error ORA:06413 Connection Not Open error! as
attached images Thanks again Behrouz __ Author: Win Chester Date: Mon Feb 07
07:42:25 PST 2011 Hi there Connections to Oracle databases via TNS are a bit of
a pain until you get all the components in the link configured correctly. One
issue that is often overlooked is DNS resolution of the system name that is
hosting the Oracle database. If you are just using a single PC for Oracle and
Toad then the following options should fix the TNS connection issue:- If you are
using a FIXED IP address for the PC then substitute the IP address for the HOST
name in the TNSNAMES file. (example below) DATA1 = (DESCRIPTION = (ADDRESS =
(PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1522)) (CONNECT_DATA = (SERVER =
DEDICATED) (SERVICE_NAME = DATA1) ) If you are using DHCP for you IP address
then you need to use IP address 127.0.0.1 and have an entry in the HOSTS file of
:- 127.0.0.1 localhost The TNSNAMES.ora file is found in the
(oracle_home)/NETWORK/ADMIN DIRECTORY and the windows hosts file is in the
C:/windows/system32/drivers/etc directory. Hope this fixes your probs. Regards
__ Author: Bzehrou Date: Sat Feb 05 23:22:15 PST 2011 Hi Guys, I am new at
Oracle and Toad ,as well. I Installed Oracle 10 Ex on my computer local
disk/C:(Windows 7) and I tried to connect to database by Toad but it didn’t
worked! I tried to log in as system user with my password and following
parameters:
__

Author: Win Chester
Date: Mon Feb 07 07:42:25 PST 2011

Hi there

Connections to Oracle databases via TNS are a bit of a pain until you get all
the components in the link configured correctly. One issue that is often
overlooked is DNS resolution of the system name that is hosting the Oracle
database.

If you are just using a single PC for Oracle and Toad then the following options
should fix the TNS connection issue:-

If you are using a FIXED IP address for the PC then substitute the IP address
for the HOST name in the TNSNAMES file. (example below)

DATA1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = DATA1)
)

If you are using DHCP for you IP address then you need to use IP address
127.0.0.1 and have an entry in the HOSTS file of :- 127.0.0.1 localhost

The TNSNAMES.ora file is found in the (oracle_home)/NETWORK/ADMIN DIRECTORY and
the windows hosts file is in the C:/windows/system32/drivers/etc directory.

Hope this fixes your probs.

Regards

__

Author: Bzehrou
Date: Sat Feb 05 23:22:15 PST 2011
Hi Guys,

I am new at Oracle and Toad ,as well. I Installed Oracle 10 Ex on my computer
local disk/C:(Windows 7) and I tried to connect to database by Toad but it
didn’t worked!
I tried to log in as system user with my password and following parameters:

try to change
connection as: sysdba to else
may be that will work