Sponsored Content
Top Forums UNIX for Beginners Questions & Answers Global_names setting in Oracle Post 303022779 by bakunin on Friday 7th of September 2018 12:24:52 AM
Old 09-07-2018
From the first hit in Google entering the search words

Code:
Security:090759 oracle

Using Alternative Authentication Providers - 11g Release 1 (11.1.1)

Quote:
3.4.3.5.3 Incorrect SQL Queries

Take care that the SQL queries you specify in the SQLAuthenticator config are syntactically correct and refer to the correct tables etc. For example, the following error occurs in the AdminServer.log when the wrong table name is specified for the password query

####<Jul 7, 2011 4:03:27 PM BST> <Error> <Security> <gbr20020> <AdminServer> <[ACTIVE] ExecuteThread: '8' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <de7dd0dc53f3d0ed:e0ce69e:131007c1afe:-8000-00000000000007fa> <1310051007798> <BEA-000000> <[Security:090759]A SQLException occurred while retrieving password information
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:457)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:889)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:476)
Google is your friend.

bakunin
This User Gave Thanks to bakunin For This Post:
 

5 More Discussions You Might Find Interesting

1. Filesystems, Disks and Memory

Problem setting up raw partitions on SUSE v8.0 using LVM on Oracle 8.1.7.URGENT!!!!!!

Hi all! Working on Oracle v8.1.7.0.0 with OS  as Suse v8.0 Linux. I had created LVM,linked raw devices to LVM as below: # for binding raw devices raw /dev/raw/raw1 /dev/oracle/sam_raw_system_251m raw /dev/raw/raw2 /dev/oracle/sam_raw_users_26m raw /dev/raw/raw3... (2 Replies)
Discussion started by: Amitstora
2 Replies

2. Shell Programming and Scripting

setting Oracle Home

Hi, if i set Oracle home in the command line as export ORACLE_HOME=/usr/oracle/product/9.2.0; and then checking it by typing echo $ORACLE_HOME,its getting the correct result.But if i try setting the ORACLE_HOME from a shell script by just including the same line as above,it was... (3 Replies)
Discussion started by: DILEEP410
3 Replies

3. UNIX and Linux Applications

oracle user and group setting

I am seeking help on this issue. When I installed Oracle 10g on Solaris 9 sparc box, I created user oracle and assigned oracle user to primary group Oinstall and second group dba. Then installation went successful. After that, I created another user ccmm and assigned ccmm to dba group. Then I... (1 Reply)
Discussion started by: duke0001
1 Replies

4. UNIX and Linux Applications

Setting up Oracle RAC at home

Hello, I'm planning to set up Oracle 10g RAC at home. I was initaillay planning to get a windows desktop and install Cent OS after wiping out the existing windows OS. I have some questions with regards to this. 1) For setting up RAC, I would have to install an additional NIC besides the one... (2 Replies)
Discussion started by: luft
2 Replies

5. Solaris

Is there a difference between setting a user as nologin and setting it as a role?

Trying to figure out the best method of security for oracle user accounts. In Solaris 10 they are set as regular users but have nologin set forcing the dev's to login as themselves and then su to the oracle users. In Solaris11 we have the option of making it a role because RBAC is enabled but... (1 Reply)
Discussion started by: os2mac
1 Replies
Session::Oracle(3)					User Contributed Perl Documentation					Session::Oracle(3)

NAME
Apache::Session::Oracle - An implementation of Apache::Session SYNOPSIS
use Apache::Session::Oracle; #if you want Apache::Session to open new DB handles: tie %hash, 'Apache::Session::Oracle', $id, { DataSource => 'dbi:Oracle:sessions', UserName => $db_user, Password => $db_pass, Commit => 1 }; #or, if your handles are already opened: tie %hash, 'Apache::Session::Oracle', $id, { Handle => $dbh, Commit => 1 }; DESCRIPTION
This module is an implementation of Apache::Session. It uses the Oracle backing store and no locking. See the example, and the documentation for Apache::Session::Store::Oracle for more details. USAGE
The special Apache::Session argument for this module is Commit. You MUST provide the Commit argument, which instructs this module to either commit the transaction when it is finished, or to simply do nothing. This feature is provided so that this module will not have adverse interactions with your local transaction policy, nor your local database handle caching policy. The argument is mandatory in order to make you think about this problem. This module also respects the LongReadLen argument, which specifies the maximum size of the session object. If not specified, the default maximum is 8 KB. AUTHOR
This module was written by Jeffrey William Baker <jwbaker@acm.org>. SEE ALSO
Apache::Session::File, Apache::Session::Flex, Apache::Session::DB_File, Apache::Session::Postgres, Apache::Session perl v5.12.1 2007-09-28 Session::Oracle(3)
All times are GMT -4. The time now is 06:32 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy