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: