Create Two Services In One Oracle Client?
Feb 10, 2011I have to create the two services(SID) in the same orcale 10g home.
View 2 Replies
ADVERTISEMENT
Client Tools :: Oracle Services For Microsoft Transaction Server?
Apr 2, 2012I want to use SSIS,when i use oracle 10g as a data source to SQL Server 2008 as Destination, it gives error ora-01017 invalid username/password logon denied, i did normal oracle installation and give full privileges(sysdba or sysoper) to the user(sys,system...),when i check connection it shows test connection succeeded but when click on next it gives above error.
View 3 Replies View RelatedRestarting Oracle Services Through Services.msc Is Faster Than Manual
May 17, 2013Restarting oracle services through services.msc is faster then manual (In command prompt).
Even If we have heavy transaction on the oracle database But we can restart the database within minutes by using services.msc But It will take more time in command prompt(sql>shu immediate). So shall we assume here that services.msc is using shut abort command while restarting the database?
Client Tools :: Can Use Oracle Client Version To Create A Database In That Server
Jan 13, 2011can we use oracle client version to create a database in that server.
View 3 Replies View RelatedCreate Database Link With Oracle Client?
Oct 11, 2013on my Windows 7 machine with Oracle Client 12.0.1.0 installed I'm trying to create a database link to a database server, that runs under Oracle Standard Edition1 11.2.0.2. When i login to sqlplus on the client with "sqlplus /nolog" and type the command : SQL> create database link SID connect to user identified by passwd using 'tnsnames.ora connection'; I'm getting an SP2-0640: not logged in.
Ok, thats clear, because i use sqlplus with /nolog option. But on client side normally I have no database, where I can login. So I think, there will be no user, or? The database to which I want to connect is set in tnsnames.ora. Generally: Is it possible to use the Oracle Client to create a database link?
Services On Oracle RAC
Mar 24, 2011I have a 2 node RAC database. I have a service defined as a preferred service for one node and Available for the other node. the service was relocated to the available node. I want to know when it failed over and why. Where would I get this information?
some time After the service failed over to the other node I got connection issues for this service. I relocated the service and the issues went away. Why did it not relocate the service back to the preferred node when these issues were encountered?
PL/SQL :: How To Call Web Services From Oracle Database 10g
Nov 11, 2012How can i call web services from oracle database 10g ?
View 3 Replies View RelatedNetworking And Gateways :: Oracle Heterogeneous Services
Mar 13, 2010I have following file setup for Oracle heterogeneous services for MS Access. I also need to add one more dsn for MS Excel.
# This is a sample agent init file that contains the HS parameters that are
# needed for an ODBC Agent.
#
# HS init parameters
#
HS_FDS_CONNECT_INFO = MyConn
HS_FDS_TRACE_LEVEL = 0
#
# Environment variables required for the non-Oracle system
#
#set <envvar>=<value>
Note: MyConn is for MS Access that I cretaed.
Can we use like this
HS_FDS_CONNECT_INFO = MyConn1, MyConn2,etc.
Windows :: Tool To Monitor Oracle Host And Services?
Jun 29, 2010What tool can be used to monitor Oracle host on Windows environment if the database goes down? I know about "Nagios" but like to know is there any other tool available?
View 6 Replies View RelatedNetworking And Gateways :: Oracle Net Services Configuration Failed
Jul 10, 2008when iam running netca on oracle llg iam getting the following error..[wstdba@ora11g ~]$ netca
java.io.FileNotFoundException: /oraeng/app/oracle/product/11.1.0/app/oracle11g/cfgtoollogs/netca/netca_OraDb11g_home1-0802284PM3437.log (No such file or directory)
at java.io.FileOutputStream.open(Native Method)
at java.io.FileOutputStream.<init>(FileOutputStream.java:179)
at java.io.FileOutputStream.<init>(FileOutputStream.java:102)
at oracle.net.ca.NetCA.main(Unknown Source)
Oracle Net Services configuration failed. The exit code is -1...All my services are up and running..
Forms :: Using Java Importer Tool To Invoke Web Services From Oracle?
Feb 1, 2011I am trying to use the Java Importer tool to invoke web services from Oracle forms.
During my research on Java Importer tool, I found that Quote:"The class browser lists all of the Java classes found on the CLASSPATH. The classes are ordered in the same way that they are represented in the CLASSPATH."
The above quote is from Oracle Documentation.
I want to know where I can find the CLASSPATH so that I can add new Java Classes to it. Our forms builder runs on Unix environment.
RAC & Failsafe :: Stopping Oracle 11g R2 Cluster Services In Windows 2008
Jan 22, 2013I am doing the following steps for stopping the Oracle RAC Services on a 2 node.(OS is Windows 2008 Release 2).
srvctl stop database -d <database_name>
Node 1:
crsctl stop has
Node 2:
crsctl stop has
But i am getting error like Oracle HAS Service not stopped successfully. Finally what i did was stopped the OHAS Service from Windows Services.
which is the right procedure to have a clean stopping of RAC Services in 11g R2.
Networking And Gateways :: Connect To SQL Server From Oracle Using Heterogeneous Services?
Mar 11, 2011I was trying to connect to SQL server from Oracle using Oracle heterogeneous services (HS).But I found that I do not have HS installed on my system. It was mentioned in Oracle website that we need to run 'caths.sql' script under the path $ORACLE_HOME/rdbms/admin.
But I do not have any such folder(rdbms) in my $ORACLE_HOME.What does it mean? And how can I install HS alone on my system(Since I already have oracle)
Server Administration :: Oracle And Active Directory Services - Missing Binaries
Mar 8, 2012What two Active Directory services are stopped when you install Active Directory before Oracle 10g? I know the error message for that and I know why it happened but I just need to know the two services so I can start them again. I think it happened because I installed Active Directory first so when I installed Oracle second it stopped two services and I just need to know them. The error message is:
Active Directory is missing binaries, please restart and try again
Server Utilities :: Does Oracle Forms / Report Services (Standalone) Support Data Export Utility
Jun 10, 2010I have a From which take Logical Backup through oracle export utility. This Form work fine when i Start OCJ4 but when i want to take backup after running oracle Forms & Report services its not take backup.
My Question is dose Oracle Forms & Report Services (Standalone) Support data backup through Export (exp) utility. I have install Oracle Forms and Report Services (Standalone) on Window XP (SP-3).
Server Administration :: Restoring The Oracle Services In Windows 2008 Server
Jun 27, 2012I was trying to delete the database in the test server. When i was deleting listener was already stopped, i continued deleting using dbca, it shown me some alert that datafiles cant be deleted because system could't find database, since listner was stopped so only service was deleted(the one showing in the windows administrator toolsservicesOracleServiceTEST).
All the datafile parameter files are still there. How can i delete the datafiles and parameter files belongs to that database or how to create the deleted service, so that i will start the listener and do the complete deleting of the database.
Client Tools :: Cannot Connect Using JDBC Oracle Thin Client With (New Method)?
Feb 21, 2013The problem is that this connection errors when I try to connect using my SQuirreL client. My developers want to connecting using the SID or the SERVICE_NAME and by using the "New Method" syntax, not the "Old Method" syntax. According to the documentation the "New Method" syntax works with the SERVICE_NAME or the SID. The "Old Method" only works with the SID.
# Host name is vmwwin7634.na.SAS.com
# SID is sting2
# SERVICE_NAME is sting2.na.sas.com
PROBLEM using SID errors ==> jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521/sting2
THIS WORKS using SERVICE_NAME ==> jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521/sting2.na.sas.com
I am using SQuirreL Client version 3.4.0
# Here is the tnsnames.ora entry on the server.
STING2 =
(DESCRIPTION =
[code]...
# In this documentation it says, "On new syntax SERVICE may be a oracle service name or a SID."You can find this on the orafax wiki under JDBC#Thin_driver.
# I was able to connect with the "old method" using the SID only, SERVICE_NAME errors jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521:sting2.na.sas.com
(SQuirreL client error, "Unexpected Error occurred attempting to open an SQL connection.")
jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521:sting2 (this works)
# "New Method"
jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521/sting2.na.sas.com (this works)
jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521/sting2 (this errors)
(SQuirreL client error, "Unexpected Error occurred attempting to open an SQL connection.")
Client Tools :: How To Connect From Client To Oracle Database In Unix
Dec 11, 2012I have new virtual UNIX machine and I installed oracle client on /usr/lib/oracle. Also I have a oracle database and I am able to connect to this database from my desktop sql developer.
So now I am trying to connect from new UNIX machine. Where I created tnsnames.ora file under /usr/lib/oracle/network/admin and before connecting did export the following
export TNS_ADMIN=/usr/lib/oracle/network/admin
export ORACLE_HOME=/usr/lib/oracle/
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$PATH:$HOME/bin:/sbin:$ORACLE_HOME/bin
export ORACLE_SID=VFIODSD1
when I try
# sqlplus
username :xxxxxxx
password : xxxxxxx
ORA-12545: Connect failed because target host or object does not exist. Not sure what I missed here. using same tns file I am able to connect from sql developer on windows.
Client Tools :: Oracle Client 32 Bit On Windows Server 2008 R2 64 Bit
Jul 20, 2012Can i install Oracle 10g Client 32 bit on our Windows Server 2008 R2 64 bit?
View 1 Replies View RelatedClient Tools :: Install Oracle To Get Latest SQL Plus Working On Client PC
Jul 11, 2012I need to install Oracle client to get latest sql plus working on client pc as the problem is, i am not able to find out where i can download this , i just need the sql plus as i am not able use many commands because when i installed oracle forms 6i client tool , sql plus 8.0 got installed.
View 4 Replies View RelatedClient Tools :: ODBC Instant Client Oracle 10g
Jun 28, 2010The version is Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi. for Unix AIX 5
I install the ODBC Driver Manager, Basic Instant Client, ODBC Instant Client packages (libsqora.so, odbc_update_ini.sh).
The error:
[oracle@d4 oracle] $ isql OracleODBC-10g user passtemp -v
[01000][unixODBC][Driver Manager]Can't open lib '/home/oracle/instantclient_10_2/libsqora.so' : file not found
[ISQL]ERROR: Could not SQLConnect
Configuration
odbcinst.ini
[Oracle10gODBCdriver]
Description = Oracle ODBC driver for Oracle 10g
Driver = /u01/app/oracle/product/10.2.0/db_1/lib/libsqora.so
Setup =
FileUsage =
CPTimeout =
CPReuse =
The documentation explic with exists the file libsqora.so.10.1 but not exists in the ODBC Instant Client packages.
I applied ln -s libsqora.so.10.1 libsqora.so but the connection not function
odbc.ini
[oradns]
Application Attributes=T
Attributes=W
BatchAutocommitMode=IfAllSuccessful
CloseCursor=T
[code].......
Client Tools :: Create Utl File Setup?
Jul 23, 2012Is there any setups required for creating a utl file using sql developer. If yes, what are the setups to be done.
View 1 Replies View RelatedClient Tools :: How To Create Complete Setup
Mar 27, 2012I would like to pursue pl/sql developer as my carrier.So I would like to create a setup in the following manner in my windows 7(64 bit) laptop.Since I heard that,In real time the setup will be look like as follows
Windows7 as front end
Toad --> to practice Pl/Sql(Preferred use in windows7)
Solaris OS (To install Oracle 10g in Solaris & practice scripting)
Virtual Box (Open source tool to run both windows and solaris)
How I can create setup so that I can accomplish following things(To gain knowledge in programming/scripting).
1.Both OS has to be run simultaneously with Virtual Box So that
Oracle will be running in backend(Solaris)
2.Practicing Oracle Pl/sql in Toad (Windows7)
3.Practicing shell scripting in Solaris.
Is it possible to create the setup as i mentioned above.
Client Tools :: Create Sub Folder Using SPOOL
Mar 5, 2010I want to ask if we could create a sub folder using the SPOOL command. I tried the following but it gave "Cannot create Spool file" error.
SPOOL C:TESTABCABC.sql
where TEST is already present in the C drive whereas I want SPOOL command to create a sub-directory named 'ABC' and then create the spool file 'ABC.sql' isnside it.
Is this possible ? My OS version is MS XP.
Client Tools :: Create Database On Server
Mar 30, 2012If i create database on server(remote desktop connection) and try to some R&D like shutdown or startup command it will effect my other database or not.
View 1 Replies View RelatedClient Tools :: Create Directory In UNIX
Jun 28, 2013What is the script for creating SQL directory in UNIX.
Create or replace directory CONFIG as 'c:Config'
Client Tools :: Create MDD File - Database Designer
Jun 5, 2013I heard .MDD file is Database Designer for MYSQL(i don't knw exactly).how to create it..
View 1 Replies View RelatedClient Tools :: How To Connect To Oracle 7 Using Client
Dec 15, 2011I have Oracle 7 database on Server1. I need to connect this using Oracle client from windows XP.
I have downloaded Oracle client 3.0 and when I am trying to connect it saying "Unable to connect: Unsupported Oracle version".
Client Tools :: Identify Oracle Client
Oct 3, 2011I would like to know if there is some specific file who identifies the installation of Oracle Client in some machine.
View 4 Replies View RelatedClient Tools :: Create Shortcut On Desktop To Have SQLPLUS (command Line)
Sep 6, 2010The way to create a short cut on desktop to have an sql*plus (command line).
i.e. I want to have an short cut on desktop when I click that short cut that would connect me to a specific database with a username and password (which i supply while creating the shortcut-I would provide the database name, username and password)