Forms :: Finding Out Port Number And Oracle ID For Compilation?

May 21, 2010

Is there any way i could figure out what is the current port number used in an existing setup of oracle forms in a linux server.

Is there any specific oracle id i should use to compile oracle forms on server?

View 5 Replies


ADVERTISEMENT

Port Number For Oracle RAC

Sep 18, 2013

I have a two node RAC setup using SCAN, and I have two databases on it. Can they have the same port number?

View 7 Replies View Related

Enterprise Manager :: Oracle Port Number

Feb 10, 2012

While connecting my oracle with My JDBC driver . i got an SQLException:

public class Orajdbc {
public static void main(String args[])
{
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection
[code]......

i am successfully connected by type 1 odbc driver but while i want to connect it with "ojdbc6.jar" file then i got this exception i already added that jar file to my Environment variable ClASSPATH ..

How to find port number of my Oracle Service?

View 1 Replies View Related

Listener Port Number?

Mar 8, 2008

I have local development Oracle 9i database in my Windows XP. I see it uses TNS Listener port 1521. For some reason it must be using port 8080 also or in the background because it seems to not let my local web container (Apache Tomcat which uses Port 8080) on the same workstation work when it (TNS Listener) is turned on. how I edit the Listener port number and if I do change the port number what other things do I need to change such as the OEM login settings to the local database

View 1 Replies View Related

Forms :: Change Port 1521 In 6i And Oracle Database 8.1.7?

Jun 4, 2011

How can we change Port 1521 in forms 6i and oracle database 8.1.7

View 1 Replies View Related

Forms :: Transfer Data From Oracle 9i To Serial Port?

Feb 14, 2012

I want to transfer data from Oracle form 9i to serial port.

Serial port is connected to electric board to show.

View 2 Replies View Related

How To Change Listener Port Number

Sep 16, 2013

ENV: Oracle 10gR2, RHEL 64bit on ASM (10gR2): 

Current listener port is 1521. I have been asked to change it to 10526

I tried changing the port number in the listener.ora file and then restarting the listener but the I start getting "ORA-12541: TNS: no listener" error. If I change it back to 1521 and restart the listener, I am able to connect to the database. What else do I need to do to change the port #? After I change the port and restart, here is what I tried to test: $ sqlplus user/password@sid...ERROR:ORA-12541: no listener Enter user-name: When I rollback the port# change, I am able to login. 

View 18 Replies View Related

SQL & PL/SQL :: Get Port Number In Database With Query?

Mar 5, 2010

How to get a port number in database with a sql query.

View 10 Replies View Related

Forms :: Communication Form Serial / Parallel Port Via Oracle?

Jun 14, 2005

I want to connect a biometric device with my system, through serial port / parallel port. And want to permit only valid users to the system.

View 18 Replies View Related

Server Administration :: Change Port Number?

Feb 6, 2013

When I created a new oracle database the port number was 1521 (default), but I want to change it to 1522.

View 4 Replies View Related

How To Change Port Number Of Email Alert Notification

Nov 24, 2010

I want to configure the Email Alert Notification in OEM.

In OEM --> Setup --> Notifications Methods --> I am able to see a provision to enter SMTP Address, but there is no port number.

Due to some security policies, my company has opened only Port Number : 9925 for SMTP and blocked Port number : 25.

When I click on "TEST MAIL SERVERS" button, it gives me a error that :

"Test failed with message : Could not connect to SMTP Host , Port No. 25" .

Now I want to change this port number 25 to 9925.

View 5 Replies View Related

Networking And Gateways :: Changing Of Listener Port Number?

Feb 14, 2013

i have a listener configured on default port 1521 and i wanted to change it. i did following:-

1. stop the listener through lsnrctl stop

2.change the port number in tnsnames.ora and listener.ora and save both files.

3.now i start the listener as lsnrctl start

4.it started successfully but saying that it cannot register to instance.

5.i connect sqlplus / as sysdba and execute "Alter system register" and "System Altered"

but even then the listener is not registering.

View 13 Replies View Related

PL/SQL :: Find Database Server IP Address And Port Number

Aug 21, 2012

Is it possible to find the Ip address and Port number of a database server in Oracle 10g version?

actually i wanta to connect it through Putty.

View 7 Replies View Related

Networking And Gateways :: What Is Meaning For Port Number In Listener.ora File

Aug 12, 2013

what is meaning for port number,in listener.ora file associated with ? is there any difference for port number in windows & in linux server.,?

View 3 Replies View Related

SQL & PL/SQL :: Finding Value Of Bits From Hex Number?

Jan 12, 2012

Version : Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

I have a source which is of datatype RAW(1). Basic requirement is to convert it into binary, and then lookup the value of the 4th and 6th bit. Is this possible using simple SQL ?

Eg.

DataBinary
----- -------
EF1110 1111

From this binary output, i need to find the value of 4th and 5th bit.
So if the 4th bit is 1, I need to perform some operations if 0 then some other.

Create table test_hex_to_bin (col1 raw(1));

INSERT into test_hex_to_bin values ('99');
INSERT into test_hex_to_bin values ('EF');
INSERT into test_hex_to_bin values ('AB');

Basically the output should read as

Bit_number Value
----------------
4 1
5 0

View 5 Replies View Related

Networking And Gateways :: Change Default Port Number Of Listener - Instance Registration

Feb 19, 2013

i am trying to chnage the default port number of listener but facing problems in instance registration. i did as follows:

1. stop the listener as lsnrctl stop (default listener).
2. chnage the listener.ora and tnsnames.ora with desire port numbers (1526) as follows:-
[code]
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =

[code]...

but i didnt get the reason of aforsaid error and my instance is not registering

View 5 Replies View Related

SQL & PL/SQL :: Finding Number Of Pattern Occurrences In String?

Feb 4, 2012

The code which I am working on consists of an incoming dynamic string which be in the form of binary digits. The max size of the string will be 12 digits. For example, the string can be '111011000001', '000000000000', '111111011111', etc.

I need to find the number of occurences of '111' in the incoming string. Say in the 1st example, result will be 1, in the 2nd example result will be 0, and in the third example, the result will be 3.

I have been trying to capture the string length and replacing the variables '111' to find the number of occurences, but it isn't giving me the result that I want. This is what I have tried

SQL> conn hr/hr
Connected.
SQL> show user
USER is "HR"

[Code]....

I searched the forum and found a similar topic, and following that guideline, I even tried dividing the string with the length of the pattern. It works in some scenarios (the first and second examples mentioned below), while it fails in some scenarios (third example mentioned below)

SQL> select (length('11101110111') - length(replace('11101110111','111','')))/length('111') as occurences from dual;

OCCURENCES
----------
3

SQL> select (length('110111110111') - length(replace('110111110111','111','')))/length('111') as occurences from dual;

OCCURENCES
----------
2

SQL> select (length('111111111111') - length(replace('111111111111','111','')))/length('111') as occurences from dual;

OCCURENCES
----------

SQL>

View 13 Replies View Related

SQL & PL/SQL :: Finding Record In Table Having Value For Maximum Number Of Columns

Nov 25, 2011

if there is any inbuilt function or way to find a row in the table that is having value for maximum number of columns.

For example, the table A has 5 columns
(c1,c2,c3,c4,c5) and it has 3 records(r1,r2,r3)
and
r1 has values only for c1,c2
r2 has values only for c1,c2,c3,c4
r3 has values only for c1

so I should get the result as "r3 has values for 4 columns & it is not having value for column c5".

View 4 Replies View Related

Listener Port Conversion To Static Port

Mar 2, 2012

For every connection, oracle listener creates a unique dynamic port. Is this can be made static port for all connection? This a query raised in our penetration testing.

Listener log Sample :

02-MAR-2012 17:40:28 * (CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.1.3.12)(PORT=3773))
02-MAR-2012 17:39:31 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=orcl)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.1.1.84)(PORT=38192))

