Sponsored Content
Top Forums Shell Programming and Scripting By default connect to the oracle at the time login to Unix Post 302288286 by rajesh08 on Tuesday 17th of February 2009 02:04:00 AM
Old 02-17-2009
Hi Ranjith,

Thanks for your input.
Could you please mention the exact steps, so that it is better for me to go ahead furhter.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to connect oracle from unix

Hi All, I am trying to connect oracle from unix mechine but i am getting an error like Ksh: sqlplus: not found Any one please tell me how to connect oracle from unix mechine. I would appreciate if any one send the query. Regards, Ravi kumar.Gongati (2 Replies)
Discussion started by: ravi gongati
2 Replies

2. Shell Programming and Scripting

How to COnnect to Oracle database from UNIX Box

I am trying to connect to Oracle Databse from UNIX box using sqlplus command. But i get sqplus not found message. $ sqlplus sqlplus: not found I have searched in forums and all are suggesting to set environment varaibles...can somebody tell me what variables to set and how to set.and the... (12 Replies)
Discussion started by: angelarosh
12 Replies

3. Shell Programming and Scripting

Perl connect to remote oracle db without local oracle installation

I want to use Perl to connect to a remote Oracle DB I have no oracle installation on my server (and dont plan on installing one) I am using solaris 9 on x86 server. Is this possible? I basically want to run some basic sql queries on the remote oracle db which I have access to using perl on my... (0 Replies)
Discussion started by: frustrated1
0 Replies

4. Shell Programming and Scripting

How to connect with oracle database using unix...

Hi all I am working in datawarehouse project and use DB2 database . shell scripting is written to connect with DB2 database in my application but i dont know how to connect with oracle databse or other databases.Is there any command in unix to connect any of these datbases? (6 Replies)
Discussion started by: vijays3
6 Replies

5. Shell Programming and Scripting

Unix - Oracle DB Connect

Hello, Returing to Unix scripts after a long while, This might be a simple question for most of you , I need to connect from a .sh script to oracle, select XYZ.nextval from dual , , meaning either get the Current Val or Next Val for a sequence. How do I store the return value , I know... (2 Replies)
Discussion started by: Shanks
2 Replies

6. Shell Programming and Scripting

Connect Oracle using shell script at run time

Hi all, I am a newbie.....am jus trying to connect to oracle thro a script, but not thro giving the username/password@server_name directly like `$ORACLE_HOME/bin/sqlplus username/password@server_name In the above line, once it is connected to Oracle, it shud ask me the username and password... (4 Replies)
Discussion started by: kritibalu
4 Replies

7. Shell Programming and Scripting

TL1 connect and login how to using Unix.

Hi All, I'm a newbie here, I'm just wondering how can i connect and login to TL1 using Unix? is it possible? Please advise, THanks, ---------- Post updated at 03:33 PM ---------- Previous update was at 03:09 PM ---------- is there anyone know how to connect and login in TL1 using... (2 Replies)
Discussion started by: nikki1200
2 Replies

8. UNIX for Dummies Questions & Answers

Not able to connect Oracle

In unix i login as root but when i am conneting to SQL as sqlplus "/ as sysdba" then its telling "sh: sqlplus: not found".. (6 Replies)
Discussion started by: ripudaman.singh
6 Replies

9. Shell Programming and Scripting

Switching user to oracle to connect Oracle 11g DB with 'sysdba'

I need to connect my Oracle 11g DB from shell script with 'sysdba' permissions. To do this I have to switch user from 'root' to 'oracle'. I've tried the following with no success. su - oracle -c "<< EOF1 sqlplus -s "/ as sysdba" << EOF2 whenever sqlerror exit sql.sqlcode;... (2 Replies)
Discussion started by: NetBear
2 Replies

10. UNIX and Linux Applications

Identify a specific environment Oracle variable to connect a remote Oracle database ?

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
SD_READAHEAD(3) 						   sd_readahead 						   SD_READAHEAD(3)

NAME
sd_readahead - Control ongoing disk boot-time read-ahead operations SYNOPSIS
#include "sd-readahead.h" int sd_readahead(const char *action); DESCRIPTION
sd_readahead() may be called by programs involved with early boot-up to control ongoing boot-time disk read-ahead operations. It may be used to terminate read-ahead operations in case an uncommon disk access pattern is to be expected and hence read-ahead replay or collection is unlikely to have the desired speed-up effect on the current or future boot-ups. The action should be one of the following strings: cancel Terminates read-ahead data collection, and drops all read-ahead data collected during this boot-up. done Terminates read-ahead data collection, but keeps all read-ahead data collected during this boot-up around for use during subsequent boot-ups. noreplay Terminates read-ahead replay. RETURN VALUE
On failure, these calls return a negative errno-style error code. It is generally recommended to ignore the return value of this call. NOTES
This function is provided by the reference implementation of APIs for controlling boot-time read-ahead and distributed with the systemd package. The algorithm it implements is simple, and can easily be reimplemented in daemons if it is important to support this interface without using the reference implementation. Internally, this function creates a file in /run/systemd/readahead/ which is then used as flag file to notify the read-ahead subsystem. For details about the algorithm check the liberally licensed reference implementation sources: http://cgit.freedesktop.org/systemd/systemd/plain/src/readahead/sd-readahead.c resp. http://cgit.freedesktop.org/systemd/systemd/plain/src/systemd/sd-readahead.h sd_readahead() is implemented in the reference implementation's drop-in sd-readahead.c and sd-readahead.h files. It is recommended that applications consuming this API copy the implementation into their source tree. For more details about the reference implementation see sd- readahead(7) If -DDISABLE_SYSTEMD is set during compilation this function will always return 0 and otherwise become a NOP. EXAMPLES
Example 1. Cancelling all read-ahead operations During boots where SELinux has to relabel the file system hierarchy, it will create a large amount of disk accesses that are not necessary during normal boots. Hence it is a good idea to disable both read-ahead replay and read-ahead collection. sd_readahead("cancel"); sd_readahead("noreplay"); SEE ALSO
systemd(1), sd-readahead(7), daemon(7) AUTHOR
Lennart Poettering <lennart@poettering.net> Developer systemd 10/07/2013 SD_READAHEAD(3)
All times are GMT -4. The time now is 12:37 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy