unix and linux operating commands

Oracle database connection pools setting

6 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How to fix connection to Oracle database through shell script?

I have a question regarding how to connect to Oracle Database through shell script. 1. If I want call a stored procedure on Linux server as this, it works. $sqlplus /nolog SQL*Plus: Release 12.1.0.2.0 Production on Fri Jun 12 14:49:49 2015 Copyright (c) 1982, 2014, Oracle. All rights...

2. 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...

3. Shell Programming and Scripting

Oracle Database connection from UNIX

Hi I have a question regarding Oracle connection using the below code ${ORACLE_HOME}/bin/sqlplus -s $user/$pwd@$sid <<!EOF 1>> $v_log_dir/$v_job_log.out 2>> $v_log_dir/$v_job_log.err / prompt stored procedure beginning . . . exec xx_interface_pkg.pr_xx_clms_out($datayears,$keepmonths); ...

4. Ubuntu

Database Connection

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...

5. Solaris

Can't create database after Oracle Database installation

I installed Oracle 10 software on Solaris 11 Express, everything was fine execpt I can't create database using dbca.rsp file. I populated file with following options. OPERATION_TYPE = "createDatabase" GDBNAME = "solaris_user.domain.com" SID = "solaris_user" TEMPLATENAME = "General...

6. Programming

Database connection

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?...

LEARN ABOUT SUNOS

list-connector-connection-pools

asadmin-list-connector-connection-pools(1AS)			   User Commands		      asadmin-list-connector-connection-pools(1AS)

NAME

       asadmin-list-connector-connection-pools, list-connector-connection-pools - gets all the connection pools

SYNOPSIS

       list-connector-connection-pools	--user admin_user [--password admin_password] [--host localhost] [--port 4848] [--secure |-s] [--password-
       file filename] [--terse=false] [--echo=false] [--interactive=true]

       gets all the connector connection pools. This command is supported in remote mode only.

OPTIONS

       --user		       authorized domain application server administrative username.

       --password	       password to administer the domain application server.

       --host		       machine name where the domain application server is running.

       --port		       port number of the domain application server listening for administration requests.

       --secure 	       if true, uses SSL/TLS to communicate with the domain application server.

       --passwordfile	       file containing the domain application server password.

       --terse		       indicates that any output data must be very concise, typically avoiding human-friendly sentences and favoring well-
			       formatted data for consumption by a script. Default is false.

       --echo		       setting to true will echo the command line statement on the standard output. Default is false.

       --interactive	       if set to true (default), only the required password options are prompted.

       Example 1: Using list-connector-connection-pools

       asadmin> list-connector-connection-pools --user admin
       --password adminadmin

EXIT STATUS

       0		       command executed successfully

       1		       error in executing the command

       asadmin-create-connector-connection-pool(1AS), asadmin-delete-connector-connection-pool(1AS)

J2EE 1.4 SDK							    March 2004			      asadmin-list-connector-connection-pools(1AS)