I 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
I am new to Dynamic SQL..I create a procedure to get any DDL done against sample HR schema as follows.it goes well! Now when i try to test my procedure with some DDL command passing to the procedure i've created..strange! oracle throws an error as in the /*ERROR!!!!*/ block..
I don't understand why i am facing such an error..
/* Product an Version on my machine */
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for 32-bit Windows: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
[code]...
I have schema level export for user SAMPLE1(Default tablespace USERS) on oracle 9.2.0.1 production database. I want to import into another 9i database on another server, so do i nneed to Create SAMPLE1 user and USERS tablespace in new database again.
View 5 Replies View RelatedI try install oracle 10g and 11g on different computers, at the end of the installation, I find out there is no "HR" schema for me to use, including others. I've been installing the Oracle Database (both the 10g and 11g) I've make the installation over 7 times, yet still the same problem. If you have a book on who to install Oracle Database perfectly,.
View 2 Replies View RelatedCaused 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 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 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 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 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 ?
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 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 Replies View RelatedI 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]....
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.
I 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.
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.
I am trying to create a silent install as part of a batch file that does other things after. I'm running into the following issues
1) I need the batch file to wait until the install is done to continue. Trouble is that running setup with a response file opens up a new windows to run the install. I tried the wait command but doesn't work right either
2) Same issue with DBCA and a response file.
Any way to run the silent installs and have the batch file wait until the install is done and then continue? The less user intervention required, the better.
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 Relatedwhich is really a HA zone clustered in VCS(not important for installation of the database).
What parameters do I need to set or change in the Solaris zone, there seems to be no /etc/system file.
I'm doing some testes installing grid 11.2.0.3 32bits software on a OEL6 32bits (virtual box environment). The problem appeared where i ran root.sh script on node 1. The following error appeared to me:
clscfg: -install mode specified
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
CRS-4256: Updating the profile
[code]..
I am working on SLES 11 SP2 on zLinux and I am trying to install oracle 11gr2 silently. I was able to install the GI and it is running but when I try to install the oracle binaries I keep getting this error:
[FATAL] [INS-32035] Unable to create a new central inventory directory : /opt/oraInventory.
CAUSE: The central inventory location provided is not empty.
The GI install created /opt/oraInventory and all the files are in there. I even changed the owner from grid:oinstall to oracle:oinstall but that did not work. When I did the install on SLES 11 SP1 I did not get this error.
I am running this command to install oracle:
/runInstaller -silent -ignorePrereq -showProgress -waitForCompletion -responseFile /tmp/db_install.rsp
drwxrwx--- 6 oracle oinstall 4096 Apr 2 10:42 oraInventory
drwxrwx--- 2 oracle oinstall 4096 Apr 2 10:39 ContentsXML
drwxrwx--- 3 oracle oinstall 4096 Apr 2 10:41 backup
drwxrwx--- 2 oracle oinstall 4096 Apr 2 10:41 logs
[code]....
I am going to do the SAP-BO Setup in our landscape, how to do the following....
1. How to do the Oracle installation for BO in AIX (UNIX)? Is it a normal installation? or different? BOE-Application will be installed on Windows. So the DB suppose to communicate with the Application.
2. How to do the sizing of database?
3. How to create a database schema in oracle with proper parameters? I need to create 7 schema.
4. What are the parameters we have to maintain in Oracle - init.ora file which is required for BO ?
Just installed Ora 10g Express Edition. It has a sample database. But is there a rather larger database outside that I can download and import into Oracle for some learning reasons?
View 1 Replies View RelatedThe SAMPLE clause in the select statement works well in most cases, but we found in some instances the result is way off - between 200% to 700% discrepancy has been observed.
For example, we have thee tables with the following results:
Table1: 495,365,317 rows (20 cols, unique primary key present), SAMPLE ( 0.002018712182064212 ) returns 41,499 (about four times off - we expected about 10,000)
Table2: 3,350,864,539 rows ( 5 cols, unique primary key present), SAMPLE ( 0.00029843044634040336 ) returns 9,835 (this is good as it is close to 10,000)
Table3: 6,974,724,543 rows ( 5 cols, no unique primary key present), SAMPLE ( 0.00014337483779250091 ) returns 58,789 (about six times off - we expected about 10,000)
The tables got billions of rows, and that is why we want to do sampling. The sample percentage rate is computed to return about 10,000 rows in all three tables.On Table3, we ran the sampling three times in one occasion, and we got "58,570", "24,575" and "24,561"
I expected +/- 20% of variance, but 200% to 700% seems to be way too much.Once again, I stress that it does work well in most cases (another 3.4 billion table and numerous smaller tables we tested were well within +/- 5 percent of the target).I noted the presence of a primary key above because I read an article saying that the SAMPLE function relies on the existence of a primary key (which does not quite explain the examples above).Is this kind of spread something we should expect or is it a bug? Is the sampling rate too small for such large tables?
I have a query on , how to view the sample data from a very table which is large in size ( more than 10 million ).
I just need to see some sample data from a large table ( to see what kind of data which is application related ).
My question is :
Select *
from Sample_table
where rownum < 10
is this a Good way to view the sample data ?
I have understanidng that the rownum will be assigined to the rows once all the rows are reteived.
So what is the best way to view ?..I am not sure of any condition to put in the intial time of querying.
