03-29-2006
thanks blowtorch for the quick reply.
9 More Discussions You Might Find Interesting
1. Solaris
How do you make the changes take affect when you change the subnet masks or default router without rebooting? (1 Reply)
Discussion started by: BG_JrAdmin
1 Replies
2. Shell Programming and Scripting
hi ,
i want to store variable but i get always error when i excute this command ligne :
var = awk '{print $1}' file1
echo $var
how can i store the var?
thanks (7 Replies)
Discussion started by: kamel.seg
7 Replies
3. Solaris
Hello gurus,
I have question. I have enabled ssh on the servers.
I am planning to change the oracle user's(os user) password. If I change the password will it affect the authorized_keys? Do I need to regenerate it.
Thanks, (2 Replies)
Discussion started by: oracleuser
2 Replies
4. UNIX for Dummies Questions & Answers
I have modified the .profile in my profile and I don't see any effect.
Why the changes don't have effect?
I tried both on the account at a server where I have limited permissions as user and to my local pc (as user).
Is it the .profile overridden by some other file? It looks weird because I... (8 Replies)
Discussion started by: myle
8 Replies
5. Solaris
Hi,
I have a quick question with regards to creating symbolic links. Would creating a symbolic link from one directory to a file in another cause any issues for users that are currently logged into the box. I don't believe it will unless they are using the file in question, but I would like... (2 Replies)
Discussion started by: Chains
2 Replies
6. Shell Programming and Scripting
I would like to affect an exploded string into an array.
one:two::fourinto an array:
a => one
a => two
a =>
a => four
Quite simple in other languages with functions like explode() or split().
The best I could come up with was this:
until
do
token=${string%%:*} # takes the... (8 Replies)
Discussion started by: ripat
8 Replies
7. Shell Programming and Scripting
Here we have concern. We have a IBM software installed in a server S1 in the location : /opt/IBM.
In this server S1, we have /opt file system in local disk. We don't have any option to increase the file system there.
We have created a separate /opt/IBM_NEW file system with 10GB in S1 server.... (1 Reply)
Discussion started by: mehimadri
1 Replies
8. Shell Programming and Scripting
Hello
I have created next scritpt to do the next: chekp if host is alive. When the host down, launch telnet other equip to do checks.
When execute the script the load average of the machines increase. For example:
Before launch script
top - 11:14:56 up 14 days, 18:06, 3 users, load... (3 Replies)
Discussion started by: capilla
3 Replies
9. UNIX and Linux Applications
Good evening, i need your help please
I will try to describe the scenario briefly: In a Telecom Production system application receives a certain files called CDRs(call detail records) to be processed by doing some operating systems operations and then database operations like creating indexes... (4 Replies)
Discussion started by: alexcol
4 Replies
LEARN ABOUT PHP
oci_password_change
OCI_PASSWORD_CHANGE(3) OCI_PASSWORD_CHANGE(3)
oci_password_change - Changes password of Oracle's user
SYNOPSIS
bool oci_password_change (resource $connection, string $username, string $old_password, string $new_password)
DESCRIPTION
resource oci_password_change (string $dbname, string $username, string $old_password, string $new_password)
Changes password for user with $username.
The oci_password_change(3) function is most useful for PHP command-line scripts, or when non-persistent connections are used throughout
the PHP application.
PARAMETERS
o $connection
- An Oracle connection identifier, returned by oci_connect(3) or oci_pconnect(3).
o $username
- The Oracle user name.
o $old_password
- The old password.
o $new_password
- The new password to be set.
o $dbname
- The database name.
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
oci_password_change(3) example changing the password of an already connected user
<?php
$dbase = 'localhost/orcl';
$user = 'cj';
$current_pw = 'welcome';
$new_pw = 'geelong';
$c = oci_pconnect($user, $current_pw, $dbase);
oci_password_change($c, $user, $current_pw, $new_pw);
echo "New password is : " . $new_pw . "
";
?>
Example #2
oci_password_change(3) example of connecting and changing the password in one step
<?php
$dbase = 'localhost/orcl';
$user = 'cj';
$current_pw = 'welcome';
$new_pw = 'geelong';
$c = oci_pconnect($user, $current_pw, $dbase);
if (!$c) {
$m = oci_error();
if ($m['code'] == 28001) { // "ORA-28001: the password has expired"
// Login and reset password at the same time
$c = oci_password_change($dbase, $user, $current_pw, $new_pw);
if ($c) {
echo "New password is : " . $new_pw . "
";
}
}
}
if (!$c) { // The original error wasn't 28001, or the password change failed
$m = oci_error();
trigger_error('Could not connect to database: '. $m['message'], E_USER_ERROR);
}
// Use the connection $c
?>
NOTES
Note
Changing the password either with this function or directly in Oracle should be done carefully. This is because PHP applications
may continue to successfully reuse persistent connections by authenticating with the old password. The best practice is to restart
all web servers whenever the user password is changed.
Note
If upgrading the Oracle client libraries or the database from a release prior to 11.2.0.3 to version 11.2.0.3 or higher, oci_pass-
word_change(3) may give the error "ORA-1017: invalid username/password" unless both client and server versions are upgraded at the
same time.
Note
The second oci_password_change(3) syntax is available since OCI8 version 1.1.
Note
In PHP versions before 5.0.0 you must use ocipasswordchange(3) instead. This name still can be used, it was left as alias of
oci_password_change(3) for downwards compatability. This, however, is deprecated and not recommended.
PHP Documentation Group OCI_PASSWORD_CHANGE(3)