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


ADVERTISEMENT

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

Application Express :: LDAP Authentication Working But How To Add Roles And Rules

Jan 22, 2013

I have got single sign on working via the built in LDAP Directory authentication in APEX. But at the moment this is letting everyone who is within AD log inHow can I assign role permissions to each logged in user so some users have an admin role and see certain parts of the application / pages / navigation items while editors and readers have different permissions

And also to restrict access to certain pages within the application

View 3 Replies View Related

Server Administration :: Oracle 10g - First Put Server Into Actual Use - Not Working?

Aug 12, 2010

We are using oracle 10g in linux machine which runs as server. And there are around 25 clients which run at the same time parallel to each other. I am new to oracle 10g and also for client-server version of database. I faced some problems when i first put the server into actual use.

-> Users have been created and tablespace is USERS and temporary space is TEMP. RESOURCE privilege is given.
-> Some times login fails for some clients.
-> Some times all the client login will be successful.
-> Query execution will be sometimes fast, but some times it takes too much time.
-> Some times the connection will be lost and again I have bring UP the server.

to maintain the oracle server.

-> Should I have to make any configuration settings in the server.
-> Should I change any values in the server.
-> Is there any way to properly maintain the server.

View 3 Replies View Related

Server Administration :: CPU Patch Not Working Properly?

Feb 10, 2009

I applied the Jan 09 CPU to my database this past Saturday and now my daily schema export is not running properly:

With the Partitioning, OLAP, Data Mining and Real Application Testing optionsExport done in WE8MSWIN1252 character set and UTF8 NCHAR character set server uses UTF8 character set (possible charset conversion)

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user TEST
. exporting PUBLIC type synonyms
. exporting private type synonyms

[code]...

View 8 Replies View Related

Server Administration :: Updating Statistics - Not Working?

Jul 4, 2010

if there are any problems with updating statistics? My manager told me that they had big performance issue when they updated the statistics of whole database. Is this a rare case?

I know the advantages of updating statistics,but are there any dis-advantages?

View 2 Replies View Related

Server Administration :: Auditing Lob Column Changes When Working With Dbms_lob

Oct 26, 2010

It seems that dml trigger doesn't fire when lob field is being updated using dbms_lob package. As it stated in Oracle documentation:

Quote:Using OCI functions or the DBMS_LOB package to update LOB values or LOB attributes of object columns does not cause Oracle to fire triggers defined on the table containing the columns or the attributes.

I need to know that table was updated (or is about to be updated), how can I do that in case it is lob field that is being updated?

View 1 Replies View Related

Server Administration :: Database Configuration Assistant Not Working In Oracle 8.1.7?

Jan 26, 2010

Data Base Configuration assistant for create new database not working in oracle 8.1.7 in windows server 2000 / server 2003 how can i create new database

View 1 Replies View Related

Server Administration :: Oracle Ocfs2 Not Working In Enterprise Linux 6.2

Mar 29, 2013

RPMS needed by OCFS2 for oracle enterprice linux 6.2,Since we unable to mount through OCFS2 console.

View 1 Replies View Related

Server Administration :: Database Configuration Assistant Not Working / When Create New Database

Mar 26, 2011

i am installing oracle database 8.1.7 on dell server power edge 2650 first time database successfully installed but when i want to crate new database by Database Configuration Assistant it is not working for new database creation.

View 1 Replies View Related

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 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

Forms :: Jacob Jar Not Working On Server?

Mar 22, 2010

I manage to configure webutil set up on my local pc, jacob jar is working and I can now export data to excel file.

There's a server dedicated to me on linux. I tried to test my form server. There's no error on webutil but the process stops on the line where excel is called. This is the same problem I encountered when jacob.jar is not working on my local drive.

View 2 Replies View Related

Listener File From A Working Server

May 10, 2013

i have a software...i installed it and configured it to the database now i copied the listener file from a working server to this both have same name and configuration and databases with same port number.

but when i try to log in it throws a error

ORA-12154 TNS COULD NOT RESOLVE THE CONNECT IDRNTIFIER SPECIFIED

I checked my listener tns.ora files and all are correct but still i cant connect.

View 1 Replies View Related

ORA-00932 - Sample Code Working Fine In 10g And Not Working Now In 11g

Apr 1, 2013

Below is the sample code working fine in 10g and not working now in 11g.

CREATE OR REPLACE AND RESOLVE JAVA SOURCE NAMED "PSTest" AS
import java.sql.SQLData;
import java.sql.SQLException;
import java.sql.SQLInput;
import java.sql.SQLOutput;
import java.util.List;
[code]....

