I have just installed Oracle Forms 11g with the Weblogic web server. I have a local installed database, and access to our network databases also.
I can do a TNSPING and get valid results back from that. I can connect with SQL Plus, and SQL Devloper. However, I cannot connect with the Forms 11g Forms Builder. where to copy the TNSNAMES.ORA file for use with Forms 11g?
Our database is on one site . There is a form which is used by users on another site. The internet connection is lost sometimes and the form that they use looses connection to the database. What I would like to do on the form is whenever the connection is lost to the database i,eORA-03114,I want to reestablish the connection so that the form can be used by users all the time.
View 1 Replies View RelatedI´m just having a problem whit the connection between Oracle Forms 6i and Oracle Database 11G. Is just when i login to the database schema i cant log in using Forms.
TNS Names its already configured, No problems when i log in using Toad and using the TNS Names from Developer's 6i tool. I can log in just when i change the schema(user) password from the database (thats the rarest thing) and log into the application.
So whenever i want to login to the application i must to change the schema password, i need to use it directly.
Toady i have installed oracle forms 10g and oracle 10g db when i run my form it gives me this error how can i resolve it
"ora-12154 tns could not resolve the connect identifier specified"
View the image below:
Here are the values in forms 10g tns
# tnsnames.ora Network Configuration File: C:DevSuiteHome_1
etworkadmin nsnames.ora
# Generated by Oracle configuration tools.
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
[code].......
and here the values of forms 10g SQLnet
# sqlnet.ora Network Configuration File: C:DevSuiteHome_1
etworkadminsqlnet.ora
# Generated by Oracle configuration tools.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES, EZCONNECT, ONAMES, HOSTNAME)
(description =
# (address=(protocol=tcp)(host=localhost)(port=1383))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(connect_data=(rpc=on))
)
What changes should i make to overcome this problem.
Am running forms 10g on windows vista service pack 1 and am having problems with the FRM-40514 error. (Operation requires a database connection).
I can connect quite alright from form builder, but when i run a form it request for login credentials again. I dont understand why this is so, when am already logged on in form builder.I tried to tacke this by creating the following
DECLARE
Uname VARCHAR2(80);
Pword VARCHAR2(80);
cn VARCHAR2(80);
BEGIN
--pause;
--logout;
--message ('Logging out');
--synchronize;
[code]....
This code suppreses the logon screen and runs the form without logging on to the database. I know this because when I try to enter and execute query it brings up the message: FRM-40514: Operation requires a database connection.
I have an issue with an Oracle 9 database where I can connect if I do not specify a database to connect to but when i do specify one i get an error. For example, my database is called WEB. If i open sqlplus and type connect username/password it will connect fine. If I type connect username/ password @web I get an error.The full error that appears in the log is:
TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12546: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00516: Permission denied
32-bit Windows Error: 5: Input/output error
I have checked the tns entries and listener file and both are fine. Here are the entries:
TNSNAMES:
WEB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = web)
)
)
[code]....
I have 3 questions.
I have 11.2.0.1 database on Windows 2008 R2 SP1.
1) While connecting to the database as sysdba (sqlplus "/as sysdba"), it takes about 12 to 15 seconds what things I need to check/change so that connection will be faster?
2) Also, I have read somewhere that changing the sga/memory parameters connecting to the database. is it true?
3) This is not concerned with above 2 questions. What should be the memory parameters size for a 8 gb database?
What I have is:
Total System Global Area 1068937216 bytes
Fixed Size 2182592 bytes
Variable Size 1027605056 bytes
Database Buffers 33554432 bytes
Redo Buffers 5595136 bytes
The problem i mentioned in my last posting "CRS installation/PRIF-10: failed to initialize the cluster registry" was due to the fact i was using Redhat Linux 9 that seems to have some missing packages. I installed White Box RH 3 and everything worked fine.
if it's possible to connect to a 10g RAC database using the jdbc java thin client. the java thin client requires an ip, and database sid. I am running a two node cluster and i have two ip's and a service name that uses TAF option.
I am gettting error message databse connection closed itried
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
[code]...
I have a problem running forms 11g OS is windows 7 (tried on both 32bit and 64 bit same error)..Forms and Reports were both working fine, i was able to run test form, and a form that i created, and both were running properly. suddenly, while testing a new form module, it didn't work, and its showing :
Failure of server APACHE bridge:
------------------------------------------------------------------------------
No backend server available for connection: timed out after 10 seconds or idempotent set to OFF.
Just installed the new 2.0.8 version. Its been a while I am interested on using PM for our company.The problem I have is creating an Oracle DB connection. When I create a new Oracle DB connection, and test it, Steps 3 and 4 fail.What is strange is that I followed the following procedure in PM 1.9-825 and worked fine. I am wondering if something changed in the new PM 2.0.8 version (I noticed that php_oci8.dll was commented out in php.ini).
Oracle Version is 10GR2
PM installed on clean XP sp3
1. Got a new Windows XP SP3 PC
2. Installed PM 2.0.8
3. Edited php.ini and uncommented [PHP_OCI8] and extension=php_oci8.dll
4. Installed oracle instant client “instantclient-basic-win32-10.2.0.5” in c:oracle
5. Installed oracle instant client “instantclient-sqlplus-win32-10.2.0.4” in c:oracle
6. Added c:oracle in PATH environment variable
7. Created ORACLE_HOME = c:oracle environment variable
8. Added TNS_ADMIN = c: environment variable
9. Copied working tnsnames.ora file into c:
10. Rebooted.
-------------------------------------
1. Tried sqlplus connection to my oracle db and worked.
2. Launched PM
3. Created a new process
4. Created a new DB connection as follows:
a. Engine:Oracle
b. Server:192.168.xxx.xxx
c. Database name: my_name (where my_name appears in tns_names.ora)
d. Username:my_username
e. Password:my_password
[code]....
Is there any way, in Oracle where I can find out if there is any process from some machine which has been successfully connected database ?
View 5 Replies View RelatedI'm getting the error messaage:
Database Connection failure. Reason: java.sql.SQLException: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist SVR4 Error: 2: No such file or directory
I'm not an Oracle expert, but I have research a little and seems that the SID could be wrong or that the DB is down, in fact I have already checked trhe server but everything seems normal to me.
While after connecting to server via my userid( its an externally id) ,after setting ORACLE_HOME and SID, while entering sqlplus / command,its not connecting.Error am getting is:-
ERROR:
ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
HP-UX Error: 22: Invalid argument
Attaching output session.
I have one query related to database connection from server to client.I have one database in the server and I want to connect from client.I set the tnsnames in client system as follows.
BAM240T_EARTH =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = tcp)(HOST = 10.154.119.103)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = BAM_240T.ipdc.com)
)
)
The database name is : BAM_240T.ipdc.com
Sqlnet.ora entry is
NAMES.DIRECTORY_PATH= (TNSNAMES)
NAMES.DEFAULT_DOMAIN= ipdc.com
When I connect to server I m getting the following error.
$ tnsping BA240T_EARTH
TNS Ping Utility for Linux: Version 10.2.0.4.0 - Production on 15-JUL-2010 15:45:35
Copyright (c) 1997, 2007, Oracle. All rights reserved.
Used parameter files:
/opt/oracle/product/10.2.0/db/network/admin/sqlnet.ora
TNS-03505: Failed to resolve name
when i am connecting to my database in command prompt,sql * plus editor is it successfully connecting to the database but not connecting with the oracle client OEM.
but after connecting the LAN it is not connecting and also in the case when i am connecting to the internet through the USB datacard it is not connecting with the oracle client OEM.
how can i connect to database when the LAN,USB datacard connection.
I have created ".sql" script in Unix and I am trying to execute the script at SQL prompt. But I am getting the following error message after getting the output.
ORA-02019: connection description for remote database not found
Disconnected from Oracle Database 10g Enterprise Edition
Release 10.2.0.3.0 - 64bit Production With the Partitioning, OLAP and Data Mining options
[URL]... says that session memory is maintained in the PGA (unlike shared server) and then gives a calculation for memory usage that I don't understand: it suggests that instead of there being one PGA per session, there is one PGA per pooled server plus a small allocation of 35k per session, but this is not what I see.
It's easy to demonstrate. As sys,
exec dbms_connection_pool.start_pool
and then launch any number of session with
sqlplus scott/tiger@127.0.0.1:1521/orcl:POOLED
and you'll see a process called Lnnn launched for each session:
[code]...
There is a mention of a process called the connection broker, but I can't see this in v$process.There is more detail in the OCI developers guide [URL]... which goes beyond my knowledge of application development.
I am using oracle 10.2.0.3 in AIX
From client machine , i m not able to connect, it raise error
sqlplus t24/t24@pbldr
SQL*Plus: Release 10.2.0.1.0 - Production on Sun Sep 23 16:21:46 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-03135: connection lost contact
Note : after restart the listener only one time I can able to login to database next time raise above error.
I want to audit user connection on my reporting database, and send a report to application team on monthly basis, with a list of users who are not connected for a month and remove them.
What would be best method, i know there is LOGON trigger, or database level auditing.
I am having problem with my tnsnames.ora file.seems the file cannot handle connection information for more than one DB. It worked fine in the beginning, after that, whenever i had to connect to a DB, i had to keep switching and renaming 5 files, with respect to whichever database I want to connect to. this is the entries in the file, for 2 D's and it wont work, with just one in each it works, but not for two...
newtpt =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp)
(PROTOCOL = TCP)
(HOST = ipadd/virtualname)
(PORT = 1521)
[code]....
I am sure, nothing wrong with teh IP/virtualname, cause with just one of these in the file, they work excellent.I tried leaving line between the connection strings for each DB, without leavin lines, etc..
Unable to connect to database getting below error
sqlplus sys/oracle@server_name/orcl
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Apr 12 11:07:15 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-12518: TNS:listener could not hand off client connection
Below is alertlog entry
Completed: alter database open
Thu Apr 04 17:06:19 2013
db_recovery_file_dest_size of 4096 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
[code]...
setup the connection between oracle developer and database.
i found the file called tnsnames.ora however, i cant open it. i dont know if i need to choose a program to open it or download extension for it.
My production database server is cloned for test environnement . I kept the same name of SID for both environnement but on different hosts.
I got error when try to connect to test database : TNS:protocol adapter error.
Below the the TNSNAMES.ORA files:
----- production host ---
HOFL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = asus-sol)(PORT = 1521))
[Code].....
In the recent past we have been observing the DB connection from application to database using ODBC is taking long time. When I fire LSNRCTL SERVICE command, for our instance the ESTABLISHED = count is being shown a huge number like 45000 and even more some times.
When we restart the instance suing shutdown immediate or abort commands. The established connections count is becoming 0 and again getting increased slowly. Once the count is reduced the connections are getting established quickly without any issue.
I am using oracle 11g client library on Linux 64bit machine and trying to connect to oracle database using jdbc thin driver.The url format what I am trying to use is:
jdbc:oracle:thin:@IP address:port:service_nameWhen service_name = orcl :
I am able to connect with the above syntax. But when the service_name is having . e.g service_name = orcl.177.39.45, with the above format I get the above error.
If I change the URL syntax to following, it works
jdbc:oracle:thin:@IP address:port/service_name
But both seems to be valid syntax.So I would like to undestand the reason behind the same. When service_name is having ".", why ":" does not work and "/" works and when the service_name is without " ." , 1st format works. Is there any specific reason behind same?
Suppose my oracle database server IP is 128.1.1.100 in the office & the internet static IP is 115.118.33.100 is on that server. I want to retrieve the data by using oracle forms & report from my home's computer having different internet IP 115.118.33.25 on my home's computer.
what would be the settings on my home's computer for the same. i mean tnsname.ora file or any other setting.
I created database link from bala1 database of bala user with the following command.
CREATE DATABASE LINK maddy CONNECT TO P10 IDENTIFIED BY secret554
USING 'MADDY.WORLD';
my aim is to create a dblink to access 'maddy' database objects from bala1 database.
I gave select * from v$database@MADDY.WORLD in bala user and it throwed error.
ORA-02019: connection description for remote database not found
I Installed Oracle forms 10g after which I Installed Oracle Database Express Edition.
I have added the following entry in tnsnames
XEXDB=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=8080))
(CONNECT_DATA=
(SERVICE_NAME=XEXDB)
)
)
When I am trying to connect Forms with the Database am getting the below error:ORA - 12537: TNS connection closed
I need to make any changes to sqlnet.ora
1> I installed "Microsoft Visual Studio Express 2012 for Web[32 Bit]" on Win-7[64 Bit] platform.
2> Then installed Oracle Database 11gR2 [64 Bit]
What else do i need to install, in order to Add a new database connection through Visual Studio 2012's Database Explorer.