We tried to use to connect to DB using jdbc:Oracle:Oci8:@<SERVICE-A>. Connection fail / refuse with one DB .But its working with other databases.
But through toad, jdbc thin client were able to connect. But this has happen suddenly and were able to connect previously. How to navigate this... (0 Replies)
Hi All,
We are having LINUX server.
I would like to connect to oracle database from server to with the help of shell script and execute a procedure.
We dont have oracle installed to use sqlplus and connect to database.
Do we have any command to connect to database using JDBC drivers.
... (1 Reply)
What I am trying to do is install Remedy on a Solaris machine. However to install Remedy on Solaris, the server has to be able to connect to the oracle database on the Linux server? How can I accomplish this? (8 Replies)
Hi
I need one help for connecting oracle from unix. I have query.ctl file where i have wriiten my oracle query.How can i execute this sql throgh unix
thnxx all (1 Reply)
asadmin-create-jdbc-resource(1AS) User Commands asadmin-create-jdbc-resource(1AS)NAME
asadmin-create-jdbc-resource, create-jdbc-resource - registers the JDBC resource
SYNOPSIS
create-jdbc-resource --user admin_user [--password admin_password] [--host localhost] [--port 4848] [--secure|-s] [--passwordfile filename]
[--terse=false] [--echo=false] [--interactive=true] --connectionpoolid ID [--enabled=true] [--description text] jndi_name
Registers the JDBC resource. 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.
--echo setting to true will echo the command line statement on the standard output.
--interactive prompts you for the required options that are not already specified.
--connectionpoolid name of the JDBC connection pool. If two or more JDBC resource elements point to the same connection pool element,
they will use the same pool connections at runtime.
--enabled determines whether the resource is enabled at runtime.
--description text description of the JDBC resource.
OPERANDS
jndi_name JNDI name for resource to be created.
Example 1: Using the create-jdbc-resource command
asadmin> create-jdbc-resource --user admin1
--password adminadmin1 --host pigeon --port 5001
--connectionpoolid XA_connection_pool --description
"creating a sample jdbc resource" sample_jdbc_resource
Command create-jdbc-resource executed successfully
Where: sample_jdbc_resource is the resource that is created.
EXIT STATUS
0 command executed successfully
1 error in executing the command
asadmin-delete-jdbc-resource(1AS), asadmin-list-jdbc-resources(1AS)J2EE 1.4 SDK March 2004 asadmin-create-jdbc-resource(1AS)