Forms :: Host Procedure On 6i?
Dec 28, 2009
I've got a problem when I use the HOST procedure to work with DOS Prompt. When I access the DOS Prompt via Oracle Forms HOST Procedure, the name of files and folders got limited by 8 chars plus extension. Lets suppose I want to copy a file and the file name is my_image.jpg. What I have to do is:
HOST('copy MY_IMA~1 C:TEMPIMAGE01');
I guess it sucks cause the function GET_FILE_NAME give me the filename as my_image.jpg. Do I have to convert the filename every time?
View 15 Replies
ADVERTISEMENT
Sep 6, 2013
I have the following requirement.Say I have the following procedure created.create or replace procedure myproc (p1 varchar2, p2 varchar2) is begin
find_the_proc_name();
end;
In the above myproc, using find_the_proc_name() i should print the parent procedure name (or function) calling along with the parameters passed.
View 5 Replies
View Related
Oct 27, 2010
My database as well as application on linux. I want to execute this command on linux. I need equivalent code.
host('cmd /c E:data empITC1'.bat');
code of ITC1.bat is
echo off
sqlldr userid=user_name/pass@database control=E:data empITC1.ctl log=E:data emplogITC1.log
echo ........
control file as well as bat file exist in respective folders.
View 9 Replies
View Related
Jul 22, 2010
I have configues Webutil in Application Server and i am using Client_host to open imageviewer .. but when running the form it gives me error "Orace. Forms.webuti.host bean not found Webuti_host.execute will not work" i have done the following configuration for webutil
File frmwebutil.jar
From folder: webutil_106webutil_106java To: $ORACLE_HOME/forms/java
File: jacob.jar
From folder: jacob_18 To: $ORACLE_HOME/forms/java
File: d2kwut60.dll, JNIsharedstubs.dll
From folder: webutil_106webutil_106webutil To: $ORACLE_HOME/forms/webutil
File: jacob.dll
From folder: jacob_18 To: $ORACLE_HOME/forms/webutil
[code]....
Configuring Database:
1. Connect as Scott or your User
2. Run the script $ORACLE_HOME/forms/create_webutil_db.sql using SQLPLUS or any tool.
Setting up Form Builder:
1. Open Form builder Connect with SCOTT and in PL/SQL libraries open Webutil.pll file
2. File > Save as and Rename the file to different name e.g WebUtil_lib
(Trust me it works to avoid Webutil not found error)
3. Compile the new PLL file and generate it
4. Attached the new named Webutil_lib.pll to your form with Remove Path option YES.
5. Open WebUtil.olb file Object group in builder and copy or subclass it into your form.
6. Now compile your form and run it.
View 2 Replies
View Related
Jul 6, 2010
i was trying to use the host command to run the commands from linux. however, it doesnt work.
PROCEDURE compile_procedure IS
c_success boolean;
c_bare_filename varchar2(50);
command_string varchar2(1000) ;
BEGIN
c_bare_filename := substr(:B_DEV.B_DEV_ITEM_FILENAME,instr(:B_DEV.B_DEV_ITEM_FILENAME,'',-1)+1);
[code]....
View 4 Replies
View Related
Oct 3, 2013
I am using the HOST command within Oracle Forms 10g on Windows server to copy a pdf file from the application server to a network folder on another Windows server.
The command works fine if I logon to Windows app server and type it. But it doesn't work when it is launched within Oracle forms using HOST. The command looks as follow
net use \\FileServer\e-file /user:usergroup\username password & copy D:\RepTmp\myReport.pdf \\FileServer\e-file\test\myReport.pdf
Oracle forms doesn't give any error message at all but the pdf file never gets there. Even when I map the network folder as "R:" drive on the Windows app server, a simple copy command like this does not work with HOST:
copy D:\RepTmp\myReport.pdf r:\test\myReport.pdf
Oracle Forms server is running as "SYSTEM" on the Windows server. If HOST won't work, is there any other way to copy the file other than using fpt?
View 1 Replies
View Related
Nov 3, 2011
I am creating a procedure oracle forms and database Which one is fires first ..If suppose i need data base fires first...
View 3 Replies
View Related
Oct 29, 2010
We are going to test migration of g10 to g11. To reduce maintenance of configuration we want to install new Oracle on the same server and start on the same port with the same SID. To achieve that we are going to configure new Oracle on different IP and hostname (managed by DNS, whatever). So listener will be configured like for different servers with identical SIDs.
View 5 Replies
View Related
Mar 10, 2013
I will be duplicating my production database back to a few weeks ago on my test server, to retrieve certain data. I am running 11g standard edition, not using a recovery catalog.
Below are the basic steps I plan to take in a nutshell.
1. Copy the backup files to the test system
2. In the rman run block (on the test server)
A. Set newname for each of the datafiles and tempfiles (don't have many files)
B. Duplicate command to point in time, specifying backup location and no filename check.
3. Export the data
View 6 Replies
View Related
Jun 3, 2011
I am using windows 7 as my platform...I am not able to set host credential in my system. I want to know how to set host credential in windows 7.
View -1 Replies
View Related
Oct 27, 2010
I want to host name and max logon day from the below query But host name not belongs to start with 'IRS%' and 'EMEAUKIMIV00023828'.
My question is How to handle the backslash in oracle 8i and also check the below query is ok or not,
select host, max(logon_day) from (
select host,logon_day from system.stats$user_log
where host not like 'IRS%'
AND not in ('EMEAUKIMIV00023828'))
group by host;
View 10 Replies
View Related
Dec 22, 2011
i have some confusion with bind and host variable.
View 4 Replies
View Related
Jul 11, 2012
Here i have three tier application. I want to know it host name from sid or sqlid . I want to know which query run on which host. Because i have one user from application to database. So i want to know which query consume more time on which host ?
View 19 Replies
View Related
May 12, 2010
I have a cluster setup, and i want to retrieve host name for my small app.Is there any query which gives me the HOSTNAME where oracle is running??
View 14 Replies
View Related
Aug 13, 2012
Is it possible, Oracle let me connect to an running +ASM instance from a different host? I.E, +ASM running on X host and i want to connect from Y host. (yes Y host has the asm entry in the tnsnames.ora).
View 1 Replies
View Related
Apr 10, 2013
We plan to move the database to a new host with much more RAM, CPU. The new database server will have exactly the same OS version, Kernel version and the same version of database / grid standalone (ASM). I will have to install OS, Database software, Grid Standalone on the new server.
The current version of the database is 11.2.0.3.0 Enterprise Edition and the OS version is Oracle Enterprise Linux 6.3. However, we plan to use the same disks (ASM disks). I believe I don't need to use RMAN to do the migration, Is it correct?
View 7 Replies
View Related
Oct 7, 2012
I have a requirement to move the databases to a new server.
Existing set up:
database1-40GB,
database2-40GB,
database3-180GB
Oracle version - 11.2.0.2
OS - UNIX AIX-5.3
New Server (setup):
database1-40GB,
database2-40GB,
database3-180GB
Oracle version - 11.2.0.3
OS - UNIX AIX-6.1
My query is what is the best way to move the database to new server(UNIX AIX 6.1)?
a) can i upgrade the database to 11.2.0.3 before moving to new server or its better to move the database in 11.2.0.2 and then upgrade there?
b)is export and import of database can work for moving this?
c) RMAN backup and restoration can be done for moving databases?
d)simply moving all the related files to new server and start upgrading it from there?
View 8 Replies
View Related
Jun 27, 2012
I have backup my database,and i want to create a new database in a new host using the backupset?
View 3 Replies
View Related
May 14, 2013
I am trying to use Database Replay in 11g Release 1 using Enterprise Manager. In the last step it asks for 'Host Credentials' to start the capture. But when i give the username and password for the host, it throws error as 'Invalid username/password' all the time.
View 15 Replies
View Related
Feb 14, 2013
the db cannot startup after host crash.
the strange thing is "lkinstrdmetdev" is the wrong name(sid is rdmetdev), and the file does not exist in the FS too. the correct file name should be "lkrdmetdev" and i've deleted this file from the directory. I did not do any changes. and no any oralce processes running while i started up the oracle instance.
Thu Feb 14 09:25:20 EST 2013
sculkget: failed to lock /u01/app/oracle/product/10.2/dbs/lkinstrdmetdev exclusive
Thu Feb 14 09:25:20 EST 2013
sculkget: lock held by PID: 272600512
Thu Feb 14 09:25:20 EST 2013
Oracle Instance Startup operation failed. Another process may be attempting to startup or shutdown this Instance.
Thu Feb 14 09:25:20 EST 2013
Failed to acquire instance startup/shutdown serialization primitive
[code]....
Oracle Instance Startup operation failed. Another process may be attempting to startup or shutdown this Instance. Failed to acquire instance startup/ shutdown serialization primitive
View 17 Replies
View Related
May 30, 2012
saw in one procedure using host function in below manner.
v_status:= host(v_cmd);
But i searched for the host function it is not available.
My question is --Is there any pre defined built-in function "host" in oracle 10g.
View 1 Replies
View Related
Jul 22, 2011
I have 2 server install oracle : server 1 and server 2
server 1 run database DB01
i use rman backup DB01 ( this command : BACKUP FULL DATABASE PLUS ARCHIVELOG DELETE INPUT; ) and move ( The database backup pieces , Controlfile backup piece, The parameter file i.e init.ora file) to server 2 .
At server 2 :
After start database with init.ora file and restore controlfile error :
RMAN-03002: failure of restore command at 07/22/2011 02:56:04
RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece
View 1 Replies
View Related
Oct 24, 2011
I am having a problem in setting Preferred Credentials in OEM.
My env:
O/S: Oracle Enterprise Linux 5.3
OEM: 11g Grid Control.
My OEM is running as expected. I have a few target database instances on different hosts. I can login and monitor all these database instances. Now I am trying to set Preferred Credentials to hosts but none is working. I am doing this as:
1. OEM Console->Preferences->Preferred Credentials.
2. For my host I enter normalusername, normal password, privileged username, privileged password.
3. Then I click on test
I get the following error "ERROR:Connection to TD3OEDB01A as user oracle failed."
I can connect to TD3OEDB01A as oracle user and root user. I am entering correct passwords.
Even when I try to set Preferred Credentials to the same server where my OEM and Repository DB is running (same machine) - it does not work.
There emoms.trc file contents looks like this:
2011-10-24 11:14:42,047 [EMUI_11_14_42_/console/pref/setCredentials$targetType=host] ERROR creds.SetPrefCreds testCreds.1690 - SetPrefCreds.testCreds(): CredsException: All values must be specified for each set of credentials.
2011-10-24 11:23:59,350 [EMUI_11_23_59_/console/pref/setCredentials$targetType=host] ERROR creds.SetPrefCreds saveCreds.1490 - SetPrefCreds.saveCreds(): CredsException: Some credential changes were successfully applied. However, one or more credential sets were not saved for the following targets, due to either missing credential values or not clearing all credential values when attempting to delete credentials: TD3OEDB01A
2011-10-24 11:24:52,929 [EMUI_11_24_52_/console/pref/setCredentials$targetType=host] ERROR creds.SetPrefCreds testCreds.1690 - SetPrefCreds.testCreds(): CredsException: Connection to TD3OEDB01A as user oracle failed.
View 2 Replies
View Related
Mar 30, 2011
I have created a new instance with address
[URL].......
Now ideally I would like to change this so I can access this from another a machine. Is this possible? Or do I have start from scratch?
View 4 Replies
View Related
Oct 21, 2010
I'm not a DBA, but I've inherited an Oracle 11g database on a Linux Red Hat 5 box that I am now responsible for. I've had to relocate it, and my host name has changed. I've muddled through a few changes (network & listener changes), and the database seems to be working a- ok.
My problem is that the OEM doesn't seem to be working now. I don't think the dbconsole is running. When I try to launch it, I'm using the command line:
su - oracle - c "export Oracle_SID=databasename;/u01/app/oracle/product/11.1.0/db1/bin/emctl start dbconsole"
I'm getting the error: EM Configuration issue /u01/app/oracle/product/11.1.0/db1/hostname_databasename not found (obviously replace the hostname and database name with the appropriate names)
The hostname however, contains the OLD hostname.I tried a quick method of copying the folder, and changing the name to include the new hostname, but that didn't work.
View 1 Replies
View Related
May 10, 2011
Am using Oracle 10g on redhat linux machine.
My Agent Connection to Instance is down . I am trying to start it up using EM when i enter my user name and password on host credentials connection fails (am using a suer that installed my oracle software).
View 1 Replies
View Related
Dec 22, 2010
How to get a RAC running in an EC2 environment?
It isn't possible to use one EC2 machine for each RAC node because EC2 can't handle the virtual IPs, but I had thought that I could use one EC2 machine to host several Linux VMs using Virtual Box (the same way that I use Virtual Box on a Windows host). But I can't get Virtual Box working on EC2. The only relevant advice I can find on this is comments to the effect that running any virtualization product with a Xen machine as host is not a good idea.
I do realize that this isn't a 100% Oracle question, but if set up a RAC on an Amazon Cloud machine,
View 1 Replies
View Related
Jun 30, 2013
DB: 11.2.0.3 & OS: RHEL5 Easy Connect Naming method enhances the host naming method by allowing for a port and service specification. My question is does Oracle 11g support Host naming method?
View 4 Replies
View Related
Oct 25, 2012
I'd like to know the Standby hostname and database name (db_unique_name) from primary using SQL. Simply put, which table in primary datbase gives us the standby host and the database name. I am aware that TNSNAMES.ORA contains details, but we cannot use SQL for that. I am also aware of V$ARCHIVED_LOG's DEST_ID column. But, the DEST_ID will not show the host and the db names, neither does V$PARAMETER's LOG_ARCHIVE_DEST_n if SERVICE parameter is set to Connect Identifier.
If I further paraphrase my problem, how I'd relate a dest_id to a standby host and database using SQL.
SELECT <columns> FROM <v$some_view> WHERE dest_id IN (2, 3);
DEST_ID HOST_NAME DATABASE_NAME
--------------------------------------------------------
2 host2 standby_1
3 host3 standby_2DB version : 10g
OS : Solaris 10
View 3 Replies
View Related
Nov 4, 2012
i am having database in server and i have to run my web application in client machine. how to set the connection of server database in web.config file.
View 1 Replies
View Related
