Oracle Database

Oracle Database

Hi,

I tried to install Oracle Database 11g on my pc running on Windows Vista Home Premium 64 bit. When I tried to run the program, an error message appeared on my screen.

Here is the exact error message:

Windows Could not start the OracleDBConsoleorcl on Local Computer.

For more information, review the system Event Log. If this is a non-Microsoft service, contact the service vendor, and refer to service-specificerror code 2.

  • 1410 views
  • 2 answers
  • 0 votes

Hello there,

I’ve been using Toad on 8.1.7 Oracle database. At first everything works fine until the TOAD Script error prompt to my screen. Here is the error message:

ORA-29532: Java call terminated by uncaught Java exception:

java.security.AccessControlException: the Permission

(java.io.FilePermission <<ALL FILES>>’,’execute’) has not been granted to

HR. The PL/SQL to grant this is dbms_java.grant_permission(‘HR’,

‘SYS: java.io.FilePermission’.’ <<ALL FILES>>’,’execute’)

ORA-06512: at “HR.HOST_COMMAND”, line 2

ORA-06512: at line 2

  • 1534 views
  • 1 answers
  • 0 votes

Hi,

When creating a new table (via "New Table" or "Data Load …") NLS_LENGTH_SEMANTICS of table columns are always in byte even when NLS_LENGTH_SEMANTICS is set to char for the instance (and so as default for all sessions) and has not explicitly changes for the current session.  Is there a way to change this behavior or could this be a general problem in 3.0? I would like SQL Developer to use the standard settings of the instance as long as I don't set it different for a session. Please give me a little hint how to solve this issue.

Thanks in advance.

  • 1549 views
  • 1 answers
  • 0 votes

Hello,

I am using SQL Dev 3.0 Prod version on Windows 7, JDK 1.6.0_25. I am trying to import csv data file using the Import Data menu option under Actions in the Table Browser window. There are about 700 rows in the csv file and each time I try the Import wizard, map columns etc. and launch the Insert, SQL Dev 3.0 hangs. This happens with xls as well as csv files. Is this is a known issue? Do I need to increase memory allocation?

Thanks

  • 2062 views
  • 1 answers
  • 0 votes

Hi,

The error is: ORA-07445: exception encountered: core dump [ACCESS_VIOLATION]

I am getting this error in alert log while trying to open one of our oracle production db running on windows server.

I am able to mount it without any problem but once I try to open it, it just hangs and the smon trace file grows very big 500mb+ until I terminate the session.

I want to know the reasons of this error and how can I solve it?

Thanks.

  • 2466 views
  • 2 answers
  • 0 votes

Hi friends,

Upon arriving at the office, I opened my email, and I received a memo that instructs me to do some reverse engineering. When I started the process of reverse engineering from Oracle server to Microsoft Visio, there was an error. I posted it below for a complete view of the problem.

Encountered a fatal error during reverse engineer of information from the database!

On my analysis of the problem, I can hardly figure out what went wrong with my process of reverse engineering. So to make sure maybe I left something, I repeated all the process, and same error displayed again.I am asking for some technical advice on the issue that I encounter on how to implement reverse engineering.

Thanks.

  • 1596 views
  • 1 answers
  • 0 votes

Hi techyv,

I am using Oracle BI Admin Tool to construct some repositories of a physical layer, the mapping layer, business model and abstracted end-user presentation layer.

  • 2301 views
  • 2 answers
  • 0 votes

Hi,

When i am using TOAD to administer our oracle database,

I meet an error that tells me ORA-00942: table or view does not exist.

ORA-00942: table or view does not exist

ORA-00942: table or view does not exist

I came across this error every time I am compiling an object, package, view in oracle, and sometimes when I execute PL/SQL statement on Oracle table. It also happens when I run an application, specifically oracle program.

  • 2637 views
  • 2 answers
  • 0 votes

Hi all,

I am using Oracle for our companies' application. When I was doing some coding with my oracle project, I got an error that said, no connection to the database.

No database connection

No connection to the ‘Spectrum’ database could be made. Please correct the problem and try again!

As I understand with the error, it points to a connection going to the database server, I checked on my network connection and it seems to have no problem, I am connected with the companies local area network.

  • 898 views
  • 1 answers
  • 0 votes

Hello guys and girls,

I am using Red Hat 5 and trying to install oracle 11G on it. Whenever I try to install the enterprise manager phase, the following error appears.

Enterprise manager configuration failed due to the following
error –
Listener is not up. Start the Listener and run EM Configuration
Assistant again.
Refer to the log file at
/u01/app/oracle/cfgtoollogs/dbca/orcl/emConfig.log for more
details.
You can retry configuring this database with Enterprise
Manager later by manually running /u01/app/oracle/product/11.1.0/db_1/bin/emca script.
oracle error

  • 1252 views
  • 1 answers
  • 20 votes

Latest Articles

How To Choose The Right Linux VPS For Your Needs

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...

Benefits Of Storing And Sharing Documents In The Cloud

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...

From Lost To Found: Restore Your Data On Windows 11

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...

Latest Blogs

Top 10 New Laptop Entrants That Shook The Public

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...

10 Facts About The Dark Web

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...

Top 10 Latest Steam Cleaner Machines

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...

Latest Tips

Top 10 Internet Monitoring Software

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...

Top 10 Best Partition Manager Software

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....

Top 10 Best Online Music Production Software

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...