Oracle Database

Oracle Database

ORA-12519: Message 12519 not found

Hi all,

I have installed Oracle database and when I connected to it I have got this error:

ORA-12519: Message 12519 not found

I am not getting this message all the time, sometimes I have connected without any problems. When I get this message I have to try several times before getting connected. I don’t know the reasons of this message and how to set my ORACLE_HOME Environments variable, please I want any help or idea about this.

Thanks.

rocky_r73 N/A Asked on 07/22/2011 in
  • 4394 views
  • 1 answers
  • 0 votes

Set maximum forms sessions limit

Hi everyone,

For two years, I used Oracle database 10g and I am familiar with it but I am a new to Oracle Application Server 10g Release2, I have installed and deployed Oracle Forms 10g Applications on Oracle Application server. Where can I set the max session limit? Moreover how can I check “memory usage of forms session”?

Regards.

s_nelson96 N/A Asked on 07/22/2011 in
  • 2983 views
  • 1 answers
  • 0 votes

ORA-10997, ORA-09967 and Linux error

Hi expert,

I have installed Oracle 10.2.0 on open SUSE 11.1 Linux with no errors recorded from the installation. I have started the database listener however, I cannot startup the database. I have used two different methods of startup, and both of them gave me these errors:

ORA-10997: another startup/shutdown operation of this instance in progress

ORA-09967: unable to create or open lock file

Linux Error 2: No such file or directory

In both cases, the ORACLE_HOME and ORACLE_SID variables were set. I have tried ”startup force” command in sqlplus, but I still cannot start up the database. Can someone offer a solution for this problem?

Thanks to all.

y.ned26 N/A Asked on 07/22/2011 in
  • 5342 views
  • 1 answers
  • 0 votes

Error: ORA-106556 appears when I try to establish connection

Hi everybody,

I wish anyone can help me! I want to export information into a spread sheet so I try to establish Connection between Oracle PL/SQL programs and excel, and then I get the error ORA-106556. I have been searching on the web for some topics or solutions related to this error, but I don’t find any solutions.

Thanks in advance for your help, and by the way, the connection’s been set via DDE Initiate.

Able31.

 

able31 N/A Asked on 07/19/2011 in
  • 7103 views
  • 1 answers
  • 0 votes

Problem when I use TNSNAMES.ORA file to connect with database

Hi,

I'm a bit confused with TNSNAMES.ORA file. When I was connecting my database from my client location(UK) with service name "utv015"(as it is in tnsnames.ora), it was working fine. But when I try to connect to the same database with same service name and setting from India, it is not connecting even within the same client network. However If I change the tnsnames.ora file to reflect the service name to "utv015, utv015.seml.xyz.net = ( blaa..bla…)" (only the service name not other information) and connect the database with service name "utv015.seml.xyz.net", it is responding. I am just wondering what is happening here as this name is simply an alias.

What is the impact of this service name?

frankf91 N/A Asked on 07/18/2011 in
  • 1196 views
  • 1 answers
  • 0 votes

ORA-01555 caused by SQL statement

I have searched the internet and can't tell if the users query fails when I see the message in the alert log. The query is coming from a user running a report in business objects. What user and what query/report I can't tell. I have been going through the audit logs in Business Objects, and I am not finding report failures corresponding to the timestamp in the alert .log which makes me think maybe the query completes even though I receive the error message.

Please tell me the reasons for this error.

Thanks.

 

h.archer11 N/A Asked on 07/18/2011 in
  • 2167 views
  • 1 answers
  • 0 votes

ORA-01203: wrong incarnation of this file

Hi,

A few days before, tablespaces were dropped by users in Oracle databases. I have backup for these tablespaces. I need to restore these tablespaces in Oracle databases.But during the restore I was getting ora-01203: wrong incarnation of this file – wrong creation SCN error file.I have explained below what i did.

darinmicky N/A Asked on 07/18/2011 in
  • 3443 views
  • 1 answers
  • 0 votes

ORA-12560 TNS Protocol Adapter Failure

