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
ADVERTISEMENT
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
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
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
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
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
Jun 26, 2013
Is it possible to use Database authentication in APEX through database link, and how?Also is it posible to read roles from users through database link?
View 3 Replies
View Related
May 20, 2011
I'm trying to connect Oracle 11g database from Oracle 9i database, by creating dblink on Oracle 9i database. But my session got hang while i perform this. Here i'm giving the steps i followed on my both the database. Here Oracle 9i database is my source db and Oracle 11g is my target db.
Following steps/setting on Oralce 11g Database
SQL> SHOW PARAMETER SEC_CASE_SENSITIVE_LOGON
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon boolean TRUE
SQL> alter user SSA identified by SSA;
User altered.
Password File recreted on Oracle 11g Database Server
[oracle1@dev11g dbs]$ orapwd file=/backup/ora11gsoft/odb/OH1/dbs/orapwwbdata
ignorecase=n password=dev entries=5
Following steps performed on Oralce 9i Database
DROP DATABASE LINK "SSA11G.SSA_DB1.WBTEA.COM";
CREATE DATABASE LINK "SSA11G.SSA_DB1.WBTEA.COM"
CONNECT TO SSA
IDENTIFIED BY SSA
USING 'DEVDATA.DEV11G';
Database link created.
SELECT * FROM SSA.SSMASTER@SSA11G;
And the hangs for ever.
View 4 Replies
View Related
Feb 26, 2008
I'm looking for solutions to make real time replications from an Oracle 8i database.
For more details :
- we have an existing database with Oracle 8i
- we want to replicate this database: the replicated database will be used by a web application.
- we need the replication to be in real-time (we wish to have the shortest lag)
For the moment i didn't find much information on the web and it seems that replication solutions for the version 8i are quiet limited.
Some more details :
- The responsible want imperatively that the web application work with a replicated database, without interacting directly with the original one.
- An evolution of oracle should be done but within some years so were trying to find a solution rapidly with 8i.
View 3 Replies
View Related
Mar 28, 2013
I'd like to have my 11g database authenticate users against an OpenLDAP service. We'd still create accounts in the database, and do authorization within the database, but I'd just want to the user's passwords authenticated externally, against the OpenLDAP service. Is this possible? My searching through these forums and Google seems to indicate that you can do it if you run an Oracle Internet Directory (OID) service. I do not want to have to install and maintain an Oracle Internet Directory service. I'd like to do it without it.
I have a working PL/SQL function (below) that can authenticate a passed in username & password against our OpenLDAP directory. Is there any way for me to have Oracle call this function for the database user authentication? Or is there any other way for me to get the Oracle database to directly authenticate against OpenLDAP without having to run OID?
create or replace function ldap_authenticate(username varchar2, password varchar2)
return boolean is
begin
begin
if dbms_ldap.success = dbms_ldap.simple_bind_s(
[code]........
View 1 Replies
View Related
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
Aug 3, 2011
At the moment, we were loading the file in our system serially. This is a very old and established system.We would like to incorporate parallel loading for our loaders to load data into the database.
Most of the issues would be due to multiple inserts happening due to the files being loaded in parallel. For some reasons, we cannot give regular commits untill the entire batch of items is processed in case the process needs to rollback. A file can contain different set of batch of items clubbed together for loading.
The issue here is untill the first file finishes loading and commits, the second file would just hang. In fact, mulitiple files might hang for the first file to finish. what can I do to overcome this?I tried to used "lock table t1 in SHARE ROW EXCLUSIVE mode nowait". When the leading process is doing inserts, the failing process will fail with a resource busy and acquire with NOWAIT specified. We would catch this exception and redirect that batch to an error file to be reloaded at a later date.
View 15 Replies
View Related
Jun 15, 2013
I know how to use database links in various forms, but I've been trying to think through how the authentication works for a connected user link in 11g. If I create the link like this,
create public database link using 'orcl';
then any user can use the link, provided they have an identical username/password in the two databases. With pre-11g passwords, it was understandable: the password was salted with the username, so the hash of the password would be the same in both databases, and I assumed that the logon through the link used some sort of IDENTIFIED BY VALUES mechanism. But in 11g, the salt will different in the two databases. So the hash will be different. And of course Oracle never stores the actual password. So I don't see how the authentication works.
View 1 Replies
View Related
Jun 16, 2013
I know how to use database links in various forms, but I've been trying to think through how the authentication works for a connected user link in 11g. If I create the link like this,create public database link using 'orcl';then any user can use the link, provided they have an identical username/password in the two databases. With pre-11g passwords, it was understandable: the password was salted with the username, so the hash of the password would be the same in both databases, and I assumed that the logon through the link used some sort of IDENTIFIED BY VALUES mechanism. But in 11g, the salt will different in the two databases. So the hash will be different. And of course Oracle never stores the actual password. So I don't see how the authentication works.
View 4 Replies
View Related
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
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
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
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
Feb 15, 2010
Database version:10.2.0.3
Operating System:Microsoft Windows XP
I have two database TEST and TEST2 on same windows machine. In TEST database i have created one database link that access one schema in other TEST2 database. but when i passed select command to access object in TEST2 through Database link it is hanging indefinitely.
command that i have used to create Database link: create database link scott connect to scott identified by tiger using 'TEST2'
This is sqlnet.ora Entry:
SQLNET.AUTHENTICATION_SERVICES = (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES)
TNSNAMES.ORA entry:
TEST2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = SSIPL-LAPTP-052)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = test2)
[code]....
View 3 Replies
View Related
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
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
Jan 20, 2011
I am unable to configure EM(Oracle 11.2g) on Redhat Linux 5 Enterprise edition(32 bit). Environment variables are set to correct SID. If I try to run dbca the wizard does not display the Enterprise manager configuration screen. I have tried to create repository by using emca -config dbcontrol -db config.
But it throws exception that database instance is unavailable?
View 5 Replies
View Related
Oct 31, 2011
I tried to insert date in date column from another table date column. Below is SP ans execute procedure.
CREATE OR REPLACE PROCEDURE test(
start_time Varchar
)
AS
BEGIN
DBMS_OUTPUT.ENABLE(1000000);
DBMS_OUTPUT.PUT_LINE(start_time);
Insert into test_ora (report_date) (select start_time from
[code]....
execute test ('27-10-2011 12:01:01');
It gives error as Invalid number.
View 2 Replies
View Related
Mar 30, 2012
following is a query which i find difficult to understand why EXISTS is failing. There are two scenarios where if i block LINE 30 and unblock line 31 of the code then one record is returned.
SELECT A.ENTITY_CODE,
A.VRNO,
A.VRDATE,
[Code]....
View 4 Replies
View Related
Jun 16, 2010
I have an oracle package that i am using to search for a string in a blob entry. I compiled the package and the package body in one environment, it had no errors, when i execute, i get my results.I went ahead and created the same package and function in another environment and it fails by giving me the below error
ORA-06503: PL/SQL: Function returned without value ORA-06512: at "SYSTEM.IMPACTUS_PCODE", line 158 for sysadm
I have used this on other environments often and have never had an issue.
View 7 Replies
View Related
Mar 26, 2013
I am trying to setup a one way queue that will be consumed by an inhouse ESB.We currently are able to create a multi-consumer queue using:
CODEBEGIN
DBMS_STREAMS_ADM.SET_UP_QUEUE(queue_table => 'strmadmin.streams_queue_table',
queue_name => 'strmadmin.streams_queue');
END;
but unfortunatly the ESB that we are using uses a jms component which seems to only be able to take mono-consumer queue.So we have created our queue usuing the following
CODEBEGIN
DBMS_AQADM.CREATE_QUEUE_TABLE( Queue_table => '"STRMADMIN"."STREAMS_QUEUE_TABLE"',
Queue_payload_type => 'SYS.ANYDATA',
storage_clause => 'PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 TABLESPACE
[code]...
This therefore permits us to have a queue/queuetable which pushes data to a single consumer.The probleme comes when we try to add a table rule using the following command:
CODEBEGIN
DBMS_STREAMS_ADM.ADD_TABLE_RULES( table_name => 'source.t1',
streams_type => 'apply',
streams_name => 'streams_apply',
queue_name => 'strmadmin.streams_queue',
[code]...
We then get the following error:
CODEORA-06512: on line 2 24039. 00000 - "Queue %s not created in queue table for multiple consumers"
*Cause: Either an ADD_SUBSCRIBER, ALTER_SUBSCRIBER, or REMOVE_SUBSCRIBER procedure, or an ENQUEUE with a non-empty recipient list, was issued on a queue that was not created for multiple consumers.
*Action: Create the queue in a queue table that was created for multiple consumers and retry the call.
We are able to create the capture rule without any problem but without the apply rule, nothing seems to end up into the queue table.AQ is not a viable solution since it is troublesome when it comes to deletes and mass updates.
View 1 Replies
View Related
Nov 9, 2012
could not import using impdp. it hangs while processing view.
Oracle version : Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
expdp user/pwd full=y directory=export dumpfile=exp_test.dmp
There is no error in export log.
impdp user/pwd directory=data_pump_dir dumpfile=exp_test.dmp logfile=imp_test.log table_exists_action=replace
*** 2012-11-09 10:23:27.799
A deadlock among DDL and parse locks is detected.This deadlock is usually due to user errors in the design of an application or from issuing a set of concurrent statements which can cause a deadlock. This should not be reported to Oracle Support. The following information may aid in finding the errors which cause the deadlock:
ORA-04020: deadlock detected while trying to lock object MV_LOTS
View 1 Replies
View Related
Sep 7, 2011
I am trying to migrate an app made over Informix Database and I've stopped within this error.
As it seems, Oracle doesn't allow me to use an field of the main Select in my Inner Joins. The select is below
select
oins.versionseqno
,oins.itemtargetseqno
,oins.targetmarketcountrycode
,oins.targetmarketsubdivisioncode
,oins.destinationorgseqno
,oins.commandtype
,oins.isoriginal
[code]...
The error is:
ORA-00904: "I"."ORGSEQNO": identificador inválido
00904. 00000 - "%s: invalid identifier"
*Cause:
*Action:
Error at Line: 26 Column: 12
I've tried to Inner Join at the FROM clause but I was not managed to do that.
View 9 Replies
View Related
Jul 4, 2013
I'd like to talk about some interesting behaivor with Oracle RAC load balancer.We have Oracle RAC 11.1.0.6 - 2 nodes.
We noticed sometimes the number of sessions { select count(1) from v$session; } was not divided equally between nodes. Also load average was very different between node #1 and node #2.Now we define service explicitly.
srvctl add service -d MYORCL -s MYSERVICE -r MYORCL1,MYORCL2
srvctl config service -d MYORCL -a
MYSERVICE PREF: MYORCL1 MYORCL2 AVAIL: TAF: NONE
After we change connection string of corresponding application(s) the spread will be more equal:
select service_name,inst_id, count(*) the_qty
from gv$session
where service_name = 'MYSERVICE'
group by service_name, inst_id
SERVICE_NAME INST_ID THE_QTY
---------------------------------------------------------------- ---------- ----------
MYSERVICE 1 68
MYSERVICE 2 79
Although it's not round robin algorithm, the distribution looks more equal. It seems explicitly defined service of Oracle RAC has better load balancing approach comparing to the default service (created with db by default).
But there is some downside with more 'equally' distributed load balancing. Consider a client program that is running the following SQL once a 5 minutes:
select ...
from A
inner join B on ...
inner join C on ...
inner join D on ...
where the tables B, C and D data is changing all the time.Once load balancing is distributed more 'equally', the query above will arrive to node #1 and to node #2 more equally. It will cause more interconnect traffic, because Oracle RAC will need to synchronize requested blocks all the time, with much high rate.
View 1 Replies
View Related
Sep 21, 2011
I have a query which returns a nested table as a result of split function. I used any method to unnest the data. But I couldn't. I try it with this query.Note: To run the following query I attached everything needed.
-- This query gives very strange results.
SELECT *
FROM
(
SELECT
[code]...
View 18 Replies
View Related
