10-05-2007
database connection failing from linux
Hi,
I am trying to connect to an Oracle database using the following code :
sqlplus username/password@database_name
It was showing an error 'username/password invalid'
But i tried: sqlplus username/password ,it was connecting now.
Can anyone suggest what may be the issue and why?Can i track from where did it fetch the database information?
Your help is appreciated
With Regards
Dileep Pattayath
10 More Discussions You Might Find Interesting
1. Programming
Hi!
I have very limited experience in UNIX, I have couple questions about database connection in C programs.
I used to use pro*C to setup database connection to a remote Oracle server when I was in school about 2 yrs ago, is this method still in use in commercial C programs nowdays?... (2 Replies)
Discussion started by: whartoner
2 Replies
2. Programming
i want to connect c++ to ms access.
i am not clear about the concept of odbc
please make me clear that for the above connection which version of odbc i will need?
i am working on solaris
so is there any kind like an odbc for windows and odbc for solaris?
form where i can get the odbc... (0 Replies)
Discussion started by: ramneek
0 Replies
3. UNIX and Linux Applications
Hi,
Hi we have application running on Unix Server(solaris10), which establishes connection(sessions) with DATABASE(oracle 10g) which is on another server and firewal is there in between. After some time i am usually getting connection time out(oarcle error 3114/3113) in some of my... (0 Replies)
Discussion started by: ajaysahoo
0 Replies
4. Shell Programming and Scripting
Hello.
I have to make a script with more than 1 SQL query and the problem is that i have to alternate from sql commands to unix commands.
what i would like to know if it's posible(and how) to keep the databse connection opened till last sql command is ran and execute unix commands while the... (2 Replies)
Discussion started by: daniel1988
2 Replies
5. Shell Programming and Scripting
Hi,
I am touching shell scripting after a long gap of 3 years and forgotten almost all of it.
So need help from everyone to revamp myself.
To begin,please tell me what does this part of script do ( I have been asked to go thru a script and get a feel of it):
#get database connection... (1 Reply)
Discussion started by: agarwal
1 Replies
6. Ubuntu
Hi,
How to creating connection to mysql.I try to connect but the following error coming .How to solve it.
Could not connect to New MySQL.
Error creating SQL Model Connection connection to New MySQL. (Error: com.mysql.jdbc.Driver)
com.mysql.jdbc.Driver
Error creating JDBC Connection... (2 Replies)
Discussion started by: snallusami
2 Replies
7. Solaris
hi,
I'm setting up a home lab and I am having problems keeping my connection open on putty. every time i leave it for about 10 seconds and come back I keep having to re-connect. I'm more of a AIX person and trying to get more fimilar with Sun but some of the commands I am trying to run to diag... (2 Replies)
Discussion started by: vpundit
2 Replies
8. Shell Programming and Scripting
Hi All,
I'm trying to connect to Sybase via shell script. i'm getting the following error.
Please let me know where i'm going wrong. Note that i'm not having this issue when connecting via terminal.
#!/usr/bin/bash
SYBASE=/usr/sybase
ISQL=$SYBASE/bin/isql
export SYBASE ISQL
... (6 Replies)
Discussion started by: Irishboy24
6 Replies
9. UNIX for Advanced & Expert Users
HI !!
I have this setup where I have Windows machine and a UNIX based DUT .
I try to make a https connection from my Win to the DUT giving its IP.
But,it is not working (It should do).
What do u think the problem is ?? I checked the logs , they flag some writesocket:broken pipe error in... (1 Reply)
Discussion started by: leghorn
1 Replies
10. Programming
Hi All.
Does anybody here know the System I database? it's from IBM. because i don't know how to connect on the database using unix. How do i know what parameter will i use?
Thanks, (2 Replies)
Discussion started by: znesotomayor
2 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)