we got the below error: ORA-00932: inconsistent datatypes: expected an IN argument at position 1 that is an instance of an Oracle type convertible to an instance of a user defined Java class got an Oracle type that could not be converted to a java class

Current Oracle version is Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit and the version we are upgrading is Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit

View 3 Replies View Related

Data Guard :: Check RFS Server Is Working

Oct 27, 2007

Is RFS an background process.How do I check if its working or not.Can I stop and start RFS.

View 14 Replies View Related

Server Utilities :: DECODE Not Working While Using With SQL Loader?

Sep 18, 2010

I had a requirement of loading flatfile into staging table using SQL Loader, One of the columns in the the Flat file is having values FALSE or TRUE and my requirement is that I load 0 for FALSE and 1 for TRUE which can be achieved by simple DECODE function...I did use decode and tried to load several times but did not work.

INFILE 'sql_4ODS.txt'
BADFILE 'SQL_4ODS.badtxt'
APPEND
INTO TABLE members
FIELDS TERMINATED BY "|"

[code]...

I did try putting a trim as well as SUBSTR but did not work....the cloumn just doent get any values in the output (just null or say free space)

View 5 Replies View Related

PL/SQL :: To_char Not Working / (||) Is Working With Join Query

Mar 22, 2013

I have two tables : oa_membership_dtl(in this created_by field is varchar2(200 byte) ,oa_partner_usr_dtl(in this table partner_userid is number(8,0) i need to do join on above fields.

I am using following two queries:

select * from oa_membership_dtl membership
join oa_partner_usr_dtl partner_user
on to_char(partner_user.partner_userid,'9999')=membership.created_by
select * from oa_membership_dtl membership
join oa_partner_usr_dtl partner_user
on rtrim(ltrim(partner_user.partner_userid||' '))=rtrim(ltrim(membership.created_by))

by using first data is not fetched but 2nd is working fine , i am getting the matched records using 2nd query.

whats the diff between to_char and || symbol?

View 1 Replies View Related

Server Utilities :: SQL Loader Control File Is Not Working

Jan 28, 2011

The reason "why sql loader's CONTROL FILE is not working, if that location has space in between"

E.g. - C:practice for sqlloadercontrol1.ctl

But it works if we remove the space in between the path as below:

E.g. - C:practice_for_sqlloadercontrol1.ctl

View 3 Replies View Related

Server Utilities :: Multithreading Not Working With Direct Path Load

May 30, 2013

Output in the sqlldr log:-
------------------------------------------------------------------------------
Path used: Direct
Insert option in effect for this table: APPEND
Trigger DEV."R_TM_BK_BORROWER" was disabled before the load.
DEV."R_TM_BK_BORROWER" was re-enabled.
The following index(es) on table "YO"."TM_BK_BORROWER" were processed:
index DEV.I_NK_TM_BK_BORR_1 loaded successfully with 1554238 keys
index DEV.I_NK_TM_BK_BORR_2 loaded successfully with 1554238 keys
index DEV.I_NK_TM_BK_BORR_3 loaded successfully with 1554238 keys
index DEV.I_NK_TM_BK_BORR_31 loaded successfully with 1554238 keys

Bind array size not used in direct path.
Column array rows : 5000
Stream buffer bytes: 256000
Read buffer bytes: 1048576

Total logical records skipped: 1
Total logical records read: 1554241
Total logical records rejected: 48
Total logical records discarded: 2
Total stream buffers loaded by SQL*Loader main thread: 7695
Total stream buffers loaded by SQL*Loader load thread: 0
------------------------------------------------------------------------------

So, I still see in the sqlldr log that the stream buffers are laoded by main thread and load thread is still not being used. SQL*Loader load thread did not offload the SQL*Loader main thread. If the load thread takes care of the current stream buffers, then it allows the main thread to build the next stream buffer while the load thread loads the current stream on the server. We have a 24 CPU server.

I am using the following parameters set to true in the sqlldr:- parallel=true , multithreading=true , skip_index_maintenance=true in the sqlldr

View 5 Replies View Related

Sqlplus Is Not Working After Oracle 10g Client Installation On Linux Server

Oct 11, 2012

just now i installed oracle 10.2.0.1 client version in one my linux server. after successfully installation sqlplus is not working .

below are my .profile details.

# Set up the shell variables:
EDITOR=vi
export EDITOR
### Set the umask
umask 022
### Set ulimit

[code].....

View 4 Replies View Related

Backup & Recovery :: Rman Restore On New Server - Set Newname Not Working?

Feb 14, 2012

I am trying to restore a backup from a live server to a dev server. Have moved nackup sets. Created a windows service to match the old sid on live system. copied the pfile from live and changed the locations of the folders to suit dev. set oracle_sid to the new sid(as created to match live)

connected to rman
startup nomount
set dbid to the live number
restore controlfile
alter database mount
catalog'd all the backupsets

[code]....

but it fails when it tries the restore .. see below ..The path it is showing is the old path from the live server, so it appears to eb ignoring my set newname statements even though they succeeded earlier - should be restoring them to d:oracleoradatasun43dev ? Does the whole thing have to be put inside one run block or can I put bits in one run block and other bits outside of it etc?

RMAN> restore database;

Starting restore at 14-FEB-12
using channel ORA_DISK_1
using channel ORA_DISK_2
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set

[code]....

View 1 Replies View Related

Security :: How To Use OS Authentication To Login DB

Sep 16, 2011

How can i use OS authentication to login db?

SQL> connect / as sysdba
ERROR:
ORA-01031: insufficient privileges

sqlnet.ora text:

# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.
#SQLNET.AUTHENTICATION_SERVICES = (NTS)
SQLNET.INBOUND_CONNECT_TIMEOUT=1

View 18 Replies View Related

SQL & PL/SQL :: Function To Pass Through Authentication

Oct 24, 2010

I wrote many functions before, but NEVER a function to pass through authentication...Here are some of the specs ...In this example, an institution will be accepting tuition and fee payments against bills that are stored in the our system. In addition to the minimum bill authentication parameters, the institution would like to pass us a full name to display when welcoming the user, control the users primary e-mail address, and restrict the payment method on a per user basis.

URL url This will be issued to you by your project manager. It should be of the form URL....

User Id user_id The unique identifier for the user within the institution. This is typically a student ID. (in our database)

Full Name full_name Users full name. Example "John Smith". (in our database) Email Address email Primary email address. in (our database) Payment Method paymentMethod Payment methods allowed for this user.

Allowed values:
"none" :no payments accepted
"ach" :ach is the only accepted
"cc" :credit cards only accepted
"ach_cc" :credit card and ach 16

Key key The shared key that is issued to you by your project manager.Time Zone tz The time zone you are located in. Valid values are:

"E" :Eastern time zone
"C" :Central time zone
"M" :Mountain time zone
"P" :Pacific time zone 1
[code]....

I know I need to have cursor to check on the user_id, full name, email (those values are store in our DATABASE. The URL and the key are giving to me. Do I have to hard code the url in the cursor and stored in a variable so I can check that the url coming in (url in varchar2) is equal to the url in my cursor? The same with the key?

View 2 Replies View Related

Reports & Discoverer :: Authentication Failed?

Sep 13, 2011

I have developed a report and deployed it to the oracle apps and it was working fine and now the developed object is migrated to the test environment (testing database) and tester ..

Now the report when i test it the devlopment evnironment...It throws error saying "Authentication Failed".

View 3 Replies View Related

Security :: Password File Authentication

Jan 5, 2013

What is happening here:

c:usersjohnhome>
c:usersjohnhome>orapwd file=%ORACLE_HOME%databasePWDorcl.ora password=oracle
c:usersjohnhome>sqlplus sys/garbage@orcl as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Sat Jan 5 18:25:06 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options

orcl> sho user
USER is "SYS"
orcl> select sys_context('userenv','ip_address') from dual;
SYS_CONTEXT('USERENV','IP_ADDRESS')
---------------------------------------------------------------------------------------------------
127.0.0.1

orcl>Why can I get a sys login, when I am connecting through the listener and giving an incorrect password? The listening address is a loopback address, is Oracle clever enough to realize that I am in fact logged on to the server as a member of the OSDBA group? I didn't think that information was passed through SQL*Net.

View 3 Replies View Related

PL/SQL :: Implement Kerberos Authentication Protocol

Nov 23, 2012

Is there way implement Kerberos authentication protocol with PLSQL? I am consuming web service with utl_http, which implement only basic authentication and I was able to find implementation with PLSQL for NTLM. So I am wondering if there is a kerberos implementation.

View 0 Replies View Related

Security :: Integrating LDAP For User Authentication

Jan 24, 2013

We like to integrate the window LDAP to a new oracle database for user authentication. For example, this is a new test database and we don't have any users created.Now we like to figure out if we created the users with same id as in LDAP userid, how they can be authenticated externally by LDAP. I read and heard some info on OID provided by oracle but need some more step by step info to experiment.

View 3 Replies View Related

Enterprise Manager :: Listener Parameters Authentication

Nov 21, 2010

where i can set the "LOCAL_OS_AUTHENTICATION_BACKUP=OFF" parameter in enterprise manager (oracle db 10gr2) which we normally specify in listener.ora file.

View 1 Replies View Related

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







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