Help for sql-oracle mode

Help for sql-oracle mode

[misskiss wang]

[-- Attachment #1: Type: text/plain, Size: 819 bytes --]

Dear Friends,
I like to using sql-oracle in emacs, but now I met a problem: The database I
logged on no need to input username and password, both fields are empty. If
I ran M-x sql-oracle in emacs, and I press ENTER butter two times and then
input Server string, for example like DB1, I got an error like this:

*SQL*Plus: Release 10.2.0.2.0 - Production on Thu Feb 28 14:03:40 2008*

*Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.*

*Enter user-name:
ERROR:
ORA-12560: TNS:protocol adapter error*


*Enter user-name:
ERROR:
ORA-12560: TNS:protocol adapter error*


*Enter user-name:
ERROR:
ORA-12560: TNS:protocol adapter error*


*SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus*

*Process SQL exited abnormally with code 1*

Is there any solution for this? Thanks a lot!

Misskiss

[-- Attachment #2: Type: text/html, Size: 1208 bytes --]

Re: Help for sql-oracle mode

[Tim X]

"misskiss wang" <misskiss.wang@gmail.com> writes:

> Dear Friends,
>
> I like to using sql-oracle in emacs, but now I met a problem: The database I
> logged on no need to input username and password, both fields are empty. If I
> ran M-x sql-oracle in emacs, and I press ENTER butter two times and then input
> Server string, for example like DB1, I got an error like this:
>
> SQL*Plus: Release 10.2.0.2.0 - Production on Thu Feb 28 14:03:40 2008
>
> Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
>
> Enter user-name:
> ERROR:
> ORA-12560: TNS:protocol adapter error
>
> Enter user-name:
> ERROR:
> ORA-12560: TNS:protocol adapter error
>
> Enter user-name:
> ERROR:
> ORA-12560: TNS:protocol adapter error
>
> SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
>
> Process SQL exited abnormally with code 1
>

Can you access the database just running SQL-Plus? Oracle is natorious
for providing misleading error messages. For example, you will get that
same error message if you specify the wrong SID. The first thing I wold
do is try 

sqlplus DB1

and hit enter when prompted for the username and password. If that
works, then we know the problem isn't with Oracle and have to look
closer at sqlplus. 

Tim

P.S.

I've never seen an Oracle database that didn't require a username - the
username determines the schema - I guess you can have one, just never
come across it before. 
-- 
tcross (at) rapttech dot com dot au

Re: Help for sql-oracle mode

[Misskiss]

Tim X <timx@nospam.dev.null> writes:

> "misskiss wang" <misskiss.wang@gmail.com> writes:
>
>> Dear Friends,
>>
>> I like to using sql-oracle in emacs, but now I met a problem: The database I
>> logged on no need to input username and password, both fields are empty. If I
>> ran M-x sql-oracle in emacs, and I press ENTER butter two times and then input
>> Server string, for example like DB1, I got an error like this:
>>
>> SQL*Plus: Release 10.2.0.2.0 - Production on Thu Feb 28 14:03:40 2008
>>
>> Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
>>
>> Enter user-name:
>> ERROR:
>> ORA-12560: TNS:protocol adapter error
>>
>> Enter user-name:
>> ERROR:
>> ORA-12560: TNS:protocol adapter error
>>
>> Enter user-name:
>> ERROR:
>> ORA-12560: TNS:protocol adapter error
>>
>> SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
>>
>> Process SQL exited abnormally with code 1
>>
>
> Can you access the database just running SQL-Plus? Oracle is natorious
> for providing misleading error messages. For example, you will get that
> same error message if you specify the wrong SID. The first thing I wold
> do is try 
>
> sqlplus DB1
>
> and hit enter when prompted for the username and password. If that
> works, then we know the problem isn't with Oracle and have to look
> closer at sqlplus. 
>
> Tim
>
> P.S.
>
> I've never seen an Oracle database that didn't require a username - the
> username determines the schema - I guess you can have one, just never
> come across it before. 
> -- 
> tcross (at) rapttech dot com dot au
>

Thanks a lot for the help! I tried "sqlplus DB1", it's the same problem,
I still cannot login DB server. However, if I use a GUI tool to login
the server, leave both user name and password as blank, I can login the
server. It's really unconvininet for me... Is there any good solutions?

Thanks a lot!

Misskiss
-- 

You are always busy.

Re: Help for sql-oracle mode

[Tim X]

Misskiss <misskiss.wang@gmail.com> writes:

> Tim X <timx@nospam.dev.null> writes:
>
>>
>> Can you access the database just running SQL-Plus? Oracle is natorious
>> for providing misleading error messages. For example, you will get that
>> same error message if you specify the wrong SID. The first thing I wold
>> do is try 
>>
>> sqlplus DB1
>>
>> and hit enter when prompted for the username and password. If that
>> works, then we know the problem isn't with Oracle and have to look
>> closer at sqlplus. 
>>
>> Tim
>>
>> P.S.
>>
>> I've never seen an Oracle database that didn't require a username - the
>> username determines the schema - I guess you can have one, just never
>> come across it before. 
>> -- 
>> tcross (at) rapttech dot com dot au
>>
>
> Thanks a lot for the help! I tried "sqlplus DB1", it's the same problem,
> I still cannot login DB server. However, if I use a GUI tool to login
> the server, leave both user name and password as blank, I can login the
> server. It's really unconvininet for me... Is there any good solutions?
>
> Thanks a lot!
>

You could try starting sqlplus and then use its internal command to
connect to a database (sorry, can't remember exactly what its called and
I don't have sqlplus here). 

Another alternative would be to see if you can find out what/how the GUI
tool is doing it - possible if youhave the sources. 

Apart from that, I would try specifying just the schema name for the
username and a blank password. This might work as the username usually
determines what schema within the database instance you access. It could
be that if you don't specify a user, sqlplus doesn't know what schema to
log you into. Oracle is a bit different from other databases in that
different users normally have different schemas. To some extent, a
'database' in oracle speak is really an instance of the DBMS and each
schema is similar to what other DBMSs would call a database. I've worked
on sites where there is only one Oracle 'instance' which has many
'databases' and its the username that specifies the database. 

Of course, the real solution is to have a username and password. Its
extremely unusual to have an Oracle database without either. I actually
find it very unusual to be using Oracle and have a totally open
database. Its not the sort of DBMS you would use for trivial jobs and
most more serious jobs require som level of security. Are you certain
there is no username and password? Is it possible that the GUI tool you
use to access without one actually has a username/password configured
somewhere and it just uses that if you don't provide one?

The other thing to look at would be the sqlplus manual. Its possible
that there is a way to put stuff in the rc file that will make this
work. The other thing to look at is the database itself. Oracle has a
number of settings that control who can create sessions and limits on
those sessions. It is possible that the GUI tool uses a diffeent
connection method to sqlplus (Oracle supports many different connection
methods) and that you can only connect without a username/password if
you are using a specific method. If your not the DBA, then I would
definitely talk to the DBA regarding this. Oracle is a huge complex
beast and you really need to know how it has been configured for the
specific database your trying to use. 

HTH

Tim

> -- 
>
> You are always busy.
>
I'm usually busy procrastenating - very tiring!
>
>

-- 
tcross (at) rapttech dot com dot au

Re: Help for sql-oracle mode

[Anders Wirzenius]

Misskiss <misskiss.wang@gmail.com> writes:

> Tim X <timx@nospam.dev.null> writes:
> 
> > "misskiss wang" <misskiss.wang@gmail.com> writes:
> >
> > Can you access the database just running SQL-Plus? Oracle is natorious
> > for providing misleading error messages. For example, you will get that
> > same error message if you specify the wrong SID. The first thing I wold
> > do is try 
> >
> > sqlplus DB1
> >
> > and hit enter when prompted for the username and password. If that
> > works, then we know the problem isn't with Oracle and have to look
> > closer at sqlplus. 
> >
> > Tim
> >
> > P.S.
> >
> > I've never seen an Oracle database that didn't require a username - the
> > username determines the schema - I guess you can have one, just never
> > come across it before. 
> > -- 
> > tcross (at) rapttech dot com dot au
> >
> 
> Thanks a lot for the help! I tried "sqlplus DB1", it's the same problem,
> I still cannot login DB server. However, if I use a GUI tool to login
> the server, leave both user name and password as blank, I can login the
> server. It's really unconvininet for me... Is there any good solutions?
> 
> Thanks a lot!
> 
> Misskiss

Just my 2 cnts:
Maybe your network uses a single login system and your credentials
are fetched from the Active Domain when using a GUI tool?

-- 
Anders