06-22-2007
Quote:
Originally Posted by
arksjd
In my .Profile file initially I had given
export NLS_LANG="BRAZILIAN PORTUGUESE_BRAZIL.WE8ISO8859P1"
and later I commented it.
When I connect to sqlplus from shell prompt and query
"select * from nls_session_parameters" it gives
PARAMETER VALUE
------------------------------ ----------------------------------------
NLS_LANGUAGE BRAZILIAN PORTUGUESE
NLS_TERRITORY BRAZIL
[...]
It's because you've started the instance or the listener (if you're using @service_name) when the NLS_LANG was set to PORTUGUESE_BRAZIL.WE8ISO8859P1 (or you've create d the database with that character set). You can overwrite this value at a session level (that's why on Windows you're seeing a different value, the one from your registry).
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi there,
I wonder if anyone can help me. I run an application on an AIX 4.3.3 machine, for which I need to set up the LIBPATH environment variable for a specific user. I need this to be set up automatically when the user logs in (via Exceed), so I tried setting this in the .profile file.
... (7 Replies)
Discussion started by: durnelln
7 Replies
2. UNIX for Dummies Questions & Answers
hi , i added ls -F to .profile. and i need to do ./.profile for the effect to take effect BUT i didnt and YET the next day when i came to work and log in, the changes took effect. i am on aix.
please explain..
thanks (4 Replies)
Discussion started by: yls177
4 Replies
3. UNIX for Advanced & Expert Users
Hi
I am not able to setup PS1 environment variable in .profile file in my Home directory.I am using RED HAT3 Linux.this is the excercise that i have done
$echo $SHELL
/bin/ksh
$pwd
/home/khan
$ls -l .profile
-rwxrwxrwx
$more .profile
set -o vi
export PS1='khan'
$echo $PS1
$ (13 Replies)
Discussion started by: reachtokhan
13 Replies
4. UNIX for Dummies Questions & Answers
Hi,
I have a SunOS -s 5.9 Generic_118558-39 sun4u sparc SUNW,Sun-Fire-V210 system.
I need to set up my .bash_profile. I need to do the following thins.
1) set up history
2) Set up VI as my editor
3) Display the current directory at the prompt.
I have tried using the set command, the... (1 Reply)
Discussion started by: kaushys
1 Replies
5. UNIX for Dummies Questions & Answers
Hi.
I have a directory structure built with links. For example: /home/user1 is a link to /var/123/user1
can i set the home variable in the .profile of the user to use a link? or it has to be a "real" directory?
tks (1 Reply)
Discussion started by: mrodrig
1 Replies
6. Shell Programming and Scripting
Hi,
I need to append the current system date and time in my file which are being taken a backup by my shell script .so i added the following line in by .profile
SYSDATE="$( date '+%d/%B/%Y/%S' )"
export SYSDATE
But it's a constant one rather then a sync with my system date ,so how can i do... (10 Replies)
Discussion started by: malickhat
10 Replies
7. Shell Programming and Scripting
I need help in settings to Hp-UX , Solaris , AIX-UX ..
I worked on Linux previously ... now i am working on Hp-UX , Solaris , AIX-UX ..
up/down arrow , to see history of previous command (basically to modify ) and few keyboard keys are different ... so i need to set .profile , .cshrc , ... to... (1 Reply)
Discussion started by: girija
1 Replies
8. UNIX for Dummies Questions & Answers
Hello everyone,
I want to set my properties of my profile to umask 022 by default. I have an idea that i need to make the change in .profile file. Can you please help me, on how would i be able to set it.
Thanks,
Abhishek S. (4 Replies)
Discussion started by: abhisheksunkari
4 Replies
9. UNIX for Dummies Questions & Answers
What's the purpose of setting the profile in side the script?
however the user when logins, the profile wil be set.
Then why we need to use that explicitly inside the script?
Thanks (1 Reply)
Discussion started by: pandeesh
1 Replies
10. AIX
I have a system with the following settings:
min:0.10
Assigned: 2.0
Max: 6.0
Partition is uncapped weight is 128.
I would like to know if even if this is uncapped, is the max it can use 6?
The actual pool has 16.
I remember reading about this somewhere but I don't remember can anyone... (3 Replies)
Discussion started by: techy1
3 Replies
LEARN ABOUT PHP
oci_set_client_info
OCI_SET_CLIENT_INFO(3) OCI_SET_CLIENT_INFO(3)
oci_set_client_info - Sets the client information
SYNOPSIS
bool oci_set_client_info (resource $connection, string $client_info)
DESCRIPTION
Sets the client information for Oracle tracing.
The client information is registered with the database when the next 'roundtrip' from PHP to the database occurs, typically when an SQL
statement is executed.
The client information can subsequently be queried from database administration views such as V$SESSION.
The value may be retained across persistent connections.
PARAMETERS
o $connection
-An Oracle connection identifier, returned by oci_connect(3), oci_pconnect(3), or oci_new_connect(3).
o $client_info
- User chosen string up to 64 bytes long.
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
Setting the client information
<?php
$c = oci_connect('hr', 'welcome', 'localhost/XE');
// Record the client information
oci_set_client_info($c, 'My Application Version 2');
// Code that causes a roundtrip, for example a query:
$s = oci_parse($c, 'select * from dual');
oci_execute($s);
oci_fetch_all($s, $res);
sleep(30);
?>
// While the script is running, the administrator can see the client
// information:
sqlplus system/welcome
SQL> select client_info from v$session;
NOTES
Note
Oracle version requirement
This function is available when PHP is linked with Oracle Database libraries from version 10 g onwards.
Tip
Performance
With older versions of OCI8 or the Oracle Database, the client information can be set using the Oracle DBMS_APPLICATION_INFO pack-
age. This is less efficient than using oci_set_client_info(3).
Caution
Roundtrip Gotcha
Some but not all OCI8 functions cause roundtrips. Roundtrips to the database may not occur with queries when result caching is
enabled.
SEE ALSO
oci_set_module_name(3), oci_set_action(3), oci_set_client_identifier(3).
PHP Documentation Group OCI_SET_CLIENT_INFO(3)