i am trying to install oracle client on D:User-Applicationsoracle.
But i am getting this error: [INS-32012] Unable to create directory: D:User-Applicationsoracle.
i am installing on windows box my previous installations are sucessfull but i dont know why i am getting this
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]....
Oracle Database 11.2.0.3.0 64bitI have followed most steps of this link and I came to a stop at the point where I use the Network Configuration Assistant.I have selected the following
1) Directory Usage Configuration>
2) Microsoft Active Directory>
3) Operation (2nd): Select the directory server you want to use, and configure the directory server for Oracle usage.>
4) Input my AD hostname>
5) Then it displays a message that "The directory contains an older version of the required Oracle Schema. Directory usage configuration cannot continue without the correct Oracle Schema. If you have authorization to create the directory schema then you can upgrade the Oracle Schema now. Would you like to upgrade the Oracle Schema? I have selected: Yes, I want to upgrade... and thereafter I get the errors:
The Assistant is unable to create or upgrade the Oracle Schema for the following reason:
ConfigException: Could not upgrade the Oracle Schema: oracle.net.config.ConfigException: TNS-004409 Directory Service Errorcaused by: oracle.net.config.DirectoryServiceException: TNS - 04431: DirectoryService: no entries foundcaused by: oracle.net.ldap.NNFLException.You may need to upgrade the directory schema from a specific computer which directly supports your directory type.
Command Line Error Response
ConfigException: Could not check for the Oracle Schema: oracle.net.config.Config
Exception: TNS-04409: Directory service error caused by: oracle.net.config.DirectoryServiceException: TNS-04431: DirectorySe
rvice: no entries found caused by: oracle.net.ldap.NNFLException
i want to know how to create directory or folder which use pl/sql coding in oracle developer suite10g
my problem is when i use this code
trigger WHEN-BUTTON-PRESSED
EXECUTE IMMEDIATE 'CREATE OR REPLACE DIRECTORY'||'C:RESTAURANT';
IT'S ERROR WITH "Error591 this feature is not supported in client-side programs"
I used to use function with webutil that's webutil_file.create_directory('c:RESTAURANT');
trigger WHEN-BUTTON-PRESSED
WEBUTIL_FILE.CREATE_DIRECTORY('c:RESTAURANT');
BUT STILL HAVE ERROR WITH "Error 221 'CREATE_DIRECTORY' is not a procedure or is undefined "
How to create directory with pl/sql that's use in oracle form in trigger when-button-pressed or how to use function webutil_file.create_directory();
I am attempting to read from the maillog of our server, but I wish to make as few changes as possible for fear of blocking other systems access to the file.
I was initially going to call create directory maillogs as '/var/log/maillog' and then drop directory maillogs; when I was done but I found my user does not have "create any directory" permissions.
Rather than compromise security of the existing database configuration, I thought I would permanently add the maillogs to the list of available data directories. Are there any implications to the filesystem if I do this, or should I be able to add this without consideration of affects.
Understand that I will only be opening the file for (R) READ TEXT access only.
Primarily I am concerned that Oracle (in the background) will keep a file pointer open or something of that nature that would block other programs from writing to the file even after I close the file pointer. I want to make as little impact as possible to the file system.
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.
View 3 Replies View RelatedI understand how to create a database directory object to point to a directory on the server File System. Is there a way to take the next step and create a new directory on the host file system from within Oracle?
View 8 Replies View Relatedis it possible to create a button can open directory like My Documents
i test this in CMD command prompte it's work but in forms they are not work
"explorer.exe" & @MyDocumentsDir
or
cmd /c "explorer.exe" & @MyDocumentsDir
in forms : i create a button with trigger When-button-pressed
my host('"explorer.exe" & @MyDocumentsDir');
host ('cmd /c "explorer.exe" & @MyDocumentsDir');
but it's not work
What is the script for creating SQL directory in UNIX.
Create or replace directory CONFIG as 'c:Config'
I am trying to do the following-
CREATE DIRECTORY my_dir AS 'd:oraclefiles';
GRANT READ,WRITE ON my_dir TO PUBLIC;
The above throws up an error-
ORA-00942: Table or view does not exist
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Product
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
I am new in external table so i have tried following cmd.
create directory dir_1 as 'E:ora_dirt' ;
grant read, write on directory dir_1 to HR;
select * from all_directories;
create table emp_ext
(emp_id number,
emp_name varchar2(30)
[code]...
since I am not able to see DIR_1 in E: drive due to which i havnt created 'emp.dat' file and on executing select on external table i m geting expected error *"ORA-29913: error in executing ODCIEXTTABLEOPEN callout ORA-29400: data cartridge error KUP-04043: table column not found in external source: EMP_ID"*
how to create that file in directory "DIR_1" .
I am doing an experimental setup of Siebel Servers in Linux . For this , i had installed Oracle 11gR2 x64 db in OEL 5.4 x64 , and created a db instance 'oracle'. But , i am not able to tnsping to the db (installed on the same machine).
PSB o/p..
[oracle@localhost ~]$ source oraenv
ORACLE_SID = [oracle] ?
The Oracle base for ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_1 is /home/oracle/app/oracle
[Code].....
Had started up the db successfully using 'startup' command in the sql prompt.
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 was prompted by an error in the middle of Oracle 11g Release 2 installation and unable to continue further.
The error was file not found e:product11.2.0.dbhome_3oc4jj2eeoc4j_applicationsapplications em.ear.
i am installing oracle 11g rel2 ( o/s : hp ux 11.31 ). already we have 11g rel1 installed in the machine where oracle inventory location is /oracle/oraInventory where /oracle is ORACLE_BASE directory..
cd /oracle
ls -ltr
drwxrwxr-x 4 ora11gr1 dba 8192 Aug 30 00:19 oraInventory
now when i install oracle 11g rel2 on the same machine, it should use the existing oraInventory..but it is prompting us to enter the new location for oraInventory during installation....but as per the naming convention, we need to keep inventory directory under /oracle/oraInventory only..
when i select oraInventory location as /oracle/oraInventory from wizard, iam getting below error:
[INS-32055] The Central Inventory is located in the Oracle base.
[INS-32035] Unable to create a new central inventory at the specified location.
should i uninstall the exisitng oracle 11g rel1 and then should i install rel2 (i.e what iam trying to install now ) ?if so, after instlaling rel2, then should i install rel1 ?
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.
I tried to reinstall oracle 11g on windows 2008 R2 and couldn't complete the installation as i am unable to start the oracle service. The system gives the following error message
Instance created.
DIM-00019: create service error
O/S-Error: (OS 1053) The service did not respond to the start or control request
in a timely fashion.
I try to manually create the service and it gives me the same error.I also tried to start the service using the net start as follows
C:UsersAdministrator>net start oracleserviceprod
The service is not responding to the control function.
Having looked at the event viewer in windows, I noticed three different error messages as followsr
Application popup: Microsoft Visual C++ Runtime Library : Runtime Error!
Program: c:appadministratorproduct11.2.0dbhome_1inORACLE.EXE
R6034
An application has made an attempt to load the C runtime library incorrectly.and then A timeout was reached (30000 milliseconds) while waiting for the OracleServiceprod service to connect.
The OracleServiceprod service failed to start due to the following error:
The service did not respond to the start or control request in a timely fashion.
unable to start the DBCONSOLE immediately after installing Oracle 11G R2 onto my Windows 7 box. Here is what I have ran from the command line:
Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
C:Userssandifer>emctl start dbconsole
Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to database unique name.
C:Userssandifer>SET ORACLE_HOSTNAME=localhost
[code].....
I checked the above listed file path, and sure enough, OC4J_DBConsole_localhost_orcl is missing.
I'm trying to install Oracle10g in win7 Home premium. It is installing but problem is when installation process trying to create database on the system, a message is appearing which telling that ORA-12546:TNS:permission denied.
View 1 Replies View RelatedI was trying to create a 11g database on linux using dbca.
At very end "create database" I got 'The file pach +DATADG/orcl/system01.dbf in invalid. Check the permissions.'
How to check the permission?
I´m having a trouble creating a db package. I´ve changed my job and now i´m working full on DB instead of Forms Developer.
So my trouble is that i want to create some like a global cursor on DB package, i know you can create global variables and use it on all the procedures/function inside the package. But how about cursors?
My problem: I dont´know how to declare into the spec. I don´t know how to use it on body.
My actual
I have the structure below:
PackageSpec:
CREATE OR REPLACE PACKAGE [i]MyPackageName[/i]
IS
CURSOR [i]myGlobalCursor[/i](par1 IN VARCHAR2, par2 IN DATE)(
);
PROCEDURE [i]MyProcedure1[/i](par1 IN VARCHAR2, par2 VARCHAR2);
[code]....
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 encountered a problem with oracle db where by i'm unable to create a user.
oracle@kapstadt4:/export/home/oracle/scripts> ls -l
total 12
-rw-rw-rw- 1 oracle dba 1115 Sep 10 15:34 crdb.sql
-rwxrwxrwx 1 oracle dba 429 Sep 10 15:39 create_advantage_user.sql
-rw-rw-rw- 1 oracle dba 597 Sep 10 15:38 create_advantage_user_objects.sql
-rw-rw-rw- 1 oracle dba 408 Sep 10 15:37 create_advantage_user_roles.sql
-rw-rw-rw- 1 oracle dba 976 Sep 10 16:04 tbs.sql
oracle@kapstadt4:/export/home/oracle/scripts> cat create_advantage_user.sql
-- creates an advantage database user
-- the role 'advantage_admin_user' must be available!
define user_name = &1
rem define default_table_space = &2
create user &user_name
identified by &user_name#123
default tablespace IN_DEV
temporary tablespace TEMP;
grant connect to &user_name;
grant resource to &user_name;
grant advantage_admin_user to &user_name;
connect &user_name/&user_name#123
@create_advantage_user_objects.sql
[Code] ........
I have exported and imported a schema from one server to another. In the source schema, I have a public synonym. I do not know the name of that synonym. In the destination schema, the public synonym is missing. How to create the public synonym which is missing in the destination database? In the source, I queried dba_synonyms, all_synonyms... but it returns no rows selected.
View 2 Replies View RelatedI have created a procedure to build trigger dynamically using Dynamic SQL. Here procedure created successfully, when we execute the procedure to build trigger getting the following error.
Note: We are able to create a Trigger, but it is INVALID. if we get the code of a trigger and execute, trigger created a successfully with Valid Status.
ERROR:
ORA-24344: success with compilation error
ORA-06512: at "APPS.CREATE_TRIGGER", line 28
ORA-06512: at line 2
SQL*Plus internal error state 2087, context 47:0:0
Unsafe to proceed
create table t (a varchar2(20),b number(8));
insert into t values ('aa',4);
insert into t values ('ba',6);
insert into t values ('ca',7);
insert into t values ('da',8);
in place of 8 there can be any number between 1 to 100
if in place of 8 number is <10
insert into t values('ea',10); ---- this i need dynamic insert
if in place of the number between 11-19 then
insert into t values('ea',20); ---- this i need dynamic insert
and so on
i tried as below
select case when max(b) <10 then 10 when max(b) between 10 and 20 then 20 end from t;
but i cant write case for again and again upto nth
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"
View 7 Replies View Relatedproblem with oracle 10 g . i started service through server i got some error
ora-09925 unable to create audit trail file.
3 files are missing in admin folder these are three files adump, dpdump, pfile was missing i have not taken any backup also.
in admin file also the database folder name was missing.
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 have to create a materialized view for a table which does not have index on any field.
While creating a Mview i am getting an error "TABLE DOES NOT HAVE THE PRIMARY KEY CONSTRAINT".
application developers do not want to create an index on the base table onto which MView is to be created.
is there any way to create a materialised view for the table without index, or is it necessary to have the index on the base table before creating MView on it.