View 2 Replies View Related

Forms :: Error During Compilation - Bad Bind Variable

Jul 28, 2008

I have developed a form based on a database of books. The information displayed during run time is Sr No, Book name,Author, Copies, Description and Image(of the book)

I have written a PL/SQL code to display the image of the respective book for every new record. E.g Book1 should display image1, book2 displays image2 and so on. This should happen at runtime. The code is:

declare
gif_image varchar2(80):='c:ProjectBooks';
photo_filename varchar2(80);
begin
photo_filename := gif_image||lower(:books.sr_no)||'.gif';
[code].......

The error i get during compilation is

Error 49 at Line 5, column 37
bad bind variable 'books.sr_no'

View 4 Replies View Related

Forms :: Data Receive For COM PORT

Jul 3, 2010

i want data receive from COM PORT. it's is Possible.Forms 6i and Oracle 8i

View 1 Replies View Related

Forms :: How To Hide Port From Link

May 4, 2010

how to to hide the port number from the linkof my oracle web application???I call my application through a url like:[URL]...

how can I customize this url??

View 1 Replies View Related

Forms :: Data Block Based On Procedure - Getting Compilation Error

Mar 13, 2013

I am trying to create a datablock based on a procedure , but im getting errors in compilation:

Errors are :
1) identifier 'HSM_WSH_DEL_UTIL.DEL_TBL' must be declared

