When using oakcli to create an oracle home in ODA, are there any parameters or configuration files to determine the directory to install the database software? I want to create 3 separate 11.2.0.3 ORACLE_HOMEs in these directories, all owned by the 'oracle' user..
where:
version - Version information for creating the database home.
That would install Oracle 11.2.0.3 into /u01/app/oracle/product/11.2.0.3/dbhome_1 only. The reason for the separate homes is for flexibility to patch them independently of each other (ie dependent on only the requirements of the products they support)
I cannot start ASM on my Oracle Database Appliance.
crsctl status resource -t says: ora.asm ONLINE ONLINE node1 Started ONLINE ONLINE node2 Started
however, if I try to access the ASMCMD it says: [grid@node1 ~]$ asmcmd Connected to an idle instance. ASMCMD> startup ORA-00304: requested INSTANCE_NUMBER is busy Connected to an idle instance.
I have a major problem my oracle_home/bin directory was delete mistakenly by on of our user. Because i cannot use all oracle utitilessqlplus,dbca,netca,netmgr. how do i the cover this problem?
I saw big size .core file is generated in $ORACLE_HOME/dbs folder even when no dump dest parameter is set to dbs folder. How to check what causing this genrarating of these files.
To one of my server i can see listener log are on normal location i.e. $ORACLE_HOME/network/log and on other server listener log is DIAG home. how to move listener log from ORACLE_HOME to DIAG_HOME.
oracle > lsnrctl status LISTENER LSNRCTL for HPUX: Version 11.2.0.2.0 - Production on 29-JUN-2012 10:20:14 Copyright (c) 1991, 2010, Oracle. All rights reserved. Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for HPUX: Version 11.2.0.2.0 - Production Start Date 03-MAY-2012 08:09:57 Uptime 57 days 0 hr. 10 min. 16 sec [code]...
bash: sqlplus: command not found Error 6 initializing SQL*Plus Message file sp1<lang>.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
i install oracle 10gR and the process was successful i could do everything. the problem started when i install Zend Core for oracle, the install of zend was successful but i now can't start sqlplus.
i 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.
I have CPU based Oracle server license. In this case as per license policies of Oracle I can have unlimited database with unlimited users connecting it.
I need to create as many as 100 database with upto 100 users (max) for each database as client. What is the recommended hardware for this server? CPU/ RAM/Harddisk, recommended chipset on the motherboard (in case of database storage capacity required is not high typically - 20 GB is OK per database - average), redundancy is critical, also Oracle database vault is going to be installed; as security is of prime importance between users of different database. Which specific server models from specific vendors like IBM/ Dell/ HP are good ones for this purpose?
I have installed oracle 9i in my PC.I would like to know the answer for the following questions.
1.Is it possible to create more than one database in oracle? If so, can it be used simultaneously through sqlplus? 2.If it is not , how can I move from one database to another?
Usually where should we create the database link? In the production or development? create public database link dblinkname connect to user_in_db2 identified by password_in_db2 using 'tnsentry name in db2'; In production or development?
I'm trying to create a materialized view on a database on my local laptop, and when I execute the create it fails with the following error: ORA-06550: line 1, column 60:
PLS-00103: Encountered the symbol ".16" when expecting one of the following: . ( @ ; with the table name highlighted.
CREATE MATERIALIZED VIEW Schema.MV (col1, col2,) BUILD IMMEDIATE REFRESH Complete ON DEMAND WITH PRIMARY KEY AS select EXTRACTVALUE (rawxml, '/Test.class/@ID') AS col1, EXTRACTVALUE (rawxml, '/test.class/test.attribute.name') AS col2, from RAWXML where Type = 'test.classvalue';
The query on its own though executes fine.
select EXTRACTVALUE (rawxml, '/Test.class/@ID') AS col1, EXTRACTVALUE (rawxml, '/test.class/test.attribute.name') AS col2, from RAWXML where Type = 'test.classvalue';
Is there something wrong with the table setup? I have tried creating a public synonym and still the error comes up.
I installed Oracle 10g XE on windows7 to create a database i opened "start database command interface" and created an SID and followed some steps afterwards i am facing "TNS ADAPTER NOT FOUND"
I have two production servers and business required a another one or two new databases need to create in these server A & B. what are the important things i need to task it while give this kind of recommendation.
Below is for your reference and in server A how database we can create[need sga size & pga size] and server B as well.
Server Name Physical Mem SGA PGA Existing DB Name Server A 48GB 8gb 6gb PRODA 8gb 6gb PRODB
Server B 48GB 8gb 6gb PRODA 4gb 3gb PRODB 4gb 3gb PRODC
Note: Due to new database existing production db performance should not affect.
I need to create a database with a langauge set to Polish and territory set to Poland. I use dbca to create the database. I set there these settings but when the database is created and I try following sql commands I get this output.
I am installing Oracle 12c R1 on Windows 2012. The windows is configured as a domain controller. I am logged in as the domain administrator.I created a normal domain user -- DomainNameORACUSER. I provided this as the existing user id during Oracle installation.
The software installs fine, but when creating the DB using the database configuration assistant, an error is shown "error in process:...inoradim.exe. Enter password for Oracle service user: DIM-00019: create service error. O/S-Error: (OS 87) The parameter is incorrect". The DB is not created.
I skipped the db creation and completed the installation. When tried to create the db using the database configuration assistant after installation, I received the same error.I performed the same installation on Windows 8 and was successful in creating the db.
I want to create a database trigger which will test the database link, if it is ok then it will use dblink and do its work.
If it fails then it will send the data into its own server logfile.
I Wrote:
CREATE OR REPLACE TRIGGER PERMIT.TESTTRG AFTER INSERT OR UPDATE ON PERMIT.TR_LP_M_H_COMPANY_25072012 REFERENCING NEW AS New OLD AS Old FOR EACH ROW Declare l number; nIgn PLS_INTEGER; nRows PLS_INTEGER := 0;
[code]....
When I execute it it is giving error:
LINE/COL ERROR -------- ----------------------------------------------------------------- 4/11 PLS-00201: identifier 'EXEC_SQL.CONNTYPE' must be declared 4/11 PL/SQL: Item ignored 8/2 PLS-00320: the declaration of the type of this expression is incomplete or malformed
create a new DB service and apply the load , then I need to verify the service load from Enterprise Manager or table V$SERVICEMETRIC .
Below are what I did
Quote:I tried to add service in tnsnames.ora like below
SERVICE = (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(PORT=25057)(HOST=dadvmc))(CONNECT_DATA=(SID=tgc4)))
/************ Also I tried the serviceName like below, but not working when I conneted SALES1 from sqlplus SALES1 = (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(PORT=25057)(HOST=dadvmc))(CONNECT_DATA=(SERVICE_NAME=host.us.xxx.com))) **********/
and login as
sqlplus scott/tiger@SERVICE[/email][/email]
then lock table EMP in exclusive mode in two session.
I can see the load is added to service SYS$USERS , but I can't see the new service from V$SERVICEMETRIC or Enterprise Manager.
here we have san server and rac database two node database.i want to know how can i create directory on rac database. i know how to create directory on single database but i do not know how can i create directory on rac database.
