While Running Forms 11g i get the following message in web browser,.how to deploy forms 11g in weblogic
From RFC 2068 Hypertext Transfer Protocol -- HTTP/1.1:
10.4.5 404 Not Found
aLSO the error file is attached with this.
i m using Oracle 10g release 10.2 database and connecting Oracle Devsuite 10.2 but first time it gives the error of oraut.dll not found. Then this error resolved .
Now when i connecting Oracle devsuite 10.2 's sqlplus with Oracle database then it giving the error of
12560 TNS protocol Adapter error
While i have configured the listener.ora of Oracle 10g database and database is fucting well. but while connecting this to Oracle 10 Devsuite then it gives the error.
i installed oracle 9i release 2 on windows xp professional then i installed form 6i in different home.
i copied tnsnames.ora file from ORACLE_HOME etworkadmin to forms home NET80admin folder....
Once i installed both i can see in the PATH variable both homes then bin directory....
ORACLE_HOME/bin
FORMS_HOME/bin
in these two locations you can find sqlplus.exe file, when i try to login from the command prompt like below
sqlplus "/as sysdba"
it is not going, instead it is coming to command prompt... if i remove FORMS_HOME/bin from the PATH variable i can able to do that...just keep this problem aside.When i try to connect oracle from the forms it is giving error like "ORA-12222 TNS no such protocol adapter...."
While running oracle forms builder 10g,am facing error " ORA-12560: TNS:protocol adapter error ".
View 2 Replies View Relatedl oracle 9i database , and then i install oracle 10g forms, and now when i run my form through browser ,it gives me following error message ..
ORA-12560 :TNS: Protocol Adapter Error
I found another way to transfer the data from forms to excel apart from doing it through ole2 or client. So thought of sharing it with all...
Here it goes:-
declare
ifile client_text_io.file_type;
temp varchar2(1000);
Cursor c1 is select ename, job from emp;
[Code]....
Attach webutil to form and just paste the code on a button and log on to scott. The excel file will be created in c: drive with name test.
I am facing a issue with one of my programming application. We need to transfer a file through pl/sql programming from a unix server to another destination(target) server.
How can we do it through pl/sql programming. I learnt that oracle streams can be used for this.
I do not know what all code is required for this. send me the code for a sample text file.
I also want to encrypt with a password and zip the file
I write a file on database server by following
CREATE OR REPLACE DIRECTORY TEST_DIR AS 'c: emp'
GRANT READ, WRITE ON DIRECTORY TEST_DIR TO myuser
SQL> select * from all_directories;
OWNER DIRECTORY_NAME
------------------------------ ---------------------
DIRECTORY_PATH
----------------------------------------------------
SYS TEST_DIR
c: emp
SYS PUBLIC_DIR
E:PUBLIC_dir
and then
PROCEDURE run_query(p_sql IN VARCHAR2
,p_dir IN VARCHAR2
,p_header_file IN VARCHAR2
,p_data_file IN VARCHAR2 := NULL) IS
[code]...
but I get error wut_118.
I want to transfer data from Oracle form 9i to serial port.
Serial port is connected to electric board to show.
Is there anyway to get a listing of the files in a specified directory on an ftp server using webutil?
View 2 Replies View RelatedI have an Image Type on a forum page. I want a default "not-found" image to display if the BLOB column value is null or if there is no data for that search value. The image is stored with the app: #APP_IMAGES#not-found.png
APEX 4.2 (with listener) on Oracle 11gR2
i use weblogic and forms11g on windows xp
when i run my from in ie8 or google chorom this error apeared:
Quote:
Error 404--not found
from RFC 2068 Hypertext transfer protocol -- HTTP/1.1 :
10.4.5 404 not found
The server has not found anything matching the rewuest-IRI . no indication is given of whether the condition is temporary or permanent.
when i load the form into browser then it gave me the problem that plug in not found. i also installed the j-initiator but still it gives me the same message.
View 2 Replies View RelatedI 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.
when i run my form im immediately im geting geting this error message
oracle.forms.webutil.file.FileFunctions bean not found.CLIENT_TEXT_IO.fopen will not work
when i searched in meta link i found a solution but not know ing how to implement it..
Symptoms When running a customized Webutil Form an error similar with the following is displayed:
oracle.forms.webutil.file.FileFunctions bean not found. CLIENT_TEXT_IO.fopen will not work.
The exact function that "will not work" may change in the error message depending on the WebUtil code used. There are no errors displayed in the Java Console. The original WebUtil Demo Form runs successfully. Cause The WebUtil code that is failing is placed in triggers that are firing before Forms instantiates the WebUtil PJCs.
This is not allowed when using WebUtil and it is explained in the WebUtil User Guide release 1.0.6, section 5.3: "Once the WebUtil library has been attached to your form you can start to add calls to the various PL/SQL APIs defined by the utility. However, there is an important restriction in the use of WebUtil functions: WebUtil can only start to communicate with the client once the Form has instantiated the WebUtil PJCs. This means that you cannot call WebUtil functions before the Forms user interface is rendered.
This would include triggers such as PRE-FORM, WHEN-NEW-FORM-INSTANCE and WHEN-NEW-BLOCK-INSTANCE for the first block in the Form." SolutionDo not use Webutil code in triggers like PRE-FORM, WHEN-NEW-FORM-INSTANCE and WHEN-NEW-BLOCK-INSTANCE because these triggers are firing before Forms instantiates the WebUtil PJCs Instead, you can test the WebUtil functionality with a WHEN-BUTTON-PRESSED trigger and you can use it in your application in other allowed locations.
declare
v_show_documentVARCHAR2 (2000) := '/reports/rwservlet?';
v_connectVARCHAR2 (200) := 'userid=scot/tiger@connect_string';
v_report_serverVARCHAR2 (30) := 'rep_cs-oracle';
-- i make this server name by using this command:C:DevSuiteHome_1BIN
wserver server=rep60 start >>when i started it getting to shutdowing directly!!!!! i don't know why
[code].....
the error is:
before the browser is opened!! an error is occur is that:
javaw.exe -Entry point Not found
the procedure entry point kguuseg could not be located in the dynamic link library oraclient10.dll
then the browser is opened ,this error written in it:
REP-52266: The in-process Reports Server rep_cs-oracle failed to start.org.omg.CORBA.OBJECT_NOT_EXIST: vmcid: SUN minor 204 completed: No
I got this message but i dont no what i can do. I finish setup webutil success but when i try to use it i got this message
oracle.forms.webutil.file.File Functions bean not found. WEBUTIL_FILE.FILE_SELECTION_DIALOG_INT will not work.
I have a problem with finding a node in my tree, but when I click the find button, it threw a message NO DATA FOUND.
here is the code that I used in find button:
DECLARE
tri ITEM;
hanapin_mYnode FTREE.NODE;
BEGIN-- Find the tree itself.
[code]...
I have one query on sql connection.
I have 3 database on windows server. I am using oracle 10g. I want to put the one of the DB in No archive mode, for that I have shutdown the database and then set the ORACLE_SID and try to connect through sqlplus sys/password as sysdba and run the db in mount mode and all the required stuff for put in no archive mode.
but when I set the ORACLE_SID and try to connect through sqlplus it gives me error of TNS protocol adapter error. I run this command through cmd prompt.
I resolved this error by change the directory on cmd prompt to $ORACLE_HOME/bin and then run sqlplus. it works for me but don't get the reason why its not working earlier.
I have toad on my machine and it connects to oracle fine using TNS but when I open sqlplus via start, i gives me a TNS Protocol error ORA-12560. Now, when I open up cmd and login like this: sqlplus user/pass@omp1, it logs in, why doesn't it login via the sqlplus program from start menu though?
Here is my tns file: JUNCORA= (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=105.68.14.82) (PORT=1521) ) (CONNECT_DATA= (SID=orcl) ) ) OMP1= (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=105.1.12.190) (PORT=1521) ) (CONNECT_DATA= (SID=OMP1) ) ) OMP2= (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=105.1.12.193) (PORT=1521) ) (CONNECT_DATA= (SID=OMP2) ) ) here is the listener file: # listener.ora Network Configuration File: C:appRpatelproduct11.2.0client_1NETWORKADMINlistener.ora# Generated by Oracle configuration tools. LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = Rpatel-PC)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) ) ADR_BASE_LISTENER = C:appRpatel
I tried to change to host to OMP1 but that did not work either
My server was down for Some days. Then we brought up the server and started all databases. When i tried to up my listeners i faced the following errors .
$ lsnrctl start CGSLDOC
LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production on 30-SEP-2010 08:26:46
Copyright © 1991, 2007, Oracle. All rights reserved.
Starting /oracle/app/oracle/product/10.2.0/bin/tnslsnr: please wait...
TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production
System parameter file is /oracle/app/oracle/product/10.2.0/network/admin/listener.ora
Log messages written to /oracle/app/oracle/product/10.2.0/network/log/cgsldoc.log
TNS-01151: Missing listener name, CGSLDOC, in LISTENER.ORA
Listener failed to start. See the error message(s) above...
$ lsnrctl start CGSLMTX
LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production on 30-SEP-2010 08:27:24
Copyright © 1991, 2007, Oracle. All rights reserved.
Starting /oracle/app/oracle/product/10.2.0/bin/tnslsnr: please wait...
TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production
System parameter file is /oracle/app/oracle/product/10.2.0/network/admin/listener.ora
Log messages written to /oracle/app/oracle/product/10.2.0/network/log/cgslmtx.log
Error listening on: (ADDRESS=(PROTOCOL=ipc)(PARTIAL=yes)(QUEUESIZE=1))
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=inmaadlfaxdb03.eserve.tcseroot.net)(PO
RT=1528)))
TNS-12557: TNS:protocol adapter not loadable
TNS-12560: TNS:protocol adapter error
TNS-00527: Protocol Adapter not loadable
What protocol is used by RMAN to communicate with the server used for backing up/restoring data? Would it be possible to intercept and modify the calls made by RMAN?
Background: I am developing a proxy that backs up an oracle database to a different store
Is there way implement Kerberos authentication protocol with PLSQL? I am consuming web service with utl_http, which implement only basic authentication and I was able to find implementation with PLSQL for NTLM. So I am wondering if there is a kerberos implementation.
View 0 Replies View RelatedI try to mount the database and login as an administrator to open SQLPLUS I get the following error:
C:\>sqlplus
SQL*PLUS release date.... Oracle. ALL rights reserved.
Enter username: system@oracle10 as sysdba
password:.....
ERROR:
ORA-12560: TNS: protocol adapter error
I did as some forums said: oracle_sid=oracle10 & looked in the listener that the SID is written.I made sure that the oracle.exe is running from services but still i continue to have this error.
I am installing oracle10 10.0.4 in windows server 2008 r2 sp1. while installing it is getting installed and when i start creating the database after accepting the default steps finally . while crating the error i get TNS:protocal adaptor error.
View 3 Replies View RelatedI have oracle forms builder and reports builder 10g installed on my computer. And it is working fine and connected to database properly.
Now I need to work in reports 6i and I installed that without error. I replaced the TNSNames.ora(The same i used for reports 10g) file with my database connections. But When I connect to the database i got the following error.
REP-0501:Unable to connect to the specified database
ORA-12222: TNS : no such protocol adapter
I created a environment variable for TNS_ADMIN in the system variable section as C:Ora10gdsNETWORKADMIN.
But still i am getting the same error while connecting to the database.
Should I not install the 6i while there is reports 10g already exists in my machine?
We installed Oracle 11g on solaris machine but some of the configuration failed.
When verified in tracelog we are finding below error message:
PRCT-1003 : Failed to run "getcrshome" on node "localnode"
at oracle.cluster.deployment.ClusterwareInfo.getConfiguredCRSHome(ClusterwareInfo.java:423)
at oracle.sysman.assistants.util.hasi.HAUtils.getCRSHome(HAUtils.java:546)
at oracle.sysman.assistants.util.hasi.HAUtils.getHASHome(HAUtils.java:606)
at oracle.sysman.assistants.util.hasi.HAUtils.isHASConfigured(HAUtils.java:347)
at oracle.sysman.assistants.dbca.ui.DBCAWizard.<init>(DBCAWizard.java:452)
[code]....
We then tried to create instance but came up with below error:
ORA-12560: TNS Protocol Adapter Error..We have another database version 10.2.0.3 running on the same server and needs to be continued.
I am trying to connect via SQLPLUS to the standalone oracle database i have installed details as follows:
Host DT1089.myname.local
Database emrep.myname.local
Instance emrep
In EM database is up and running OK
Tnsnames is located at C:OracleHomesdb10gNETWORKADMIN
[code]...
I try to log on with command line
C:> sqlplus system/***** @ emrep
**** = password for user system
but get the following error:
ORA-12560 Protocol Adapter error
I'm using Oracle 11. I'm currently having some problem to start my Oracle database after database restore, hence unable to start my SAP application too.
> lsnrctl start
LSNRCTL for HPUX: Version 10.2.0.4.0 - Production on 25-AUG-2010 23:49:20
Copyright © 1991, 2007, Oracle. All rights reserved.
Starting /oracle/PRD/102_64/bin/tnslsnr: please wait...
TNS-12537: TNS:connection closed
TNS-12560: TNS:protocol adapter error
TNS-00507: Connection closed
HPUX Error: 29: Illegal seek
When connecting to Oracle Db as sysdba the following error message occurs.
-bash-3.00$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Sat Nov 27 00:34:55 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> conn sys/sys as sysdba
ERROR:
ORA-12560: TNS:protocol adapter error