Forms :: Use MS Sql Server Database With 6i Without Oracle Database Install
Feb 6, 2010Can we use M.S Sql Server Database with Forms 6i with out oracle database install.
View 1 Replies
ADVERTISEMENT
Server Administration :: Install Oracle 11.2.0.2 Single Instance Database On AIX 6.1?
May 4, 2011I want to install oracle 11.2.0.2 single instance database on AIX 6.1, does oracle recommend separate OS user for grid infrastructure and for oracle install? how many groups I need to have for these users like oinstall, dba etc?
View 1 Replies View RelatedXE :: Install Oracle 10g With Different Database
Feb 4, 2013Oracle database 10g Express Edition...I need to install "Oracle database 10g Express Edition" with different database name example dev but it is taking default name that is XE and there is no option come during installation where i can put the name of database as per my desire.
And also explain why we use "Oracle database 10g Express Edition" instead of Oracle database 10g. what is the meaning of Express Edition.
Installation :: Install Two Database Instances In The Same Server
Jun 4, 2013We 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?
Windows :: Install Oracle Database 11g.2?
Aug 6, 2011 I am trying to install oracle database 11g.2 on windows 7. bu I received error in configuration database step.error is attached to this topic. installed database on windows so far.the emca text is below .....
-----
@echo off
setlocal
set OH=E:appproduct11.2.0dbhome
set JRE_JAVA=%OH%jdkjreinjava
[code]...
Size Of Typical Oracle Database Install Plus Service Pack?
Aug 25, 2011I was just asked by one of the sysadmins what the typical size of an oracle database install plus service pack be?
View 1 Replies View RelatedInstallation :: Unable To Install Oracle Database Client On Linux?
Jan 4, 2013I 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.
RAC/ASM Clusterware Installation :: OLR Integrity Error During Oracle Database Install
Sep 12, 2012OS=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.
Installation :: Install Latest Release Of Oracle Database On A Solaris 11 Zone
May 11, 2013which 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.
PL/SQL :: Difference Between Install Database And Create Database?
Jan 11, 20131.what is the difference between install database and create database?
2. if i have connected with remote database(server) then it is an instance again?
Server Administration :: Many Lock On Oracle Database Using Forms
Mar 30, 2012I have a RAC environment with 3 nodes and application using Oracle Form Reports that access the database. Every day the application cause many locks on database when execute insert, update and delete. I don't understand why so much locks. Are there a way to avoid this? Always I have to eliminate session causing locks.
View 27 Replies View RelatedVNC Hangs While Installing 11.2.0.3.0 After Giving Finish Button To Install Database
Sep 20, 2012My VNC Hangs after completing all the steps in dbca while installing 11.2.0.3.0 after giving finish button to install database.
Completed All software installation.
Red Hat version: Red Hat Enterprise Linux Server release 6.2 (Santiago)
Linux xxxxxxx.xxxxx.net 2.6.32-220.el6.x86_64 #1 SMP Wed Dec 7 10:41:06 EST 2011 x86_64 x86_64 x86_64 GNU/Linux
How To Install Weblogic Server 9.2 MP4 On Oracle Enterprise Server 10
May 27, 2012I am trying to find documentation of how to install Oracle Weblogic Server 9.2 mp4 on Oracle Enterprise Server 10. The operation system is SuSE Linux Enterprise 9 sp4.
View 1 Replies View RelatedServer Administration :: How To Install Oracle 8i And 9i Databases On Same Server
Feb 20, 2011How to install oracle 8i and 9i databases on same server for example i want that both type of databases run on same server.
View 7 Replies View RelatedServer Administration :: Installing Oracle Database 10.1.0.2.0 On Windows 2003 Server 64bit?
Jan 11, 2011i am trying to install Oracle 10.10.2.0 on Windows Server 2003 standard x64 Edition Service Pack, but when i try to run the installer or open DVD it gives me below error.
"The image file D: is Valid, but is for a machine type other than the current machine."
Install Oracle 10g And 11g In Same Linux Server?
Jul 19, 2012Looking to install oracle 10g in same server where i have installed already oracle 11g,
: i have looked at how to install oracle 11g and 10g on same linux server.but didn't quite get it ....
Export/Import/SQL Loader :: Oracle 9 Database Refresh From Production Server To Integration Server
Oct 13, 2012I will have to proceed with Oracle 9 database refresh from production server to integration server. 5 biggest schemas must be exported and imported. They constitute 97% space used in a database. This is very big database so I would like to be sure that everything will go smoothly. That is why i want to ask you some questions.
Have you got any clues for me before I start with exp/imp? From my side i will tell you that I will have to exp/imp schema by schema because there is small space both on production and integration disk for a dump. First thing I thought are dependencies between schemas that are exported and that which are not, and also between schemas that are exported/imported one by one.
This is procedure that I plan:
For every schema that is to be refreshed
{
1. Export schema with ROWS=N CONSTRAINTS=Y
2. EXPORT schema with ROWS=y CONSTRAINTS=N
3. Import schema from step one
4. Disable all the foreign key constraints using ALTER TABLE DISABLE CONSTRAINT.
5. Import schema with rows
}
ALTER TABLE ENABLE CONSTRAINT
With above procedure i think that I will avoid problems with dependencies between schemas exported/imported one by one. But my concern is if there are any dependencies between those schemas and schemas that are not exported. Is there an way to check it before refresh ?
Server Administration :: Unable To Find Server Process In Oracle Database For Specific Application / Client
Feb 13, 2013I am trying to find the unix process for one of my application in the database but I am unable to view the same. To simulate, I did the following.
1. My database runs on different server.
2. I invoked "sqlplus" from another unix box to login to the database.
3. I found that the process id (ps -ef |grep sqlplus).
4. When I execute the below mentioned query it does not display the process id that I am looking for. But the osuser, username, program and machine details are correct. How can I know the process details from the database?
SELECT SYS.GV_$SESSION.OSUSER, SYS.GV_$SESSION.USERNAME, SYS.GV_$PROCESS.SPID,
SYS.GV_$SESSION.MACHINE, SYS.GV_$SESSION.PROGRAM,
SYS.GV_$PROCESS.PROGRAM ,SYS.GV_$SESSION.SQL_ID
FROM
SYS.GV_$PROCESS, SYS.GV_$SESSION
WHERE
SYS.GV_$PROCESS.ADDR=SYS.GV_$SESSION.PADDR and SYS.GV_$SESSION.USERNAME='TEST'
and SYS.GV_$SESSION.MACHINE like '%hostname%'
Server Administration :: Oracle 10g - Database Server Startup / Shutdown
Jun 29, 2011I recently installed Oracle 10g on my windows Xp laptop. It has become considerably slow since then. I want to start the database server only when I need it, and not every time I start my laptop. I looked around in OEM and did found a way.
View 5 Replies View RelatedServer Administration :: Oracle Database Server - Logon Denied
Jul 19, 2011I am connected as System. It was the only user I set-up a password when installed the database on personal computer.
SQL> alter user sys identified by mypass007
2 /
User altered.
SQL> connect sys/mypass007
ERROR:
ORA-28009: connection as SYS should be as SYSDBA or SYSOPER
[code]...
SQL> conn sysoper/mypass007
ERROR:
ORA-01017: invalid username/password; logon denied
Server Administration :: Database Configuration Assistant Not Working / When Create New Database
Mar 26, 2011i am installing oracle database 8.1.7 on dell server power edge 2650 first time database successfully installed but when i want to crate new database by Database Configuration Assistant it is not working for new database creation.
View 1 Replies View RelatedWindows :: How To Install Oracle 11g In Server 2008 R2
Dec 24, 2011How to install oracle 11g in Window Server 2008 R2.
View 6 Replies View RelatedForms :: Install Oracle 11g Client
Aug 20, 2012I just installed WEBLOGIC server on linux with oracle forms 11g builder and report builder on the server.
On the client machine , i have probleme to intsall oracle forms 11g , in one of the steps it asks me to enter the absolute location of server weblogic , i enter the location of the weblogic on the server , but it dosent' work. is it mean that i have to install the weblogic on the client machine too!! if not to install forms builder 11g on the client
Forms :: Install Oracle 5i On XP Machine
Oct 30, 2012I am getting below error when I try to install Oracle Form5i on XP machine.
"OS_ERROR while translating path from $"
Server Administration :: From Where To Download Oracle 9i Database Server
Aug 17, 2010I have some requirement wherein I need to install Oracle 9i database server (9.2.0.7). I am not getting it on Oracle website. where can I get the download.
View 1 Replies View RelatedServer Utilities :: Import Table From Another Database By Using Database Link?
Mar 17, 2010i would like to import a table from another database by using database link.
impdp muba/muba tables=FUNCTION_NO directory=testdump NETWORK_LINK=DBLINK1
i created the public database link as system user
it gave error like
Import: Release 10.2.0.1.0 - Production on Wednesday, 17 March, 2010 11:07:02
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Release 10.2.0.1.0 - Production
Starting "MUBA"."SYS_IMPORT_TABLE_01": muba/******** tables=FUNCTION_NO directory=testdump NETWORK_LINK=DBLINK1
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
[code]....
after that i try to import as system user like
impdp system/passwd tables=FUNCTION_NO schemas=muba directory=testdump NETWORK_LINK=DBLINK1
but error like
Import: Release 10.2.0.1.0 - Production on Wednesday, 17 March, 2010 11:27:43
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Release 10.2.0.1.0 - Production
UDI-00010: multiple job modes requested, schema and tables.
when i use IMP utility
imp system/passwd file=dump.dmp fromuser=userA touser=userB log=dmplog.log but when i use IMPDP what is the parameter equal to fromuser & touser
CPU For Oracle Database Server?
Jan 21, 2013We have license for maximum six cores CPU, and we had to choose a server for Oracle single instance database with one of these two processors:
Intel Xeon E5-2643
============
#core: 4, #Threads: 8, Clock Speed: 3.3GHz, Max Turbo: 3.5GHz, Cache: 10MB, System Bus: 8GT/s, DDR3-max 1600, Memory Bandwidth: 51.2GB/s
Intel Xeon E5-2640
============
#core: 6, #Threads: 12, Clock Speed: 2.5GHz, Max Turbo: 3GHz, Cache: 15MB, System Bus: 7.2GT/s, DDR3-max 1333, Memory Bandwidth: 42.6GB/s
For database server what is more important, number of cores, cache, or clock speed, system bus, or DDR speed and memory bandwidth?
Server Administration :: Install Oracle Client 11G Software In AIX Box?
Jul 25, 2012I am trying to install Oracle client 11G software in AIX box. In /home/oracle, I find 7 profile files. I am not sure which profile file I am supposed to consider.
View 1 Replies View RelatedServer Administration :: Install Oracle 11g On Windows 7 - Just IP Address Available
Jan 17, 2013With just the ip address available, how to install the oracle 11g software on windows 7? What are the access I will need in order to Install the oracle 11g software and create the oracle 11g database on windows 7?
View 7 Replies View RelatedOracle 9i Install In Windows Storage Server 2003
Sep 24, 2006Oracle 9i instalation problems in Windows Storage Server 2003.
I got the error "ORA-12546- TNS:Permission denied" when trying to install ORacle 9i in Windows Storage Server 2003. This error occurs at the time of Creating database.
