Mark Forums Read

Unable to connect DBOracle10g from DOS/command prompt

Go Back

comp.databases.oracle.server comp.databases.oracle.server

Reply

#1

Old

BeginnerDBA

Posts: n/a

Unable to connect DBOracle10g from DOS/command prompt - 06-16-2008 , 02:21 PM

Hi All,

I have been trying to connect by using DOS/command Prompt to my
database, but I get an TNS--03505 error. What is weird is I get
connection withour any problems from my SQL*plus....I checked my
listener.ora, sqlnet.ora, and tnsnames.ora and they seem to be working
ok.
Any idea why is this happening?
Thanks.

Reply With Quote

#2

Old

fitzjarrell@cox.net

Posts: n/a

Re: Unable to connect DBOracle10g from DOS/command prompt - 06-16-2008 , 02:36 PM

On Jun 16, 2:21*pm, BeginnerDBA <hpcasal... (AT) gmail (DOT) com> wrote:

Quote:

Hi All,

I have been trying to connect by using DOS/command Prompt to my
database, but I get an TNS--03505 error. What is weird is I get
connection withour any problems from my SQL*plus....I checked my
listener.ora, sqlnet.ora, and tnsnames.ora and they seem to be working
ok.
Any idea why is this happening?
Thanks.

What are you talking about??? From the DOS/Command prompt one usually
uses SQL*Plus to connect to a database. If you can connect through
SQL*Plus I can't understand what you're doing at the command prompt
when trying to connect to your Oracle database.

David Fitzjarrell

Reply With Quote

#3

Old

fitzjarrell@cox.net

Posts: n/a

Re: Unable to connect DBOracle10g from DOS/command prompt - 06-16-2008 , 02:36 PM

On Jun 16, 2:21*pm, BeginnerDBA <hpcasal... (AT) gmail (DOT) com> wrote:

Quote:

Hi All,

I have been trying to connect by using DOS/command Prompt to my
database, but I get an TNS--03505 error. What is weird is I get
connection withour any problems from my SQL*plus....I checked my
listener.ora, sqlnet.ora, and tnsnames.ora and they seem to be working
ok.
Any idea why is this happening?
Thanks.

What are you talking about??? From the DOS/Command prompt one usually
uses SQL*Plus to connect to a database. If you can connect through
SQL*Plus I can't understand what you're doing at the command prompt
when trying to connect to your Oracle database.

David Fitzjarrell

Reply With Quote

#4

Old

fitzjarrell@cox.net

Posts: n/a

Re: Unable to connect DBOracle10g from DOS/command prompt - 06-16-2008 , 02:36 PM

On Jun 16, 2:21*pm, BeginnerDBA <hpcasal... (AT) gmail (DOT) com> wrote:

Quote:

Hi All,

I have been trying to connect by using DOS/command Prompt to my
database, but I get an TNS--03505 error. What is weird is I get
connection withour any problems from my SQL*plus....I checked my
listener.ora, sqlnet.ora, and tnsnames.ora and they seem to be working
ok.
Any idea why is this happening?
Thanks.

What are you talking about??? From the DOS/Command prompt one usually
uses SQL*Plus to connect to a database. If you can connect through
SQL*Plus I can't understand what you're doing at the command prompt
when trying to connect to your Oracle database.

David Fitzjarrell

Reply With Quote

#5

Old

fitzjarrell@cox.net

Posts: n/a

Re: Unable to connect DBOracle10g from DOS/command prompt - 06-16-2008 , 02:36 PM

On Jun 16, 2:21*pm, BeginnerDBA <hpcasal... (AT) gmail (DOT) com> wrote:

Quote:

Hi All,

I have been trying to connect by using DOS/command Prompt to my
database, but I get an TNS--03505 error. What is weird is I get
connection withour any problems from my SQL*plus....I checked my
listener.ora, sqlnet.ora, and tnsnames.ora and they seem to be working
ok.
Any idea why is this happening?
Thanks.

What are you talking about??? From the DOS/Command prompt one usually
uses SQL*Plus to connect to a database. If you can connect through
SQL*Plus I can't understand what you're doing at the command prompt
when trying to connect to your Oracle database.

David Fitzjarrell

Reply With Quote

#6

Old

fitzjarrell@cox.net

Posts: n/a

Re: Unable to connect DBOracle10g from DOS/command prompt - 06-16-2008 , 02:36 PM

On Jun 16, 2:21*pm, BeginnerDBA <hpcasal... (AT) gmail (DOT) com> wrote:

Quote:

Hi All,

I have been trying to connect by using DOS/command Prompt to my
database, but I get an TNS--03505 error. What is weird is I get
connection withour any problems from my SQL*plus....I checked my
listener.ora, sqlnet.ora, and tnsnames.ora and they seem to be working
ok.
Any idea why is this happening?
Thanks.

What are you talking about??? From the DOS/Command prompt one usually
uses SQL*Plus to connect to a database. If you can connect through
SQL*Plus I can't understand what you're doing at the command prompt
when trying to connect to your Oracle database.

David Fitzjarrell

Reply With Quote

#7

Old

fitzjarrell@cox.net

Posts: n/a

Re: Unable to connect DBOracle10g from DOS/command prompt - 06-16-2008 , 02:36 PM

On Jun 16, 2:21*pm, BeginnerDBA <hpcasal... (AT) gmail (DOT) com> wrote:

Quote:

Hi All,

I have been trying to connect by using DOS/command Prompt to my
database, but I get an TNS--03505 error. What is weird is I get
connection withour any problems from my SQL*plus....I checked my
listener.ora, sqlnet.ora, and tnsnames.ora and they seem to be working
ok.
Any idea why is this happening?
Thanks.

What are you talking about??? From the DOS/Command prompt one usually
uses SQL*Plus to connect to a database. If you can connect through
SQL*Plus I can't understand what you're doing at the command prompt
when trying to connect to your Oracle database.

David Fitzjarrell

Reply With Quote

#8

Old

fitzjarrell@cox.net

Posts: n/a

Re: Unable to connect DBOracle10g from DOS/command prompt - 06-16-2008 , 02:36 PM

On Jun 16, 2:21*pm, BeginnerDBA <hpcasal... (AT) gmail (DOT) com> wrote:

Quote:

Hi All,

I have been trying to connect by using DOS/command Prompt to my
database, but I get an TNS--03505 error. What is weird is I get
connection withour any problems from my SQL*plus....I checked my
listener.ora, sqlnet.ora, and tnsnames.ora and they seem to be working
ok.
Any idea why is this happening?
Thanks.

What are you talking about??? From the DOS/Command prompt one usually
uses SQL*Plus to connect to a database. If you can connect through
SQL*Plus I can't understand what you're doing at the command prompt
when trying to connect to your Oracle database.

David Fitzjarrell

Reply With Quote

Reply

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.