2) PL/SQL ERROR 320 at line 7, column 27 the declaration of the type of this expression is incomplete or malformed

Heres my pkg spec and body for the data block:

CREATE OR REPLACE PACKAGE hsm_wsh_del_util
IS
TYPE del_record IS RECORD (delivery_id NUMBER);
TYPE del_tbl IS TABLE OF del_record
INDEX BY BINARY_INTEGER;

PROCEDURE do_query (p_del IN OUT del_tbl);
END hsm_wsh_del_util;
[Code] .....

View 1 Replies View Related

Forms :: Getting Error At Compilation Time / To Insert Images Into Table

Oct 3, 2011

I am getting error at compilation time. I want to insert images into table. The code is

declare
f_lob bfile;
b_lob blob;
begin
INSERT INTO imag VALUES(empty_blob())
return img INTO b_lob;
f_lob := bfilename( 'PIC', 'DESERT.JPG' );
dbms_lob.fileopen(f_lob, dbms_lob.file_readonly);
dbms_lob.loadfromfile( b_lob, f_lob, dbms_lob.getlength(f_lob) );
dbms_lob.fileclose(f_lob);
end;

errors are
[code]

View 1 Replies View Related

SQL & PL/SQL :: Create Oracle Objects (Views) Using Conditional Compilation?

Jun 6, 2011

it is possible to create Oracle objects(Views) using Conditional compilation?

View 5 Replies View Related

Forms :: Read Data From Serial Port?

Jun 16, 2004

I'm trying to read some data from external device via COMM Port.

Application is running n server and device is connected localy on my PC.

My device iz DPI605R for purpose of� pressure measuring.

View 6 Replies View Related

Oracle Port On Localhost Machine?

Oct 14, 2011

How to know the oracle port no on localhost machine.

View 1 Replies View Related

Networking And Gateways :: Port Forwarding In Oracle 10g

Sep 8, 2012

i want to online my oracle 10g database but when i make connection string then i don't know what the port i set. I set default port 1521 but it not work on client site .

View 4 Replies View Related

Forms :: FRM-10142 / HTTP Listener Is Not Running At Port 8888

Jul 6, 2005

I am still facing the following error even though i have started the OC4j instance,

"FRM-10142: The HTTP Listener is not running on <computernam> at port 8888.start the listener or check your runtime preferences."

View 24 Replies View Related

Networking And Gateways :: Oracle Tomcat Conflict Port 8080?

Apr 29, 2010

I have a problem: Oracle is working on port 8080 used by tomcat. Then two applications are conflicting.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved