04-05-2006
Help to set the oracle environment????
Hi,
I am trying to set the environment for my oracle database. I have 5 database in an unix box. My idea is to create 5 files for each database with the following script on it.
After logging into the unix box ...just by typing the database name....the enviornment for the database will be set.
not able to set the environment by calling the file name which is sadev(same as database name)
1. Created a file with name sadev
2. contents in sadev file
export ORACLE_SID=SADEV
echo $ORACLE_SID
3. running the file
eg: deveopmentbox# sadev
sadev
# echo $ORACLE_SID
sademo
I am not able to set the environment the ORACLE_SID=sadev. The "sademo" is set in the .profile of the user.
when i execute the commands inside the file i am able to set the environment for any database instance.
Is there anything wrong in the above steps???
Many Thanks,
9 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Installed a program, need to set the system up so that when the executable is entered, it finds the path to the executable. In Windows, set under system properties, advanced, environmental variables. How do I do this with Unix? Specifically using Solaris 9. I have tried:
env... (3 Replies)
Discussion started by: kohoutek
3 Replies
2. UNIX for Advanced & Expert Users
hi,
I am writing c++ code in unix operating system.In that i need to set the environment variable in unix.
suppose previously i have environment variable like path="something" now i need to change the path value to some othervalue . so that some other program will access that path value... (1 Reply)
Discussion started by: sada@123
1 Replies
3. Linux
Hi,
I am quite new to Linux. And I have doubt how to set new environment variable with value to a C executable.
Let say I have a environment variable $Hack ;
I would like to load a value for this variable; so that when the C executable is executed, the $Hack would set the variable value.
... (4 Replies)
Discussion started by: ahjiefreak
4 Replies
4. Shell Programming and Scripting
I am running this pre-script with a post scripts that needs to share the same variables. How do I keep the environment variable settings for the next script to access from the RMAN Script?
Prescript #1
#RMAN Script
#!/bin/ksh
ORACLE_SID=INVPRD;export ORACLE_SID... (1 Reply)
Discussion started by: gzs553
1 Replies
5. Solaris
I am working with solaris 9 sunBlade150 Box.
I Installed a program, need to set the environment variable so that when the executable is entered,it finds the path to the executable.
The documentation for the software says: Set the appropriate environment variable:
Connect to server failed;... (8 Replies)
Discussion started by: smartgupta
8 Replies
6. Shell Programming and Scripting
Hi,
I can run shell script from the command line using
$ . set
If the run the script inside perl script using
$var = system("set");
print $var;
This prints 0.
This command sets up the environment from command line. But when used inside the shell script or perl script it... (2 Replies)
Discussion started by: sandy1028
2 Replies
7. Shell Programming and Scripting
Hi,
i have the following env variable. currently i am exporting variable in the same script file. but i need this is in a text file and the scripts need to export this variable from the text file.
can you please suggest me. is it possible.
export... (6 Replies)
Discussion started by: rsivasan
6 Replies
8. Shell Programming and Scripting
Hi
Could you please tell me how to set environment variables in Unix ksh.
And how can acess those varibles in shell scripts
( Please give the code with an example)
For my scenario.
We have written number of shell scripts with hard coded username and password.
But if we want to... (1 Reply)
Discussion started by: shyamu544
1 Replies
9. UNIX and Linux Applications
Good evening
I nned your help pls, In an unix server i want to connect to a remote oracle databse server by sqlplus.
I tried to find out the user/passwd and service name by env variable and all Ive got is this:
ORACLE_SID_REPCOL=SCL_REPCOL
ORACLE_SID=xmeta
ORACLE_SID_TOL=SCL_PROTOLCOL... (2 Replies)
Discussion started by: alexcol
2 Replies
LEARN ABOUT ULTRIX
kdb_init
kdb_init(8krb) kdb_init(8krb)
Name
kdb_init - initialize the Kerberos master database
Syntax
/var/dss/kerberos/bin/kdb_init [ realm-name ] [ database-name ]
Arguments
realm-name The realm of the Kerberos database.
database-name
A database specified so that the current and files are not overwritten.
Description
The utility creates and initializes the Kerberos master database. The utility creates the database files: and It also initializes the
database by adding three database entries: the master database principal, a Kerberos default principal, the ticket-granting service princi-
pal ( and the password changing principal,
The master database principal is the entry to the database itself. You cannot use or modify the database without the master database pass-
word. The Kerberos default principal provides a template for service principals.
The ticket-granting service, is used by Kerberos principals to obtain tickets to communicate with other Kerberos principals. The password-
changing principal is not used.
If realm-name is omitted when you enter the command, prompts for it. The program also prompts for the master database key. You cannot
manipulate the database without this key.
By using database-name, you can create another database to prevent the current and files from being overwritten.
After using to set up the master database, you may want to use the utility to hide the master database password on the database host
machine. This enables Kerberos administration programs to access and manipulate the master database, without needing the password to be
entered manually.
Files
See Also
kdb_util(8krb), kstash(8krb), kdb_edit(8krb), kdb_destroy(8krb)
kdb_init(8krb)