How To Eliminate Windows NT Authentication In Oracle DB Server

Feb 18, 2013

I have oracle database server set with Windows NT authentication. How can I get rid of this kind of authentication as this is holding up additional Windows Domain with its own PDS and so on. Or is it possible to move Oracle Database server to a different Domain and authentication to be coming from new domain?

View 4 Replies


ADVERTISEMENT

Security :: Windows Authentication And Connection In Oracle?

Jul 15, 2013

I have been using oracle based database security but company now wants to handle with windows authentication.I have windows os 2008 R2 and oracle 11.2.0.3.

I also have set up the SQLNET.AUTHENTICATION_SERVICES= (NTS).I created user with create user "domainusername" identified Externally! but now how can i connection from application to database!

View 1 Replies View Related

Can Application Connect With Windows Authentication To Oracle 11.2.0.3 Database

Jul 16, 2013

Can application connect with windows authentication to oracle 11.2.0.3 database? if so then how can i set it up! 

View 3 Replies View Related

Networking And Gateways :: Listener PSWD Authentication On Windows XP

Nov 21, 2010

I have set password on the listener and set the local_os_authentication parameter to "OFF", whenever i start/stop listener through "lsnrctl" ,it works fine and asks for password but i can stop/start listener through windows services without giving any password.

what is the use of setting password on listener if any body can start/stop it through services utility in windows xp sp3.

View 5 Replies View Related

Security :: Windows OS Authentication Fails ORA-1017 After Renaming AD User

Jul 17, 2012

When a user is renamed in Active Directory, they can no longer connect to the Oracle DB thru OS authentication. There is no OID/DIP integration.

sqlnet.ora
SQLNET.AUTHENTICATION_SERVICES = (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME)
NAMES.DEFAULT_DOMAIN = cal.com.br
create user "CALRENATOH" IDENTIFIED EXTERNALLY
GRANT CREATE SESSION TO "CALRENATOH"
AD User CALRENATOH can connect to DB as 'sqlplus /'

But after renaming AD User CALRENATOH to CALRENATOH1 and dropping DB user CALRENATOH and creating DB user CALRENATOH1 drop user "CALRENATOH"; create user "CALRENATOH1" IDENTIFIED EXTERNALLY;

Now OS authentication 'sqlplus /' fails 'ORA-01017: invalid username/password; logon denied'..Once I recreate the DB user with old AD user name 'CALRENATOH', OS authentication succeeds. create user "CALRENATOH" IDENTIFIED EXTERNALLY;

C:Windowssystem32>set username
USERNAME=RENATOH1
C:Windowssystem32>sqlplus /@rmlab001
SQL*Plus: Release 11.1.0.6.0 - Production on Tue Jul 3 15:16:46 2012
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning and OLAP options

Why the Database is still looking for old AD user name? Does Oracle cache information about OS authenticated users?

View 0 Replies View Related

Server Administration :: OS Authentication Is Not Working In 11G?

Apr 20, 2011

OS authentication is not working

Does 11g need any different setting?

Following are the settings

1)

SQL> show parameter os_a

NAME TYPE VALUE
------------------------------------ ----------- --------------
os_authent_prefix string OPS$
remote_os_authent boolean FALSE

2) sqlnet.ora has following setting

SQLNET.AUTHENTICATION_SERVICES = (NTS)

3) I have created user like following

sql> create user OPS$CLASS
2 identified externally
3 default tablespace user_data
4 temporary tablespace temporary_data
5 profile clas_prof
6 account unlock;

user created.

sql> grant connect to OPS$CLASS;

Grant succeeded.

With the same settings it successfully connects from my 9i client to the 9i database
(DB01, below)

C:Documents and SettingsCLASS_user>sqlplus

SQL*Plus: Release 9.2.0.1.0 - Production on Wed Apr 20 10:18:58 2011

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Enter user-name: /@DB01

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production

SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production

However it fails to connect to 11G database (DB02, below)

C:Documents and SettingsCLASS_user>sqlplus

SQL*Plus: Release 9.2.0.1.0 - Production on Wed Apr 20 10:19:29 2011

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Enter user-name: /@DB02
ERROR:
ORA-01017: invalid username/password; logon denied

View 6 Replies View Related

Server Administration :: Monitoring Script Required For Oracle 9.2.0.7.0 On Windows 2000 Server

