Opening Of Port 1521 For Database Connectivity Through Firewall?
Nov 8, 2012
we have a database available in UNIX machine A which can be connected from client in UNIX machine B through port 1521.
If we give ping command from UNIX machine A to B or B to A, 0% packet loss, means connection established properly through firewall in port 1521.
Now we are setup one more UNIX machine C and installed a client here. This machine is available in different group, means if i give ping command from machine C to A, 100% packet loss. But from machine A to C, connection established with 0% packet loss.Because of this, when we tried to connect to a database from client in Machine C to database in Machine A, we got "time out" error.
My query is:
1. Is this because of not opening of port 1521 through firewall?
2. If so, is it enough to open port 1521 through firewall when we connect from machine C to A?
3. Any additional setup is required in firewall apart from opening of ports?
How to enable firewall for Oracle Database..? Is it db specific..? or If I implement the firewall It will be applicable to all the databases in the server which are using same oracle home..?
I'm new to Oracle. I took cold backup of my database. Then, i removed my whole database while database was down.Then i restored the whole database from backup taken earlier. Now, when i try to open the database. it does not open up instead gives the below message.
Total System Global Area 1288949760 bytes Fixed Size 1336288 bytes Variable Size 754977824 bytes [code]....
I would like to develop a system with Oracle 9i as the database and PHP 4/5 as the front end. I am not able to establish the connectivity to the database. What should I do now ?
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.
I was surprised when I shutdown our production dB. I got this error:
$ . oraenv ORACLE_SID = [abcd] ? SQL> shutdown ORA-01116: error in opening database file 26 ORA-01110: data file 26: '/VOL03/oradata/qxyz/data/qxyz_data01.dbf' ORA-27041: unable to open file SVR4 Error: 2: No such file or directory Additional information: 3 SQL> shutdown abort ORACLE instance shut down.
2 days ago i rename this file QXYZ_DATA01.dbf from it's original name of QXYZ01.dbf without knowing that I was in the 'abcd' instance. When I backup a controlfile I noticed that it was part of the 'abcd' data files, so I just delete it (from OS level).
Is there any risk involved in the 'abcd' instance? How do I get rid of that file 'qxyz_data01.dbf' in the 'abcd' instance.
need to know how to connect remote database (ie my office oracle database) from my personal laptop. Using TOAD Software. me with the step by step procedure, and what software's I have to download.
I am having a application which is on Widows NT Operating system.I am using Oracle 10g Database, Developer suite 10g And 10g Application server.
My application uses Run_report_object to generate reports.Run_Report_Object is called in forms and Report server is configured in the same Application server where FMX are placed.
The report generation was working fine as long as oracle default login was used. When i created a form to handle login on my own, Report server is throwing "Unable to connect to database" error. My login forms takes the parameters from user and calls default logon command in on_Logon trigger.
I have installed unixodbc 2.3.1, postgres odbc driver (psqlodbc-07.03) and dg4odbc 11.2..On querying : select sysdate from dual@dblink_postgresql, the following error occurs:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message: [unixODBC][Driver Manager]Can't open lib '/oracle/psqlodbc/lib/libpsqlodbc.a' : file not found {01000} ORA-02063: preceding 2 lines from DBLINK_POSTGRES
Similar error appears in the trace file as well.
[unixODBC][Driver Manager]Can't open lib '/oracle/psqlodbc/lib/libpsqlodbc.a' $ isql -v postgresql postgres postgres@2012 [01000][unixODBC][Driver Manager]Can't open lib '/oracle/psqlodbc/lib/libpsqlodbc.a' : file not found [ISQL]ERROR: Could not SQLConnect
However the file is present in the location and has no permission related problems.
$ pwd /oracle/psqlodbc/lib $ ls -lrt total 2952 -rwxr-xr-x 1 oracle oinstall 663 Mar 25 15:28 psqlodbc.la -rw-r--r-- 1 oracle oinstall 731419 Mar 25 15:28 libpsqlodbc.a -rw-r--r-- 1 oracle oinstall 12215 Mar 25 22:11 win_md5.o -rw-r--r-- 1 oracle oinstall 18100 Mar 25 22:11 options.o [code]....
I am using oracle 11g express edition and MY Sql database How to establish database link between them using ODBC gateway. I am using ODBC gateway Mysqlodbc connector.
I have two machines with oracle 11g . Both having ODP 11.2 Beta. I've to communicate between these two machines using Oracle Advanced queuing. The message sent from one machine will reach the second machine only if the Firewall of both machine is OFF.But based on requirement, we cannot switch OFF firewall or add exceptions as ports or applications.
We have a problem while opening PDF through oracle forms, we are getting the folowing error in some PC's, but some PC's this is working fine.'there was a problem reading this document 14'.
What are the steps required to change an ORACLE stored procedure (on a AIX/UNIX machine) using OTG to connect to a DB2 database, to an ORACLE stored procedure that uses ODBC or JDBC connectivity?
All I need to do in the stored procedure is a simple insert statement into a DB2 table.
What kind of ODBC/JDBC driver do I need on the UNIX machine? unixODBC?
What would be different in the ORACLE stored procedure for it to use ODBC connectivity rather than OTG.
un-documented parameter _trace_files_public / I want to set this to true so my app team can review trace files. better way to proceed to open read permissions for non oracle users.
When I click on 'Run Form', the Applet is not opening in Internet Explorer.
Giving Error like " Internet Explorer has encountered a problem and needs to close. We are sorry for the inconvenience." Even I have re-installed the oracle 10g the same problem is coming.
Note: When I remove jinitiator and then reinstall jinitiator the applet is opening once and again if I run the form second time the same above error is coming.
There is a existing form B. From a form A I need to call form B on button press. Problem is form B has many tabs,It should open in the third tab when it is being opened from form A.
I have a multiple forms application and I use OPEN_FORM to call one form from another. However I want the new form to open in a separate tab ( the way it works in a tabbed canvas).
I have developed a new form.Something peculiar is happening for that form.Let me list down the scenario
1)In the data base for the particular table my form is using, there are 1600 records.When i do a Query on Count Hits in the forms,it gives the same number.
2)However when i open the form ,i do not get some of the records.I found that on opening the form and making an Execute Query only those records that i have added through forms exist.
3) However,when i try to add a new record and do an Execute query again,i get all the records present in the database.
We have cloned the db and after opening the db with resetlog option we came to know that one of the user db file is not part of the db and is showing the below error while checking the status and attempting to online it. When checking the size and availability of the dbfile it shows everything without errors.
SQL> alter database datafile 50 online; alter database datafile 50 online * ERROR at line 1: ORA-01122: database file 50 failed verification check ORA-01110: data file 50: '+DATA/orcl/orcldata.291.730828357.dbf' ORA-01251: Unknown File Header Version read for file number 50
