OS Authentication on NT from Linux - Generic Linux

I can't get in to the Oracle data base running on an NT server that is using OS Authentication.
On an NT box, if I type
sqlplus /#xxxxxxxx
where xxxxxxxx is the name of the database, I get in without a problem. But this doesn't work on Linux.
Is there any way I get around this?
Thanks. 

 <BLOCKQUOTE><font size="1" face="Verdana, Arial">quote:</font><HR>Originally posted by Richard Bilonick (rickbilonick#consolenergy.com):
I can't get in to the Oracle data base running on an NT server that is using OS Authentication.
On an NT box, if I type
sqlplus /#xxxxxxxx
where xxxxxxxx is the name of the database, I get in without a problem. But this doesn't work on Linux.
Is there any way I get around this?
Thanks.<HR></BLOCKQUOTE>
on linux i found you have to use your full path to have it hook in with id & passwd. ie sqlplus system/manager#oralin.mybox.com if this is what your looking for. 

I already have tried what you suggest and it doesn't work.(I've x'd out some things for saftey.)
Apparently I have to be logged into the proper domain. When I log in from an NT box I log in to a specific domain. Is there someway to do this in Linux?
(I have the tnsnames.ora file correctly set up and it links the data base to the server. I can access Windows network shares, mount them, etc. I can ping the NT server.)
[xxxxxxx#rbilonick xxxxx]$ sqlplus xxxxxxx/xxxxxx#xxxxxxxx
SQL*Plus: Release 8.1.6.0.0 - Production on Mon Apr 2 12:57:40 2001
(c) Copyright 1999 Oracle Corporation. All rights reserved.
ERROR:
ORA-12154: TNS:could not resolve service name
Enter user-name: xxxxxxx
Enter password:
ERROR:
ORA-03113: end-of-file on communication channel
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus 

You are correct that if you want to use native OS authentication on NT/2000, you'll need some way other than Oracle to log your Linux clients into the network. This is the downside of using OS authentication.
What you may try is SAMBA, which provides the necessary transport for a Unix client to log into an NT domain. Or, you might use 2000, Active Directory and use Directory Service authentication. But you can't do it solely at the SQLplus client level.
Note that this is not a bug. In a strict OSI model, it is not the responsibility of the application (SQLPlus) to authenticate you to the network (which is what you are asking for in native authetication for Windows). The client assumes that you are authenticated to the network via some other application.
null 

You might also want to try using pam_smb along with Samba. pam_smb is a PAM module/server which allows authentication of UNIX users using an NT server. http://www.csn.ul.ie/~airlied/pam_smb/
Thanks,
Mike

Related

XE Database Connection

Dear Experts:
I had installed the Oracle 10g product, and I had created three tables and filled them with some data, i tested the content from the SQL windows, and all is OK. even more i installed the ODBC in the same server where I installed the XE database and i could test the connection correctly.
Now i am trying to do the same ODBC client connection from another terminal in the network in order to test this part of my testing configuration and it doesn´t work.
I saw a little difference when i´d tried to create the ODBC if i am on the server i see an XE ODBC driver, but if i´m on another terminal i ONLY see:
Oracle in OraClient10g_home1.
I followed the same procedure, i completed the fields with the same information but if i test the database connection it does not work.
If You have any idea about what am i doing wrong or missing, i´ll be very grateful.
Thanks in advance.
Sincerely. Hugo COLOMBO 
the same ODBC client connection from another terminal in the networkAre you able to connect using Sql*Plus from that machine ? 
Does the other machine have an Oracle client installed? 
Dear Mr. Bill C Ennis
207349      ennisb
Name:      Bill C Ennis
The answer is YES, because when i installed the Oracle Database 10g Client, then appeared the Oracle in OraClient 10g_home1 option, who never was previously in the Create a new data . . . in the DSN Add Botton Window.
This fact occurs in the same way from two different Windows XP terminals, neverthless in the Oracle DataBase Server machine.
So, i suppose that i´m dooing something wrong or at less i had omitterdsome steps, such as a database publishing procedure at de data base server machine. ???. . ..
So if You have any idea it will be EXCELENT.
Thank You in advance.
Sincerely. Hugo COLOMBO 
Dear Mr. Paul M.
I´m very worried with your question, because i had installed the Oracle 10g Client, through the Oracle Universal Installer , and I can see in the windows which appears at the end of the installation, reporting al tha software installed and i can see a line related to the SQL*Plus products, but i try to locate the sqlplus.exe thru the windows explorer and i couldn`t find it in my disk and i have administrator privileges.
So that i can not test this king of connections.
If you have any other idea or guidance i´ll be very grateful with you.
Thank You gain in advance for your help.
Sincerely. Hugo COLOMBO 
Assuming you have Oracle environment adequately set, at least ORACLE_HOME and PATH, did you try to execute sqlplus from command line ?
C:\> sqlplus
what happens ? 
Dear Mr. Paul M.
Really considering your initial comment i went back thru my steps and i repeated the Oracle 10g Client installation procedure and in this case i selected the complete installation not the small one, as in the previous case and i got the SQL*Plus softwarfe and i´d tried to connect according to your advice to the XE database, and i got the following answer
ERROR:
ORA-12154: TNS:listener does not currently lnow of service requested in connect descriptor.
I had used the SYSTEM user for this testing, and at the same time i had tested even using the IP address for the "Jost String".
In other research line i tested the connection, creating an ODBC one and using as
Data Source: XE
Description is not important
TNS Service Name: XE
and User ID: SYSTEM
Then i had pressed the test botton
and in the Oracle ODBC driver Connect window i loaded:
Service Name : XE
User Name SYSTEM
and the PASSWORD employed on the Server.
NOTE: Al this information agreed completely with that entered in the Server.
getting the following connection error (which is the same as previous one).
Unable to connect
SQLState=08004
[Oracle][ODBC][Ora]Ora-12154:TNS:could not resolve the connect identifier specified
One additional comment, i have not loaded the lmhosts file neither the host file in the terminal, neverthless i can see the server thru the Network explorer and there appear the Server and even i can see a Shared Printer on them.
So, if You have any idea i´ll be grateful again.
Sincerely. Hugo COLOMBO 
Dear Mr. Paul M.
I had reviewed your new advice and i tried thru the Windows console, and got the following answer:
Microsoft Windows XP [Versión 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
C:\Documents and Settings\Hugo>cd \
C:\>sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jul 13 13:01:07 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter user-name: SYSTEM
Enter password:
ERROR:
ORA-12560: TNS:protocol adapter error
Enter user-name:
I had tried the password with and without capital letters, just in case.
In other point I got the PATH for the Terminal, which is:
C:\>path
PATH=C:\oracle\product\10.2.0\client_2\bin;C:\oracle\product\10.2.0\client_1;C:\
WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;c:\Archivos de programa\Archivos comunes\Adobe\AGL;C:\Archivos de programa\Symantec\pcAnywhere\;C:\Archivos
de programa\Archivos comunes\Autodesk Shared\;C:\Archivos de programa\Autodesk\
backburner\
C:\>
and for the SERVER:
Microsoft Windows 2000 [Versión 5.00.2195]
(C) Copyright 1985-2000 Microsoft Corp.
C:\>path
PATH=D:\oracle\product\10.2.0\client_3;D:\oraclexe\app\oracle\product\10.2.0\ser
ver\bin;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem
C:\>
AND SOME VERY VERY IMPORTANT: i have not stated the ORACLE_HOME directory, neither in the Terminal , neither in the SERVER, could You tell me which is an adecuate one?
Thank You AGAIN.
sincerely. Hugo COLOMBO 
Two things :
if sqlplus command works (you don't get an error like "command not found" or so) then your environment is OK. I did ask you for that just to check it out.
Then, to connect to your remote DB you need to configure a TNS alias (connection string), you can use Net Configuration Assistant, within Oracle menu. Once created, you can connect as
C:\> sqlplus system/manager#<TNS alias>
or whatever user/password you use. When this works you can try with ODBC. 
Dear Mr. Bill C Ennis
The answer is YES, both terminals, has a COMPLETE installation, and in both cases i receive this messages:
"...
Unable to connect
SQLState=08004
[Oracle][ODBC][Ora]Ora-12154:TNS:could not resolve the connect identifier specified
..."
Even more i had tried from the SQLPlus botrh from the icon and from the Windows console and i got the following messages:
". . . . (From the windows Console)
C:\>sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jul 13 13:01:07 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter user-name: SYSTEM
Enter password:
ERROR:
ORA-12560: TNS:protocol adapter error
Enter user-name: SYSTEM
Enter password:
ERROR:
ORA-12560: TNS:protocol adapter error
Enter user-name:
. . . ."
". . . (From the SQLPlus icon)
ERROR:
ORA-12154: TNS:listener does not currently lnow of service requested in connect descriptor.
. . ."
as You can see is the same error code in them.
Thank You again .
Sincerely,. Hugo COLOMBO

remote session db user connection

we have Oracle 8i on windows 2003 server..
When I am accessing the machine via remote session and connecting with database I am getting below errors
C:\Documents and Settings\Administrator>sqlplus
SQL*Plus: Release 8.1.7.0.0 - Production on Wed Dec 8 17:49:10 2010
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Enter user-name: / as sysdba
ERROR:
ORA-12560: TNS:protocol adapter error
Enter user-name: / as sysdba
ERROR:
ORA-12560: TNS:protocol adapter error
Enter user-name: erp/erp5790
ERROR:
ORA-12560: TNS:protocol adapter error
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
C:\Documents and Settings\Administrator> 
we have Oracle 8i on windows 2003 server..obsoleted & unsupported combination
ORA-12560: TNS:protocol adapter errorcan occur when OS Database Service has not been started.
Is any type of Operating System Virtualization installed on this system. 
When I am connecting from the server, its working fine, I dont understand why I am getting error while connecting via remote session. 
Check your ORACLE_HOME and ORACLE_SID environment variables in session 
Hi,
Have a configured netmanager(tns) entry on remote server which points to the the database service?
Regards,
khaja 
When I am connecting from the server, its working fine,even using SQL*Net?
post proof.
When was last time remote system connected OK?
What changed? 
I have set it, but same error.. 
sb92075 wrote:
When I am connecting from the server, its working fine,even using SQL*Net?
post proof.
When was last time remote system connected OK?
What changed?I am connecting first time to database via remote session.. 
Is you user you logged in ora_dba group? 
when I check at server, I can find only administrator user in ORA_DBA group. 
hi,
Please paste the exact command through which you are trying to connect the remote server..
Regards,
khaja 
This is a symptom for Oracle v 8.1.7.0 and platform windows,du to you can not perform you operation like.As remember that early you had this problem and i gave answer for you.Your solution is:you can use netservices(tnsalias) or you have to perform these operation directly database server without remote session(service).In additionally please refer below doc.
*Database Creation or Connection Fails with ORA-12560 or ORA-24314 using XP'S Remote Desktop Services [ID 274565.1]*+ 
Viacheslav Ostapenko wrote:
Is you user you logged in ora_dba group?he's trying to connect from a remote client vin TNS You keep asking questions that apply only to local IPC connections.

ORA-12560: TNS:protocol adapter error

Hi all,
I'm unable to connect without host string.But when connecting through
conn sys/sys#hoststring as sysdba...its getting connected.let have a look below..
C:\Documents and Settings\insuranceuser>SET ORACLE_SID=DB4DES
C:\Documents and Settings\insuranceuser>SQLPLUS /NOLOG
SQL*Plus: Release 8.1.7.0.0 - Production on Tue Jan 24 14:31:34 2006
(c) Copyright 2000 Oracle Corporation. All rights reserved.
SQL> CONN SYS/SYS AS SYSDBA
ERROR:
ORA-12560: TNS:protocol adapter error
SQL>
any suggestion??PLZ URGENT 
Do you have a database called DB4DES on the system from where you are running SQL*Plus?
if you do, is the service for the db started? 
an Instance called db4des not only exists and got its service started in the same system i'm also able to connect to it using sys/sys#db4des as sysdba.But using set oracle_sid=db4des.. i'm unable to connect!! 
i have the same problem. did you actually solve the problem? I have been troubleshooting this for a day!
Thanks. 
Do you have ORACLE_HOME variable defined?
If you do, is it pointing to the correct folder where the database software for the running database is stored?
What happens if you remove the variable ORACLE_HOME? 
You can only connect this way if you are on the server that has the database (DB4DES). If you are on a client then you have to specify the sid 
I agree, I did set up the oracle_home variable on cmd line. I really don't know if that really help the process. i am new to oracle.
by i had the simlar problem before, and
i have solved this problem after reading online for almost a day
the sql codes that work for me is:
sql> connect sys/syspassword#dbname.domain.com as sysoper
and then the message shows connected
if you want to grant any access to user (that is why i connect as sys at the first place to grant access for creating repository), sign in again:
sql> connect sys/syspassword#dbname.domain.com as sysdba
and the message is shown as connected.
This works for me, I installed oracle developer suite 10g in my windows xp workstation, so i accessed the sql plus via cmd 
please solve the problem
error occurs 12560 when i start sql plus 
Are you connecting to the database server through Remote Desktop Connection from another PC. Oracle has some problems when you try to connect to the database through the BEQ process if you are connected to the database server through Remote Desktop. If you are connecting remotely to the database server try either VNC or PC Anywhere which both seem to work properly.
HTH
John 
how are you connecting?
where are you connecting - local database or network?
what version of oracle software is installed on the system?
do you have more than one oracle home?
can you connect to any database at all? 
I'm getting the same error as these on this post when trying to login to sql*plus.
I just did a COMPLETE installation of Oracle9i DS Release 2.19.0.2.0.1 on Windows XP. So, it installed a lot of products that I will probably never use for now. All I wanted was to use SQL Plus, learning SQL. The only thing I did not install is the NET since I am not connecting to any server. I just want to create a database or tables and play with SQL.
I tried entering all those combination of username/password mentioned on this thread, but none worked. Sometimes I get TNS protocol adapter error and sometimes I get TNS something else. I even tried scott/tiger and still does not work.
I hope someone can tell me straight what username/password works without having to go through some configuration that I probably won't know how to do.
Thanks. 
OK here is an interesting case.
Have Oracle 10.2.0 Server installed on a Win2K3,
sqlplus on this box works fine.
installed Oracle client 10.2.0 on a remote desktop Win XP SP2,
tnsnames and Net Configuration seem to work, tested fine.
sqlplus behaves as follows:
C>sqlplus system/secret#ORCL
--connected.
C>sqlplus system/secret
gives ORA-12560: TNS:protocol adapter error
although ORACLE_SID and ORACLE_HOME are configured correctly.
tnsping ORCL works fine.
Any idea why is that happening? please advise... thanks. 
I try to connect in cmd prompt
SQL>conn/as sysdba
I receive this error
ORA-12560: TNS:protocol adapter error
Pls i need urgent solution 
Please consider this....
1. Before reporting this error, look at the error stack and check for lower level transport
errors.
2. Check addresses used for proper protocol specification. For further details, turn on tracing and re-execute the operation.
3. Turn off tracing when the operation is complete. 
hello friends
when i want to create a database this error apears: ORA-12560: TNS:protocol adapter error
how i can solve this problem?
thanks

Bowser login works, sqlplus login fails

I can login on the browser with the username and password, but sqlplus produces the message:
ORA-12638: Credential retrieval failed
This was working with beta 2 and beta 3. Now I have installed the released production version and it fails.
Please advise. Thanks. 
This is on XP SP2. Database and listener appear to be running. There are -no- ORA* environment variables defined. The XE ./bin directory is the only Oracle in the PATH. Logging in on the browser works.
C:\Documents and Settings\pwatson>ver
Microsoft Windows XP [Version 5.1.2600]
C:\Documents and Settings\pwatson>ps.vbs|grep -i ora
Copyright (C) Microsoft Corporation 1996-2001. All rights reserved.
264 oracle.exe c:\oraclexe\app\oracle\product\10.2.0\server\bin\ORACLE.EXE
292 TNSLSNR.EXE C:\oraclexe\app\oracle\product\10.2.0\server\BIN\tnslsnr.exe
C:\Documents and Settings\pwatson>sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on Sat Mar 25 12:48:11 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter user-name: pwatson
Enter password:
ERROR:
ORA-12638: Credential retrieval failed 
What is the SQLNET.AUTHENTICATION_SERVICES entry in the sqlnet.ora ?
Try commenting it out. I suspect that it is set to NTS authentication and the authentication is failing on your box somehow. This could be for a variety of reasons - are you now disconnected from the network ? Did your domain change ? Different OS username for the install ? 
Yes, commenting out the SQLNET.AUTHENTICATION_SERVICES line in sqlnet.ora allows sqlplus to login successfully.
I believe that I did the install under the local Windows 'Administrator' account since I had difficulties with the betas installing as a user.
Also, I installed the OracleXEUniv.exe first, but it would not work, so I removed it and installed the monocodeset version, OracleXE.exe.
I am about to install this for our training machine disk image, so I want to lay down the best configuration. Of course, one which works is better than one which does not work. :-)
Any other information I can provide. Thanks. 
I was having this problem, too. But commenting the line didn't solve my problem. Now I get the following:
ERROR:
ORA-01017: invalid username/password; logon denied 
supply the right username / password combination for that database and you will be fine 
Lol... You would think I know that... I used SYSDBA with the password entered on the installation steps. But it doesn't seem to work (I did check for CAPS not to be on, thanks). 
Hi,
Just an idea.
Is the Windows User who use to connect to XE with the "SQL Command Line", a member of the Windows Local Group ORA_DBA ?
Henri 
I was able to use sqlplus using Oracle authentication. THen, without warning, I started getting the ORA-12638 complaints. All is well from the web browser.
Commenting out the authentication service worked, but why does that have any effect on
sqlplus system/whatever#XE
?

Oracle XE nightmare on Win7

Hi all,
I have recently installed Oracle XE 10g2 on my PC at work (following the installation guide).
But when I try to open the Database Homepage, I get the message:
*"Firefox can't establish a connection to the server at 127.0.0.1:8080"*
and I'm sure this is not a browser issue.
I've read somewhere (don't know if it's true or not) that IIS might cause problems regarding the Database Homepage, but removing it from my PC is not an option in the near future.
OracleXETNSListener, btw, is up and running.
.
Another problem is that the SYS/SYSTEM password I entered during setup is irrelevant.
This assumption is based on failure to attempt any user-password related command suggestions I encountered regarding the above issue (e.g. "sqlplus / as sysdba" results in "ORA-01041: internal error. hostdef extension doesn't exist").
I saw something about ORAPWD utility (*http://www.oracleutilities.com/OSUtil/orapwd.html*) , but it requires a password file that doesn't exist in a folder in which I don't have privileges (even though my user is defined with administrator-level privileges), so I can't even use ORAPWD.
I'm no DBA. In fact, I'm making my first baby steps with oracle and have very little clue of what I'm doing, so I was hoping to start with the Database Homepage (which of course I cannot) and take things from there.
.
One last thing that bothers me for the moment is that the "SQL> *help*" is also unavailable.
.
Additional info:
============================================
C:\oraclexe\app\oracle\product\10.2.0\server\BIN>sqlplus system/oracle
SQL*Plus: Release 10.2.0.1.0 - Production on ß Θσ∞Θ 12 13:59:21 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-28547: connection to server failed, probable Oracle Net admin error
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
============================================
Can anyone help me get myself untangled from this unpleasant situation and on the right track?
Is there a solution at all, given the OS is Win7?
Thanks in advance.
. 
Don't know alot about win7 but have heard that the installer program must also be run with a right-click/run as Administrator to get through the install, as well as the user running the program needs to be in the local Admins group (as for any Windows install).
Sure sounds like the install didn't complete and the database isn't functional, or not running for some reason. Try looking at the alert log, see what happened on the last database startup in <drive:>\oraclexe\app\oracle\admin\XE\bdump\alert_xe.log, make sure the OracleXE service is in the services applet ...
Might not be much help but try the Windows de-install, and do the ol' try-it-again-and-see approach http://download.oracle.com/docs/cd/B25329_01/doc/install.102/b25143/toc.htm#CIHDDHJD 
See your duplicate post here - Oracle XE nightmare on Win7
Srini

Categories

Resources