Forms :: Data Receive For COM PORT
Jul 3, 2010i want data receive from COM PORT. it's is Possible.Forms 6i and Oracle 8i
View 1 Replies
ADVERTISEMENT
Forms :: Read Data From Serial Port?
Jun 16, 2004I'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.
Forms :: Transfer Data From Oracle 9i To Serial Port?
Feb 14, 2012I want to transfer data from Oracle form 9i to serial port.
Serial port is connected to electric board to show.
Data Guard :: Unable To Receive Result From A Database
Mar 21, 2013standby db /primary db in sync managed recovery working but
broker
show configuration
Connected.
DGMGRL> show configuration
Configuration - GenesisDR
Protection Mode: MaxAvailability
Databases:
orcl - Primary database
Warning: ORA-16629: database reports a different protection level from the protection mode
standby - Physical standby database
Error: ORA-16664: unable to receive the result from a database
Fast-Start Failover: DISABLED
Configuration Status:
ERROR
DGMGRL>
Data Guard :: ORA-16664 / Unable To Receive Result From Database
Oct 17, 2013I decided to configure our current standby databases for administration in EM 12c via the "Manage an existing standby database with Data Guard broker". The first one went off without issue but on the second I got "ORA-16664: unable to receive the result from a database". I've scoured through everything and confirmed, more than once, that the tnsnames, listener and pwfile are all good to go. I can tnsping everything from both servers. The sby1 database is functioning fine and all log files are being transported and applied without issue from primary to standby, on different servers. I can connect via sqlplus to each database from opposite servers. I don't understand how I can do the below in DGMGRL:The listener doesn't not know of service requested (PRI1) and is unreachable in the first connect, but then I can turn around and successfully connect to PRI1 without issue?
DGMGRL> connect sys@sby1Password:Connected.DGMGRL> show configuration; Configuration - PRI1_ora-9002.xxxx Protection Mode: MaxPerformance Databases: PRI1 - Primary database sby1 - Physical standby database Fast-Start Failover: DISABLED Configuration Status:ORA-12514: TNS:listener does not currently know of service requested in connect descriptorORA-16625: cannot reach database "PRI1"DGM-17017: unable to determine configuration status DGMGRL> connect sys@pri1Password:Connected.DGMGRL> show configuration Configuration - PRI1_ora-9002.xxxx Protection Mode: MaxPerformance Databases: PRI1 - Primary database sby1 - Physical standby database Error: ORA-16664: unable to receive the result from a database Fast-Start Failover: DISABLED Configuration Status:ERROR DGMGRL> ;
Listener Port Conversion To Static Port
Mar 2, 2012For 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))
Encrypt Data Through One Port?
Nov 1, 2011I need to encrypt network data for some DBs on one server but not for all of them. How can i achieve this?
Is it possible to encrypt conections on one port and not other?
I know i have to use SQLNET.ENCRYPT_SERVER in the sqlnet.ora file, but how can i do that for only on port?
Forms :: How To Hide Port From Link
May 4, 2010how 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??
Forms :: Finding Out Port Number And Oracle ID For Compilation?
May 21, 2010Is 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?
Forms :: Change Port 1521 In 6i And Oracle Database 8.1.7?
Jun 4, 2011How can we change Port 1521 in forms 6i and oracle database 8.1.7
View 1 Replies View RelatedForms :: FRM-10142 / HTTP Listener Is Not Running At Port 8888
Jul 6, 2005I 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."
Forms :: Communication Form Serial / Parallel Port Via Oracle?
Jun 14, 2005I 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 RelatedSQL & PL/SQL :: Dbms_job.submit How To Receive Output
Jan 2, 2011Discreet use of dbms_job.submit (to call a procedure), can be used to multi thread several instances of same proc in pl sql. I am able to do it.The problem is that dbms_output.put_line of the proc which is multi threaded does not reflects in the outer proc (the proc which parallels this proc and then waits for their completion).How do I receive the output?
View 3 Replies View RelatedSQL & PL/SQL :: Write A Query In Order To Receive A New Table?
Apr 23, 2012i need to write a query in order to receive a new table.
select table_name,col1, null col2
from
(SELECT b.table_name, b.col1 col1, a.CountPrimaryKeys
from
(SELECT user_constraints.table_name,
COUNT(user_cons_columns.column_name) CountPrimaryKeys
[code].......
TimesTen In-Memory :: Unable To Receive XLA Events After A While?
Mar 12, 2013We have been using XLA to capture events on TimesTen for a while now without any issues. We were on TimesTen 7.0.5 and then moved to 11.2.2.3.0 and now 11.2.2.4.0. The XLA processes used Java 6 64 bit and works well with TimesTen versions 11.2.2.4.0 - 64 bit and 11.2.2.3.0 - 64 bit, without any issues.
However, we recently upgraded to Java 7 64 bit both during build time of our XLA processes as well during runtime. The problem we see now is that XLA process upon startup processes events for a while and then after that doesnt receive any events. The process doesn't throw any errors/exceptions. If we restart the XLA process, all the unprocessed events are received and then it behaves normally for a while after which it fails to receive any further events.
Is there any issue with Java 7 64 bit and the TimesTen XLA API? I read the TimesTen 11.2.2.4.0 manual and it says that Java 7 and the ttjdbc7.jar have been certified to work well. Was just wondering if there were any other issues.
In addition, to debug the problem, we ran XLA on a single node and on a two safe setup. The same observations are noted. On Java 6, the process runs just fine capturing all events without any issues, but with Java 7, the issues persist.
In addition, we are only performing updates/inserts on to TimesTen, no delete actions. The OS on which TimesTen's and XLA runs is Red Hat Enterprise Linux Server release 5.7 (Tikanga).
SQL & PL/SQL :: Write A Function That Receive As Parameter A Datatype Varchar2?
Jul 18, 2012here is the situation, I have to write a function that receive as parameter a datatype varchar2 and validate if the letter is less than "A" or greater than "Z", it must print do not correct, or correct depending on the situation, no problem so far, the only problem I've got is: If the symbol is ";" is valid, but i do not know how to write it, It does not depend on the PL/SQl languaje but depends on the logic itself.
DECLARE
v_nombre varchar2(20):='john;%';
vv varchar2(1);
begin
for i in 1..length(v_nombre) loop
[code]...
Queueing :: ORA-24550 - Signal Received Error While Using OAQ Receive
Jul 17, 2012I am trying to read a message from Oracle queue using OCCI.I am getting this run time error:
ORA-24550: signal received: [si_signo=11] [si_errno=0] [si_code=2] [si_int=-389971137] [si_ptr=0x34e8c1833f] [si_addr=0x615db0] Killed.I have checked for the line that is throwing error and found below line causing it:
*messageFromQueue = cons.receive(Message::RAW);
It seems like RECEIVE function is throwing this error: Here is my code:
void Cdatabase::connect(string user, string passwd, string db)
throw (SQLException)
{
env = Environment::createEnvironment(Environment::OBJECT);
conn = env->createConnection (user, passwd, db);
messageFromQueue = new Message(env);
}
[code]....
Precompilers, OCI & OCCI :: Client Don't Receive Notification Upon Successful Registration
Feb 7, 2011I am trying to understand on how ORACLE Continuous Query Notification works. I used the sample code from the ORACLE site:
//download.oracle.com/docs/cd/B28359_01/appdev.111/b28395/oci10new.htm#LNOCI13111
created employees and departments table under my schema.When I executed the sample code. I received an error
"ORA-24912: Listener thread failed. Failed to get IP address of host." that was generated from OCISubscriptionRegister.
Upon setting the client IP address through calling OCIAttrSet, the client can register successfully. I can see the registration entry in USER_ CHANGE_ NOTIFICATION_REGS.
I tried to trigger the notification by updating employee table as recommended. However, the client never received the notification.Is there a way to check if the server created notification and tried to send it out to the client?
Windows :: The Gateway Could Not Receive Timely Response / 1460 / Timeout
Nov 21, 2010i get while getting a report in ASP..
Error like this
Error Code 1460: Timeout
Background: The gateway could not receive a timely response from the website you are trying to access, a DNS server, or another gateway server. This might indicate that the network is congested or that the website is experiencing technical difficulties.
Port Conflict With Dispatchers
Sep 21, 2011We use shared servers for our application connections... when the database starts and randomly grabs a free port number for the dispatchers, we occasionally run into a port conflict - we also have tuxedo and several other processes that start after the database, that have pre-defined ports assigned. So if the dispatcher grabs port 52452 but say the workstation listener is defined to use that same port - once the WSL starts, we have a conflict.
I know we can pre-assign specific ports to the dispatchers; my concern with doing that is that we currently support roughly 150 customers remotely, all using our standard database configuration; many of these have multiple databases per server - in some cases, up to 10-15 databases. So manually managing specific ports on all of these would be tedious, to say the least... especially if some other third party app comes into play that happens to use one of the ports we selected, and we have to change everyone's ports again.
letting Oracle randomly pick a free port within the defined range.
if we add the known ports that are used in applications that start after the databases (the ones we end up in conflict with) to the /etc/services file - will that prevent the dispatchers from using those ports? Does Oracle search the /etc/services file to find used ports, before it assigns new ones out?
All servers are HP-UX, a mix of PA-RISC based and Integrity. Oracle versions are all 10.2.0.3, with a few at 11.2.0.2. Before anyone suggests it, moving away from shared servers is not an option; our application makes new database connects at every query - so thousands of connects / disconnects every hour; the overhead of spawning a new dedicated connection for every one if these is too great, and significantly slows down the application.
Enterprise Manager :: EM Port For Second DB
Jul 2, 2010I have two databases on the same oracle 11g install. The first (ORCL) database uses the default port for EM (1158). However, I don't know what the second one uses. I go to the portlist.ini file, but it only has the entry for the default (ORCL) database.
View 3 Replies View RelatedSQL & PL/SQL :: How To Get Listener Port Through A Query
Sep 18, 2012I'm trying to get listener ports of database through a query. I have a third party tool, which connects to databases and runs select commands and get basic information like status, version, db name etc. I also need to see on which listern port that database is running?
View 1 Replies View RelatedListener Port Number?
Mar 8, 2008I 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 RelatedPort Number For Oracle RAC
Sep 18, 2013I 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 RelatedOracle Port On Localhost Machine?
Oct 14, 2011How to know the oracle port no on localhost machine.
View 1 Replies View RelatedHow To Change Listener Port Number
Sep 16, 2013ENV: 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.
SQL & PL/SQL :: Get Port Number In Database With Query?
Mar 5, 2010How to get a port number in database with a sql query.
View 10 Replies View RelatedBlocking Port 7778 For A Range Of IP
Mar 18, 2013I am using Oracle Application Server 10gAs and Linux 4.
Our Test Application is access by users using 7778 port,i want just few users to access my test application(just admin user) and all other user should not get access to the application,even if they specify proper URL and port number.
Some access control policy using oracle application server 10gas.
Enterprise Manager :: Oracle Port Number
Feb 10, 2012While 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?
Networking And Gateways :: Port Forwarding In Oracle 10g
Sep 8, 2012i 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