I want to install Erwin for data modelling purpose. I am not looking at some heavy data models but a basic model. I am new to data modelling. I was given the CD to install, but I am not sure what I need.
View 1 RepliesI am trying to connect to database using ERWIN Data Modeler (7.1.0) but the following error occurs.
ORA-01041:internal error. hostdef extension doesn't exist.
The connection to database through other tools (e.g PL/SQL Developer etc) are successfully established.
I'm a Data Manager recently hired at a small company that uses InForm as our data management tool. We are currently not set up with any type of SQL tool to query the database. Consequently, I feel like I'm trying to clean data with one hand tied behind my back. I have two questions:
1) Is there any sort of built in feature in InForm for using SQL statement to query the data? (I'm not really a fan of the built in Cognos feature.)
2) Any tool that is easy to install/configure?
I'm facing some resistance here, so I'm looking for a really easy/cheap solution. I've used SQL Developer before, and I know that's free, but is it easy to set-up?
I converted the access db's to access 2003, the version I am running. Still, after fighting with this for a couple of days I can't get this to work and can't find information on what's wrong. I keep getting:
Error #49 - XMLExporter - ActiveX Component Can Not Create Object....Database Schema did not complete successfully.
This is really getting old. If this doesn't work is there a way to copy the tables into SQLDeveloper without the exporter tool? Like I said, I'm really at my end with this.
I 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 RelatedI rarely do client installs. I have not downloaded upgrades on a couple of years. I have been doing other stuff and oracle supports patching page has changed.
Need to install 11.2 on HP Itanium 64 bit. I can get 11.2.0.1 from otn.oracle.com.
1. I downloaded the 11.2.0.1 client from otn. I want to see if there is an 11.2.0.2 or 11.2.0.3 patch on Oracle support. I can only find upgrades that are specifically for the databsae server. Do I use this? See below for the notes I used so far. Note: Oracle Database Upgrade Path Reference List [ID 730365.1]
Which leads me to the following patch below. However, this download is much larger than the client download on otn. It also says 'database server' and does not break out to 'database client'.So not sure if this is what I use to patch the client or not. This upgrade is also much larger than the straight client download. So not sure if this is what I use to just upgrade the client.
Patch:10404530 Description 11.2.0.3.0 PATCH SET FOR ORACLE DATABASE SERVER
Product Oracle Database Family
This upgrade seems to be for the whole database and not just for the client install.
2. Do you apply PSU's to the client? I see them listed for the 'database'. Not sure if you apply to a separate client install.
3. We use the proC pre-compiler. When I look in the instant client download section, I see a seperate section for the proC pre-compiler download. I don't see that for the full blown client. Does the regular client download include the proC pre-compiler?
I had a Windows XP client pc with Oracle Client 11-1-0-6 installed. In my absence this client was reinstalled with Windows 7. Therefore all my Registry and Start - Programs settings have been lost.
However my original 11-1-0-6 Oracle Home still exists intact on my C: drive ( i.e. C:appitjxtproduct11.1.0client_2 )
Is there any way I can use the Oracle installer to register this Client Oracle Home again ( so it appears in the Registry and in START PROGRAMS ) ? or is there a way just to get the installer tio reinstall into the client_2 directory again ?
Most of the ones I'm seeing online relate to the database, not the client. I have linux.x64_11gR2_client.zip and and trying to do runInstaller and I get up to perform prerequisite tests and it tells me that I am missing packages and that kernel parameters are wrong. I've tried to run the runfixup.sh file and get a lot of this:
./orarun.sh: 186: [: true: unexpected operator./orarun.sh: 848: [: unexpected operator./orarun.sh: 864: [: unexpected operator./orarun.sh: 882: [: unexpected operator./orarun.sh: 903: [: unexpected operator./orarun.sh: 1052: [: unexpected operator./orarun.sh: 1057: [: unexpected operator./orarun.sh: 1075: [: unexpected operator./orarun.sh: 1085: [: unexpected operator./orarun.sh: 1115: [: unexpected operator./orarun.sh: 1143: [: unexpected operator./orarun.sh: 1189: [: unexpected operator./orarun.sh: 139: [: unexpected operator./orarun.sh: 139: [: unexpected operator./orarun.sh: 1228: [: unexpected operator./orarun.sh: 1284: [: unexpected operator./orarun.sh: 1342: [: unexpected operator./orarun.sh: 1426: [: unexpected operator./orarun.sh: 1451: [: unexpected operator And many of the supposedly missing packages actually are installed. IE: make. I have make 3.81 installed but the installer insists upon make 3.80.
whether we can install Toad in Mac OS.
View 6 Replies View RelatedI have installed Oracle virtual box on windows host and have created Oracle Linux virtual machine as guest. I have installed the database server on my host machine but rest of the things(Peoplesoft peopletools etc....) on Oracle Linux guest.Now, I am trying to installed database client on guest machine which is Linux so that I can connect to DB server running on host, but having difficulties in doing so.
, I am following the installation instruction given in the doc docs.oracle.com/cd/E11882_01/install.112/e24322.pdf, but when I finally run command runInstaller.sh doesn't happen anything.Actually, to install other software's I just double clicked the .sh file and it automatically started the installation process on a terminal window but when I clicked runInstaller.sh to install DB client, it didn't do anything.
Also, when I run the same command runInstaller.sh from command line after navigating to the directory where this file is present, It throws me error saying "no command found".By the way, why the steps given in doc are so complex, I wish If I could just double click runInstaller.sh just like others and it start the installation process.
I have Oracle 11g database home in my 64 bit Windows 7 machine. However, now i would like to install Oracle 10.2.0 client as well. I tried giving a separate location.
But for some reason, whenever i start the Setup and run the Administrator Type, the installation just skips without giving any errors. It just creates the inventory folder in the specified path. It goes to the Product-Specific Prerequisite Checks and exits without giving any warnings or errors.
How to Install Oracle 9i client software on Windows 8 64bit?
View 7 Replies View RelatedI am try to install the oracle toad 8.6 in oracle 11g 32bit for window 7 operating system.
- the install oracle toad completed, but trying to connection to the database, unable to connect, nothing error when trying to connect.
-is oracle toad 8.6 support to window 7? any version for oracle toad to support window 7.
can u give me link from where i have to learn step by step how to install oracle develor suit 10g on windows 7 32 bit
View 4 Replies View RelatedHad some annoying problems with installing TOAD on Windows 7, 64 bit.Got I working now, but anyway I thought I share it here.
1. Toad 10.1(latest) doesn't work with the Oracle 64 bit client. The problem is that this is a limitation of the tool Quest uses to build Toad. So that will not work in a "near" future.
2. Never choose the default suggested installation path which is "C:Program Files(86)",that will mess it up totally. Point to a new or existing directory without brackets.
can we install oracle 10g,developer 2000 at window7 64 bit
View 9 Replies View RelatedI want to install Toad on Ubuntu 8.04 . provide me link where step by step instruction guide is available
View 3 Replies View RelatedWe use this software Toad for Oracle here and I have just started learning PL SQL.I am coming across a few errors in Toad for Oracle
First of all,
When I execute snippet (Ctrl + Enter), I get this ORA-00900 error and the message that I need to upgrade my version of knowledge xpert. I did that to 10.1. I then restarted my computer and now it is still showing me that error ORA-00900 but without any message. I do not get output, even for simple programs but when I try to execute snippet, it asks for my 'Edit SQL' screen and after which it gives me a few outputs.
Caused our sql 8i not install 100%, while we are using windows 7.
View 2 Replies View Related, We are doing a fresh setup on new hardware. On the old hardware Oracle is installed on the SAN and all data files are on there as well. Our new blades are Dell M620 with 2 mirrored 500GB drives and our SAN is Dell Complaint Storage and Complaint TLS Controller. The SAN uses hybrid SSD storage so it keeps the most used data cached.
I'm feeling it would be best to install the Oracle Server on the SAN. On top of that we have a single 620GB fusion IO NAND flash card in the mix. I am still researching the configuration of that.
I am unable to install Oracle 11g R2 database. The setup screen disappears every time I click the Desktop class during the installation process.
View 8 Replies View RelatedI installed my oracle database successfully but dint install sample schemas.Now i want to install all sample schemas but couldnt find them under $Oracle_home/demo/schema.No **_main.sql is available there. sample scripts as am not in a condition to download companion
View 6 Replies View RelatedWe are planning to install second instance of Oracle 11gR2 in Linux server 2.6.39-400.21.1.el6uek.x86_64 x86_64. This is something we never haven done before. The existing instance has all the standard ports:
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
Enterprise Manager Console HTTP Port (pterpdb02) = 1158
Enterprise Manager Agent Port (pterpdb02) = 3938
What ports should we select for second listener and enterprise manager? Is there anything else that we need to know before we install the second instance?
I am preparing to install grid infrastructure 11.2.0.3 on AIX 6.2 USING AIX LPARS. I am getting the following errors in the output when runningn the following command...
./runcluvfy.sh stage -pre crsinst -n oradbprd016,oradbprd022 -fixup -verbose
These are the errors...
Check: TCP connectivity of subnet "192.168.99.0"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
c-oradb003av:192.168.99.32 oradbprd016:192.168.99.32 failed
ERROR:
PRVF-7617 : Node connectivity between "c-oradb003av : 192.168.99.32" and "oradbprd016 : 192.168.99.32" failed
c-oradb003av:192.168.99.32 oradbprd022:192.168.99.235 failed
ERROR:
PRVF-7617 : Node connectivity between "c-oradb003av : 192.168.99.32" and "oradbprd022 : 192.168.99.235" failed
Result: TCP connectivity check failed for subnet "192.168.99.0"
The physical hostnames of the servers are c-oradb003av and c-oradb005av In which they are aliases as follows in the /etc/hosts files.
# c-oradb003av
192.168.99.32 c-oradb003av.corppvt.com c-oradb003av
192.168.99.32 oradbprd016.corppvt.com oradbprd016
192.168.99.243 oradbvip016.corppvt.com oradbvip016
192.168.100.18 oradbpri016.corppvt.com oradbpri016
192.168.103.18 oradbrep016.corppvt.com oradbrep016
[code]....
it would say it is failing between the physical hostname and the alias which are using the same ip address?
PRVF-7617 : Node connectivity between "c-oradb003av : 192.168.99.32" and "oradbprd016 : 192.168.99.32" failed (it's the same address?)
How can i set db home name at the time of installation of oracle 11.2.O.3 .
View 3 Replies View RelatedOS=Redhat LINUX6
DB=Oracle 11.20.1
Get the following error when installing Oracle. I have java version "1.7.0_05" and based on the log, it appears that Oracle is trying to install the binaries using an older version of java (1.5.0).
# An unexpected error has been detected by HotSpot Virtual Machine:
#
# SIGSEGV (0xb) at pc=0x00000030b7014d70, pid=2615, tid=140142440847120
#
# Java VM: Java HotSpot(TM) 64-Bit Server VM (1.5.0_17-b03 mixed mode)
# Problematic frame:
# C [ld-linux-x86-64.so.2+0x14d70]
#
we have installed oracle database 11.2.0.3.0 using 12G for grid and 8G for DB. And now we want to apply the PSU 11.2.0.3.4, but found that there is not enough.
How much we need to upgrade to 11.2.0.3.4 totally?
I am trying to install the 11GR2 on HPUX 11.31 U ia64 with silent option.while tried to launch runinstaller, I hit the below issue.
dfltest> ./runInstaller -ignoreSysPrereqs -force -silent -responseFile > /db/dfltest/oracle/product/11.2.0/database/db_install.rsp.mainStarting Oracle Universal Installer... Checking Temp space: must be greater than 240 MB. Actual 475 MB PassedChecking swap space: must be greater than 150 MB. Actual 23189 MB PassedPreparing to launch Oracle Universal Installer from /tmp/OraInstall2013-07-17_12-01-18PM. Please wait ...oradev1 oradflts /db/dfltest/oracle/product/11.2.0/databasedfltest> Error: could not find libjava.soError: could not find Java 2 Runtime Environment. ----extracted from following files -----p10404530_112030_HP64_2of6.zipp10404530_112030_HP64_1of6.zip
I'm trying to install 11g Release 2 on a CentOS (4.9) box, but the pre-req check shows that I'm missing the following packages (I had 9 to begin):
gcc-3.4.6 (X86_64)
gcc-c++-3.4.6(X86_64)
libstdc++-devel-3.4.6
Tried to use the yum command "yum install gcc" but get the following error.
Error: cannot find a valid baseurl for repo:update
I think this is due to the "CentOS-Base.repo" file, which I've tried to update by changing the mirror URL's but no success.Then tried to find the rpms online ([URL]...
INFO: Start output from spawned process:
INFO: ----------------------------------
INFO:
INFO: rm -f ntcontab.*
[code]....
OS=Redhat 5
Oracle=11gr2
Grid=11gR2
I am trying to install Oracle Database 11gR2 database on Oracle Grid 11gR2. I successfully installed Grid without errors. However, when installing the database, I got an OLR Integrity error during the prerequisit Check
OLR Integrity - This test checks the integrity of OLR on the local node.
Expected Value : n/a
Actual Value : n/a
List of errors:
- Permissons of file
"/u01/app/oracle/product/11.2.0/grid/cdata/localhost/localhost.olr" did not match the expected value. [Expected = "0600"; Found = "0660"]
- Cause: Cause of Problem Not Available
- Action: User Action Not Available.