08-06-2013
Quote:
Originally Posted by
tapan8984
...
My query is how to ignore the password expiry warning message and access the oracle table using unix. Currently, I am unable to access the oracle table using unix as there is a warning message of password expiry.
May be my earlier message content was bit unclear, let me be more concise. Can we access an oracle table using unix, when there is a warning for password expiry in the db. Password has not expired yet.
...
Fair enough, let me be more concise as well.
Can we access the Oracle table? -
yes we can if we have the right client, no we cannot if we have the wrong client.
An example of the right client is sqlplus - the command-line client shipped with Oracle. It displays and bypasses this warning and lands you to the SQL prompt.
An example of the wrong client is sqlldr - it does not load data if that warning is encountered.
Most likely, your client happens to the wrong one.
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hi,
under SUN Unix, in which file the expiry date of a user password is indicated ?
Many thanks. (2 Replies)
Discussion started by: big123456
2 Replies
2. UNIX and Linux Applications
Hi Oracle & Unix expert,
Could you tell me how to encrypt oracle table ? Thanks. (1 Reply)
Discussion started by: olaris
1 Replies
3. Solaris
Hi,
Is there any way of sending an email to a number of users indicating that the passwords of user accounts will expire?
Currently we have a test server with a number of oracle test accounts on it. Each of these accounts correspond to an instance of Oracle on the server. These... (2 Replies)
Discussion started by: sparcman
2 Replies
4. Solaris
Hi,
Is there any way of sending an email to a number of users indicating that the passwords of user accounts will expire?
Currently we have a test server with a number of oracle test accounts on it. Each of these accounts correspond to an instance of Oracle on the server. These... (2 Replies)
Discussion started by: sparcman
2 Replies
5. Solaris
Hi Gurus
I have a few Sol 5.9 servers and i have enabled password less authentication between them for my user ID. Often i have found that when my password has expired,the login fails.
Resetting my password reenables the keys.
Do i need to do something to avoid this scenario or is this... (2 Replies)
Discussion started by: Renjesh
2 Replies
6. UNIX and Linux Applications
Actually in my application there is an XML file. The password and the user name for the database that I need to access the development box is stored there.
But using some UNIX command I am able to access the raw content of the file and not the decrypted code for that password. When I am applying... (3 Replies)
Discussion started by: nandumishra
3 Replies
7. Shell Programming and Scripting
Hi,
Could someone please let me know how to write script for passwd expiry notification on salaries boxes.
Regards
Dnyan (1 Reply)
Discussion started by: dnyan
1 Replies
8. Solaris
Hi
How do i disable password expiration on ldap?
It runs on Solaris 10 machine. Thanks in advance. (3 Replies)
Discussion started by: hrist
3 Replies
9. Shell Programming and Scripting
Hi All,
I want to write a shell script to change the password on list of database servers, please guide me how do I achieve this.
Please see below sample, how it is asking while manually changing the password,
sqlplus test@oracle
SQL*Plus: Release 9.2.0.2.0 - Production on Thu Jun 16... (4 Replies)
Discussion started by: gr8_usk
4 Replies
10. Shell Programming and Scripting
Hi All,
I want to write a script that will send the alert when linux server password expiry for user 'x' is less than 12 days.
I have written the below script but this is not working for expiry date 04 july
script;-
P_EXPIRY_DATE=`chage -l msdp| grep 'Password expires' | awk ' {... (2 Replies)
Discussion started by: abhigrkist
2 Replies
LEARN ABOUT SUNOS
get-client-stubs
asadmin-get-client-stubs(1AS) User Commands asadmin-get-client-stubs(1AS)
NAME
asadmin-get-client-stubs, get-client-stubs - gets the stubs of the client
SYNOPSIS
get-client-stubs --user admin_user [--password admin_password] [--host localhost] [--port 4848] [--secure|-s] [--passwordfile filename]
[--terse=false] [--echo=false] [--interactive] --appname application_name local_directory_path
Gets the client stubs JAR file for an AppClient standalone module or an application containing the AppClient module, from the server
machine to the local directory. This command is supported in remote mode only.
OPTIONS
--user authorized domain application server administrative username.
--password password to administer the domain application server.
--host machine name where the domain application server is running.
--port port number of the domain application server listening for administration requests.
--secure if true, uses SSL/TLS to communicate with the domain application server.
--passwordfile file containing the domain application server password.
--terse indicates that any output data must be very concise, typically avoiding human-friendly sentences and favoring well-
formatted data for consumption by a script.
--echo setting to true will echo the command line statement on the standard output.
--interactive prompts you for the required options that are not already specified.
--appname name of the application.
OPERANDS
local_directory_path path to the local directory where the client stub should be stored.
Example 1: Using get-client-stubs
asadmin> get-client-stubs --user admin --password adminadmin
--host fuyako --port 7070 --appname myapplication.ear /sample/exmple
EXIT STATUS
0 command executed successfully
1 error in executing the command
asadmin-undeploy(1AS)
J2EE 1.4 SDK March 2004 asadmin-get-client-stubs(1AS)