Apr 8, 2010

My manager is asking to create a SQL scrip, which will provide following information.

Our database is 9.2.0.7.0 on Windows 2000 Server

-How many records Insert / Update or Delete daily in my Oracle database?

- Check Archive log / Redo Log switching information?

-Check database growth ?

View 10 Replies View Related

Server Administration :: Installing Oracle Database 10.1.0.2.0 On Windows 2003 Server 64bit?

Jan 11, 2011

i am trying to install Oracle 10.10.2.0 on Windows Server 2003 standard x64 Edition Service Pack, but when i try to run the installer or open DVD it gives me below error.

"The image file D: is Valid, but is for a machine type other than the current machine."

View 1 Replies View Related

OS Authentication Is Not Working For Oracle 10g Database

Sep 10, 2013

We are facing an surprising problem in oracle 10g database. Previously we are able to connect our Oracle 10g database using os authentication with "sqlplus / as sysdba" command. Last wednesday in our linux server maximum number of processes have overflowed and we need to increase the soft limit of our linux server. After that without restarting database every applications [OID 10g] are working fine. But, we are not able to connect with system using OS authentication. It is showing following. 

$ export ORACLE_HOME=/a01/OID$ export ORACLE_SID=OID$ export PATH=$PATH:/a01/OID/bin$ sqlplus / as sysdbaSQL*Plus: Release 10.1.0.5.0 - Production on Tue Sep 10 06:45:08 2013Copyright (c) 1982, 2005, Oracle.  All rights reserved.Connected to an idle instance.SQL> 

Whereas I can connect with instance after providing @OID [SID]$ sqlplus sys@OID as sysdbaSQL*Plus: Release 10.1.0.5.0 - Production on Tue Sep 10 06:47:07 2013Copyright (c) 1982, 2005, Oracle.  All rights reserved.Enter password:Connected to:Oracle Database 10g Enterprise Edition Release 10.1.0.5.0 - ProductionWith the Partitioning, OLAP and Data Mining optionsSQL>  What am I missing. How can I connect with system with "sqlplus / as sysdba" command?

View 21 Replies View Related

Server Administration :: Restoring The Oracle Services In Windows 2008 Server

Jun 27, 2012

I was trying to delete the database in the test server. When i was deleting listener was already stopped, i continued deleting using dbca, it shown me some alert that datafiles cant be deleted because system could't find database, since listner was stopped so only service was deleted(the one showing in the windows administrator toolsservicesOracleServiceTEST).

All the datafile parameter files are still there. How can i delete the datafiles and parameter files belongs to that database or how to create the deleted service, so that i will start the listener and do the complete deleting of the database.

View 3 Replies View Related

RAC & Failsafe :: ORACLE Server Failover Parameters In Windows Server Machine.config File

Jan 17, 2012

working on setting up connection between a Windows 2008 server and a pair of Oracle 11g DBs in a RAC Cluster. One Database (let's say DatabaseA) is in one data center, and the other (DatabaseB) is an a secondary, backup database. The RAC Cluster is all set up, working fine, etc. However, I Need to set up the machine.config file on my Windows Server, to go only connect to DatabaseA, unless it fails, in which case, we want it to connect to DatabaseB. Think we could do this if the host app server was Linux/Unix, but it is windows, and I just don't have the background as to the parameters to set up in the machine.config file. They are similar, but different, and we want a very specific behavior (use DatabaseA, unless fails, then DatabaseB). Application is .NET 4.0 app.

View 6 Replies View Related

Server Administration :: Oracle 11g R2 Installation On Windows 2008 64 Bit Server

Apr 19, 2011

I want to install Oracle 11g R2 in windows 2008 64 bit server. How can I know whether my server is ready to install Oracle ie is all components are available in server or any patch is to be applied etc.

View 3 Replies View Related

Application Express :: LDAP Authentication Using Embedded Weblogic Server

Sep 28, 2012

I am trying to use embedded weblogic server for creating an LDAP authtication secheme but it is not working

I believe that embedded ldap server works on the same port as the admin server of the domain but configuring it has been a pain. I got the following code from forum to test the ldap connection

declare
l_retval pls_integer;
l_retval2 pls_integer;
l_session dbms_ldap.session;
l_ldap_host varchar2(256);
[code]........
  
Every time I run this, I get the following error

ldap session : 01000000(returned from init)
error: ORA-31202: DBMS_LDAP: LDAP client/server error: Invalid credentials
-31202

View 0 Replies View Related

Error In OS Level Authentication For Oracle 11gR2 Database Access?

Mar 18, 2011

We have an issue regarding OS level authentication to access Oracle 11gR2(11.2.0.1) database.

Our environment -
UNIX - AIX 5.3 (OS user id password is having kerberos security).
Oracle 11.2.0.1 (32 bit client) installed in server 1
Oracle 11.2.0.1 (64 bit server) installed in server 2.
Everything works fine when we created a general userid test_db in the database and connect through sqlplus test_db@dbname.

But when we try to use the option of OS level authentication using "sqlplus /", it throws following error and could not be connected.

ERROR: ORA-12545: Connect failed because target host or object does not exist

I have created the same OS user name in database (with external password authentication) with prefix OPS$. we have set ORACLE_SID as well.

View 1 Replies View Related

Security :: Active Directory Authentication For Oracle 10g Database Running On Solaris?

Jul 25, 2011

I have oracle 10g up and running on Solaris 10, from windows I would like to connect to sql plus through windows authentication, for that I have already made sure that remote_auth = true and have created user in oracle with OPS$. But still I cannot connect.

I have the same setup but with oracle on windows server, the os authentication from windows clients works just fine.

does oracle 10g on solaris 10 supports windows os authentication?

View 4 Replies View Related

Application Express :: How To Make Use Of SSO Login Credentials Of Oracle In Authentication Schema

Jul 16, 2013

I am using SSO login for Authorizations. Would like make use of SSO for creating authentication schema. My main requirement is to assign privilege based on users using SSO loging.

View 0 Replies View Related

Windows :: ORACLE 11g R1 Or R2 For Server 2008 R2

Jan 7, 2011

Oracle 11g R1 or R2 is availble for Windows Server and If YES then any link for the same.

View 2 Replies View Related

Server Administration :: Oracle XE On Windows XP

Apr 26, 2012

I have oracle XE installed on my machine and it was working absolutely fine for the last year or so. Today there was an trojan intrusion which caused some issues with my windows xp OS like hiding some files, desktop etc. After everything was cleaned up and things back to normal. I am having issues with XE.

1. I can start and stop XE with out any issues
2. When I use the run sql command line, I can connect using - connect sys/sys as sydba.
3. I can also run a query to see all the users and see the HR user also.

However,
1. When I connect to my hr user using connect hr/password@xe, it just hangs
2. I tried the- go to Oracle XE admin page but it just hangs for a long time and returns page cannot be found.
3. I can tnsping the xe instance.

Is a fresh install the only option? or is there any way to correct this using the sys/sys user?

View 9 Replies View Related

Oracle 10g RAC On Windows 2008 Enterprise Server

Oct 7, 2010

I'm installing Oracle 10g (10.2.0.4) RAC on Windows enterprise Server. Am able to install cluster ware (10.2.0.4). While installing ASM (10.2.0.3)/ DB its going to restart both the servers automatically. Is there any problem with this Versions (OS and Oracle) combination. Is it compatible or Not?

View 4 Replies View Related

Server Administration :: Installing Oracle 10G On Windows 7?

May 21, 2010

I already succeded to setyup Oracle 10 G on my machine , when trying to connect by system/system it does not connect.The listener is OK and instance ok.

View 10 Replies View Related

Windows :: Different Versions Of Oracle Between Server And Client?

Apr 11, 2012

I'd like to know if it's possible to install a client with Windows 7 (64bits) can be installed with Oracle 11gR2 (32 bits) when the server is still with Oracle 10.1.0.2 ?

View 1 Replies View Related

Windows :: Oracle Client On W2K8 Server

Jan 28, 2011

I have installed an application suite (AppX) on Windows 2008 Server which has both Windows applications and a web GUI element (ASP.NET running through IIS 7.5).

The Windows apps are in both VB and .NET and compiled specifically for x86 (due to COM component dependencies). I have installed the "Oracle Database 10g Release 2 (10.2.0.3/10.2.0.4)Enterprise/Standard Edition for Microsoft Windows Vista, Windows Server 2008, Windows 7" Oracle Client on the Windows 2008 Server.

After installation AppX windows modules all worked fine with the Oracle Db but the Web Application was getting the following error:

System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.

After a bit of research I found a few articles suggesting setting up the ORACLE_HOME directory in the Windows Environment variables. So I tried setting up the ORACLE_HOME environment setting and had some success as the AppX web application worked fine! However, the Windows apps of AppX were now broken and returning the error:

System.Exception: OCIEnvCreate failed with return code -1 but error message text was not available.
at System.Data.OracleClient.OciHandle..ctor(OciHandle parentHandle, HTYPE handleType, MODE ocimode, HANDLEFLAG handleflags)
at System.Data.OracleClient.OciEnvironmentHandle..ctor(MODE environmentMode, Boolean unicode)
at System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName)
[code].........