Hello Experts,

 I downloaded Oracle Developer suite 10g and installed in my PC. Then I opened a form and created one module of emp table. After that I started OC4J instance in Edit/Preference/runtime set application server url http://shahzaib-1:8889/forms90/f90servlet
(Reset to Default) then after that I ran the form through web and download Jinit (JInitiator 1.3.1.17). It then gave me an error
ora-12560 TNS Protocol Adapter Failure
I pressed OK and connected again but again same error. Please help me. I am using oracle 10g database and developer suit 10g only in server no client setup yet.

Thanks in advance.

 

cuthwolfdalvin N/A Asked on 07/18/2011 in
  • 2119 views
  • 1 answers
  • 0 votes

Error ora-06508: PL/SQL: could not find program unit being called

Hello,

I have a very strange error. We have a database with multiple schemas, now in one schema a new error occurs. This is the situation:
I have a view, with a call to package 'A' which calls package 'B'.When I do a select on the view in SQL/Plus , I get error
ora-06508: PL/SQL: could not find program unit being called

Here all the units are valid. If I recompile the units which are called, the problem disappears but after a few hours it re-appears. We try to increase server shared memory also but that didn't help. Can any one suggest the solution for this?

Regards,
Cyan.

 

cyandace N/A Asked on 07/18/2011 in
  • 3133 views
  • 1 answers
  • 1 votes

Error Saving in Oracle Database

Hello there,

I installed oracle in my laptop running on windows vista ultimate. Honestly, I am new in using Oracle Database and I really want to learn more about it. At first I never had a problem using this software, until an error dialog box pops up on my screen when trying to save my file. 

 Error saving

“C:oracleproduct10.2.0db_1networkADMINtnsnames.ora”!

Probably the file is locked by another application.

Geraldz N/A Asked on 07/18/2011 in
  • 1183 views
  • 2 answers
  • 0 votes

Latest Articles

How To Choose The Right Linux VPS For Your Needs

Nancy Allen -
Choosing the right Linux virtual private server (VPS) is a critical decision that can greatly impact your online projects, whether you’re running a website, hosting applications, or setting up a development environment. With various...
Read more

Benefits Of Storing And Sharing Documents In The Cloud

Ted Jason Alas -
Have you ever wished you could access your important documents anytime, anywhere? With cloud document storage, that wish becomes a reality. In today’s fast-paced world, secure and accessible document management is more essential than...
Read more

From Lost To Found: Restore Your Data On Windows 11

Hiltonkamal -
Are you worried about data you lost during some operation on your Windows 11? Don’t worry; we are here to guide you on how to recover the lost data from your Windows device in...
Read more

Latest Blogs

Top 10 New Laptop Entrants That Shook The Public

L.rose -
The finest laptops are powerful enough to do your daily tasks, comfortable enough to use all day, and power-efficient enough to ensure you don't run out of battery power unexpectedly. Of course, all these...
Read more

10 Facts About The Dark Web

Kvillamar -
Before getting into knowing the facts, let’s have a brief about the Dark Web. The dark web is the data of the World Wide Web that is accessible only through special software, combinations, or...
Read more

Top 10 Latest Steam Cleaner Machines

Jaide -
While looking for a chemical-free way to clear and purify both durable and low grounds in your home, a steam cleaner is an excellent solution. With a spurt of superheated steam, this cleaning equipment...
Read more

Latest Tips

Top 10 Internet Monitoring Software

Cagara Adryan -
Internet monitoring software keeps a log of all internet activities. You can install this type of software on your computer remotely or by the administrator. An operating console controls this software. This type of...
Read more

Top 10 Best Partition Manager Software

Mart Cullen -
A Hard Disk Drive is usually partitioned into various smaller drives for optimization. A partition manager helps make this process easier and more efficient. Here, let’s discuss the top 10 best partition manager software. 1....
Read more

Top 10 Best Online Music Production Software

Rosellas Phillips -
Music production is the initial stage of any song. Music production can be done either in studios or at home using an online music production software. Here, let’s discuss the top 10 best online...
Read more
© Copyright 2010-2025 by Techyv. All Rights Reserved.