Server Administration :: Oracle Hang - Client Cannot Connect Database
Apr 29, 2012
all of the client cann't connect the db,and using sqlplus / as sysdba also cann't login there are many error of TNS-12535 and in the listener.log
alert.log:
Sun Apr 29 18:10:36 2012
opidcl aborting process unknown ospid (42992060) as a result of ORA-604
Sun Apr 29 18:10:54 2012
opidcl aborting process unknown ospid (26280196) as a result of ORA-604
[code]...
View 5 Replies
ADVERTISEMENT
Jun 29, 2013
I'm trying to connect a oracle client application on the client machine to a remote oracle server on the server machine but i get a connection fail.
On the server machine I configured oracle server in the following way:
Installed oracle server. Created a database "DB_Test" with the database configuration assistant Created a LISTNER with the Oracle NET Manager with the following parameter:
Protocol: TCP/IP HOST: server pc hostname (ENZOVAIO) or server machine address ip (192.168.0.71) in the network lan Port Number: 1521 Created "dbtest" service with the Oracle NET Manager with with the following parameter:
Service Name: "dbtest" Protocol: TCP/IP HOST: server pc hostname (ENZOVAIO) or server machine address ip (192.168.0.71) in the network lan Port Number: 1521
All services on the server machine are running and I opened port number (1521) in the router. On the client machine I installed SQL PLUS and SQL Developer.
With SQL Plus as by the official documentation I have entered the following command:
CONNECT username/password@[//]host[:port][/service_name]. In my case is:
CONNECT SYSTEM/oracledb@//ENZOVAIO:1521/testdb.
With SQL Developer I have entered the same parameter.
But with both SQLPlus and SQL Developer the connection fails.
View 14 Replies
View Related
Aug 10, 2010
we have oracle server. we have to connect 500+ client machine to oracle server.
is it i need to install client version to all 500+ or any other shortcut way?
View 6 Replies
View Related
Jan 26, 2010
My server RAM is 12GB. i installed 10gr2 and implemented /3GB also. Eventhough my database is giving problem.
View 20 Replies
View Related
Dec 11, 2012
I have new virtual UNIX machine and I installed oracle client on /usr/lib/oracle. Also I have a oracle database and I am able to connect to this database from my desktop sql developer.
So now I am trying to connect from new UNIX machine. Where I created tnsnames.ora file under /usr/lib/oracle/network/admin and before connecting did export the following
export TNS_ADMIN=/usr/lib/oracle/network/admin
export ORACLE_HOME=/usr/lib/oracle/
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$PATH:$HOME/bin:/sbin:$ORACLE_HOME/bin
export ORACLE_SID=VFIODSD1
when I try
# sqlplus
username :xxxxxxx
password : xxxxxxx
ORA-12545: Connect failed because target host or object does not exist. Not sure what I missed here. using same tns file I am able to connect from sql developer on windows.
View 1 Replies
View Related
Feb 13, 2013
I am trying to find the unix process for one of my application in the database but I am unable to view the same. To simulate, I did the following.
1. My database runs on different server.
2. I invoked "sqlplus" from another unix box to login to the database.
3. I found that the process id (ps -ef |grep sqlplus).
4. When I execute the below mentioned query it does not display the process id that I am looking for. But the osuser, username, program and machine details are correct. How can I know the process details from the database?
SELECT SYS.GV_$SESSION.OSUSER, SYS.GV_$SESSION.USERNAME, SYS.GV_$PROCESS.SPID,
SYS.GV_$SESSION.MACHINE, SYS.GV_$SESSION.PROGRAM,
SYS.GV_$PROCESS.PROGRAM ,SYS.GV_$SESSION.SQL_ID
FROM
SYS.GV_$PROCESS, SYS.GV_$SESSION
WHERE
SYS.GV_$PROCESS.ADDR=SYS.GV_$SESSION.PADDR and SYS.GV_$SESSION.USERNAME='TEST'
and SYS.GV_$SESSION.MACHINE like '%hostname%'
View 3 Replies
View Related
Mar 14, 2012
We a running oracle9i database and forms 6i application.
We have 4 gb ram size and sized the sga for 700mb pga for 400mb for past 4 months there is no problem.
Now from last week we encounter the server hang, and we do restart. How to check reason for hanging.what are all the check list to carried out.
View 19 Replies
View Related
Apr 18, 2008
Is it possible to connect to 10g oracle server from 9i client?
View 1 Replies
View Related
Sep 29, 2011
I recompile a package in a session,and found the session is hang, I know there are have others session run the package,how can i find what session run by the package?
View 2 Replies
View Related
Aug 5, 2011
when i modify a column of table tb_hxl_user,just as flowing:
Alter Table TB_HXL_USER Modify CREATE_DATE Not Null
now i select the table TB_HXL_USER,just as flowing:
select * from TB_HXL_USER;
it is hang,and i found the wait event is library cache lock in v$session_waits,why?how can i avoid this.
View 8 Replies
View Related
Nov 27, 2010
I have installed a database in D drive. I want to create another database in the same machine. I tried installing the new database using DBCA. Installation was ok. I added entry in TNS file.
When i try to login to this new database from other machine, i am unable to connect to this database. I made an entry in TNS on my local machine. It says the user id /password is wrong, even though they r correct. I am using the same password to delete the database.
View 3 Replies
View Related
Sep 26, 2013
I migrated one database ( DB1) from old database server to new database server where user accounts were locked before migrating the database.But migration was successful and database and accounts got created in new database server.
In old database server , user accounts status is locked and in new database server user accounts are open but still i am unable to connect to database using new user in new database server.
why im unable to connect to database whose accounts are open?
View 6 Replies
View Related
Oct 19, 2012
last two years i am using oracle 9i in windows 2003 server but now i installed oracle 10g on another server (PC) , i want to connect 9i to 10g with same database and user .
View 3 Replies
View Related
Nov 28, 2011
Since 13.00 hours, my clients can't connect to the database, and hence cannot access their application.
They get a ORA-12560 error. protocol adapter.
What I have discovered and done so far.
1. I can tnsping dbname -> OK.
2. I have rebooted both application server and databaseserver multiple times
3. I haven't touched tnsnames.ora, sqlnet.ora and listener.ora and they look to be in perfect mint condition.
4. I have full access to access the database instance via web.
5. I can connect to the database instance via sql
6. I have restarted the oracle-services: oracleDBConsoledbname, OracleOraDb20g_home1TNSListener and OracleServicedbname
7. I have rebooted the client computers, and the file server.
8. I don't see any errors in event logs, both on file server, client computer and database-server.
9. When I press down the link Listener, I get Metric Collection Error, which means I might not access it?
10. The only alert I find is that filesystem D: only has 15.62% available space.
They have been using the database for a very long time without any trouble, and suddenly boom.What do I do? How do I check things?
View 22 Replies
View Related
Jan 16, 2012
i create new database (Student) using command line, now i want to connect with newly created database (using sys as sysdba), but again it directly connected with old database (ORCL). So what should i do to connect with newly created database (Student).
View 3 Replies
View Related
Aug 17, 2010
I have installed oracle developer 6i. in sqlplus i want to put my username and password but nothing in the connect string field.
View 1 Replies
View Related
Feb 7, 2013
In one machine I have windows xp with Oracle 11.2.0.2 database installed and I am able to connect to the database using both sql developer and sql plus.
In another machine I have windows 7. I installed Oracle client 11.2.0.1, then using Net configuration tool, I installed both listener.ora and tnsnames.ora files.
Now, I want to connect to the database which is installed on windows xp from windows 7 using the oracle client. When I tried to connect, I got the following error :
ERROR:ORA-12560: TNS:protocol adapter error
In order to rectify the above error, I was making sure that ORACLE_HOME AND ORACLE_SID were properly set in the regedit file (under HKEY_LOCAL_MACHINE > SOFTWARE > ORACLE). The ORACLE_HOME was set properly. But I found ORACLE_SID missing. So I added ORACLE_SID environment variable in the registry and re-tried connecting to the database. But I am not able to connect. What else should I do in order to connect?
View 6 Replies
View Related
Apr 21, 2011
We are unable to connect to Oracle 11.1.0.7.0 from Oracle Forms 4.5..However we are able to connect using Oracle forms 6i
Now Forms 4.5 is old and not supported, however apart from Tests I will need prove it to the higher ups...Do we have any link, document which will cover such compatibility issue?
View 7 Replies
View Related
Jan 13, 2011
can we use oracle client version to create a database in that server.
View 3 Replies
View Related
Feb 21, 2013
The problem is that this connection errors when I try to connect using my SQuirreL client. My developers want to connecting using the SID or the SERVICE_NAME and by using the "New Method" syntax, not the "Old Method" syntax. According to the documentation the "New Method" syntax works with the SERVICE_NAME or the SID. The "Old Method" only works with the SID.
# Host name is vmwwin7634.na.SAS.com
# SID is sting2
# SERVICE_NAME is sting2.na.sas.com
PROBLEM using SID errors ==> jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521/sting2
THIS WORKS using SERVICE_NAME ==> jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521/sting2.na.sas.com
I am using SQuirreL Client version 3.4.0
# Here is the tnsnames.ora entry on the server.
STING2 =
(DESCRIPTION =
[code]...
# In this documentation it says, "On new syntax SERVICE may be a oracle service name or a SID."You can find this on the orafax wiki under JDBC#Thin_driver.
# I was able to connect with the "old method" using the SID only, SERVICE_NAME errors jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521:sting2.na.sas.com
(SQuirreL client error, "Unexpected Error occurred attempting to open an SQL connection.")
jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521:sting2 (this works)
# "New Method"
jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521/sting2.na.sas.com (this works)
jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521/sting2 (this errors)
(SQuirreL client error, "Unexpected Error occurred attempting to open an SQL connection.")
View 10 Replies
View Related
Apr 12, 2013
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]...
View 6 Replies
View Related
Jul 17, 2013
Does a 10g oracle client works with an Oracle 11g server?
View 1 Replies
View Related
Dec 15, 2011
I have Oracle 7 database on Server1. I need to connect this using Oracle client from windows XP.
I have downloaded Oracle client 3.0 and when I am trying to connect it saying "Unable to connect: Unsupported Oracle version".
View 8 Replies
View Related
Jul 25, 2012
I am trying to install Oracle client 11G software in AIX box. In /home/oracle, I find 7 profile files. I am not sure which profile file I am supposed to consider.
View 1 Replies
View Related
Oct 6, 2010
I have the following computer/setup:
Acer laptop, Intel Processor w/ Windows 7 Professional (64-bit)
Delphi 2010 Professional
Oracle XE (+ the Oracle XE client that comes with it)
I cannot can't to the Oracle database from Delphi. The error I keep getting is:
Alias is not currently opened. [Oracle][ODBC][Ora]ORA-12154:TNS: could not resolve the connet identifier specified.
Here's what I've done:
1. Create an ODBC connection to my Oracle database
- run C:WindowsSysWOW64odbcad32.exe to open the ODBC administrator.
- Data source name: bt_user
- TNS Server Name: localhost/xe
- user bt_user
- Clicked "test connection" -- Success.
2. Open Delphi and drop a TDatabase component on my main form.
- Set the Alias Name property to "bt_user" (the alias I set up in ODBC)
- Set database name to "bt_user".
- Checked "connected".
Alternatively, I tried using the Delphi ADO components (the dbGo components).
- Drop TADOConnection component on my form.
- Select "connection string" and open the dialog.
- Click "build string".
- Select "Microsoft OLE DB Provider for ODBC Drivers" from the selection.
- In "use data source", select "bt_user" from the drop-down list (my ODBC connection from #1)
- Click "test connection".
Again the same error.
My questions are:
1. Can Delphi work with Oracle XE (Express Edition)?
2. If so, then do I need to install the "Instant Client"?
3. Will the instant client for Oracle 10g work with Oracle 10g XE?
4. Do I need to install any additional ODBC driver(s)?
5. Why was I successful in creating the ODBC connection in Windows, but it failed in Delphi?
6. Will Visual Studio.NET (C#) work with Oracle XE, and what are the steps for setting that up?
View 2 Replies
View Related
Oct 4, 2013
I am getting error in my database....
SQL> conn scott/tiger;
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
I tried shutdown and startup
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Oct 4 22:31:06 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> connect /as sysdba
Connected.
SQL> shutdown;
ORA-01507: database not mounted
[code]....
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only
SQL>
View 1 Replies
View Related
Jun 24, 2013
How I can connect database on unix OS and windows what is the deference.
View 7 Replies
View Related
Jul 17, 2012
can connect a 64 bit Oracle 11g Release 2 on a Windows 7 client with a 32 bit Oracle 11g Release 2 on a Windows 2008 server?
View 5 Replies
View Related
Jul 22, 2011
Currently I am doing one Oracle installation.But very much confused where to start from. Since I am installing oracle on my personaly Laptop,do I need to install Oracle database server and Oracle client both or only installing database server is sufficient.
What is the exact difference between oracle database server and client.Only knowledge I have is that client is used to access database server remotely.are Oracle database server and client installable to be downloaded separately?
View 1 Replies
View Related
Apr 23, 2012
there is a problem , related to toad. when i try to connect with my database through toad then it throws an error-"Can't initialize OCI. Error -1", how to sort out of this problem. and i am using toad 9.2.7.1 on widows server2008.
View 9 Replies
View Related