So I am struggling to get both the Windows and Web App both working on the same Windows 2008 Server.

View 2 Replies View Related

Windows :: How To Install Oracle 11g In Server 2008 R2

Dec 24, 2011

How to install oracle 11g in Window Server 2008 R2.

View 6 Replies View Related

Oracle 11g X64 Setup On Windows 2008r2 Server

May 6, 2013

I am setting up a new production Oracle 11gr2 database on Windows 2008r2 server. I will have SAN(HP 3PAR) attach to the physical server. Here is my plan for diskLUN allocation:

1. 2 SAS disk in Raid1 for OS.
2. 2 SAS disk in Raid1 for Oracle database binary file.
3. 1 LUN for data file. (system, application, user table space)
4. 1 LUN for log file.
5. 1 LUN for temp.
6. 1 LUN for backup.

is this configuration OK? Does UNDO table space on separate LUN or it's OK to put it on data LUN?

View 8 Replies View Related

Oracle Database 9i In Windows Server 2003

Apr 22, 2013

i have a question about oracle database 9i in windows server 2003 R1 X86 . I set the parameter of pga_aggregate_target=1000M and 500M sometimes i found after few days that error message appear to client

ORA-12500 TNS:listener failed to start a dedicated server process

when i try to connect from the server sometimes logon and sometimes another message appear

ORA-12560: TNS:protocol adapter error

i think the problem in pga_aggregate_target value

View 10 Replies View Related

DB Performance Is Slow Using Oracle 11gR2 On Windows Server

May 25, 2013

I am using 11gR2 on windows server. This is the query that runs many times a day and effect badly the performance of database. I don't have much idea about this query.

SELECT TO_CHAR(current_timestamp AT TIME ZONE 'GMT', 'YYYY-MM-DD HH24:MI:SS TZD') AS curr_timestamp, COUNT(username) AS failed_count
FROM sys.dba_audit_session
WHERE returncode != 0 AND TO_CHAR(timestamp, 'YYYY-MM-DD HH24:MI:SS') >= TO_CHAR(current_timestamp - TO_DSINTERVAL('0 0:30:00'), 'YYYY-MM-DD HH24:MI:SS')

View 1 Replies View Related

Server Administration :: Whether Oracle 9i Works In Windows 2012

May 14, 2013

know whether Oracle 9i works in Windows 2012? As we are planning to upgrade.

View 1 Replies View Related

Windows :: Connecting Oracle To Remote Access Server?

Mar 2, 2011

Is it possible to connect Oracle to MS Access database sitting on remote server? I need to join the tables in Oracle and MS Access.

View 5 Replies View Related

Windows :: Accessing Oracle 7 Database From Server 2008

Jan 11, 2013

We have been upgrading our servers to Server2008 and are getting..

[ORA-3134: Connections to this server version are no longer supported.]

..using the drivers we used to use in XP and Server2003 to access a legacy Oracle7 db. Connections to this db are needed for typical CRUD functionality by multiple applications, some written in Classic ASP and some in C# .NET 3.5 & 4.0. I have tried ODBC drivers (System.Data.Odbc) and also ODP (Oracle.DataAccess.Client) to no avail.

Any existing driver solution to make this connection without have to resort to a custom HLI interface?

I would think we aren't the only ones needing to access Oracle7 from Server2008.

View 7 Replies View Related

How To Download Oracle 10gR2 To Windows 2008 Server R2

Jun 27, 2012

I'm trying to download Oracle RDBMS 10.2.0.5 for Windows Server 2008 R2. But i don't see it on OTN or edelivery....i can't find any link...Have i to request a SR on metalink?

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved