Skip to main content

Abnormal Program Termination. An internal error has occurred. Please provide the following files to Oracle Support./ Installing Oracle 10g on Windows 7/Vista

This video will take you through the steps to install Oracle 10g Release 2 on Windows 7 (Same steps work for Windows Vista). Usually if you install Oracle database on window 7/Vista you would get an error,

Abnormal Program Termination. An internal error has occurred. Please provide the following files to Oracle Support.

Follow the steps shown in this video to successfully install Oracle Database on Windows 7/Vista.


Unknown said…
still not installing..showing error msg. as 'insufficient previlage'
Unknown said…
still not installing..showing error msg. as 'insufficient previlage'
PC said…
Although Mithun has demonstrated how to workaround installation of Oracle 10gR2 32bit on MS Windows 64bit (and it worked for me), its not supported by Oracle. Pls refer metalink note id: 1060806.1

raul said…
regarding character strings qstn was display name,empno,deptno for employee kiran but employee kiran is not der in our table i took other name.. query goes like this
select empno,ename,deptno from emp
where lower(ename)='Allen' but no rows wer selected..only if i give it in original format then only it displays the result...lower(ename) shud convert it and shud display result ryt?
Mithun Ashok said…
Hi PC,

It even throws the same error sometimes while installing 64bit DB and this version of DB is supported.

Abcd said…
It was really helpful. Thanks a lot.
Naveen said…
Hi mithun

Thank you very much for your support.

i am facing this problem from past 6 months, by watching your blog i got problem and solved.

once again thank you.
Harish_kumar_bk said…
Thankyou sir for all the information.
Ramanath said…
Hello Mithun,
Am getting below error when I try to open SQL*plus, Please let me know how I can resolve this issue?

ORA-12154: TNS: could not resolve the connect identifier specified

Thanks in advance..!!!
Mithun Ashok said…
Youre welcome...
Mithun Ashok said…

This means that you have not started your database. Start your database from Windows services and then try to login.
Radhika Karanth said…
is 10g express edition OK to install and practice?
Bhavya08 said…
Installation video is very helpful, by watching this video its very easy to install database in windows7.

Thanks mithun,
Prajwal said…
Thanks a lot Mithun,
This helps!
shank said…
hello sir,
oracle initialization or shutdown in progress is the error its showing when i tried to login . please help me with this.
samanth said…
am gettin account is locked error plzz help
Soheila Saadati said…
thanx alot,god bless you
Emmanuel said…

That is one of the most helpful info I have ever gotten from the net....Thanks alot
Sebastian Ramirez said…
Miguel Zumbado said…

I'm using Windows 7 Pro and trying to install Oracle 10g, same as the video.

BUT when I go to properties -> Compatibility -> and check on Run this program in compatibility mode for:

I don't have Windows XP neither Windows 98 in the list

How can I include older versions of windows in that list?

Anonymous said…
thanks a lot.. its working !!
Anonymous said…
Thank you it worked for me on a Windows Server 2008!
Unknown said…
Am not able to uninstall oracle10g ... although am running it on xp !
The same error is showed .... Plz resolve this issue .
Unknown said…
Hi Mith!
I have already install it and some program are not running fine and I have to deinstall it, I try with same way for installation but no success! oracle 10g on win7 64 bit
Unknown said…
hi sir,
i installed the s/w in win7 professional 32 bit n while doing password management i removed tick marks for hr and scott entered the password as tiger and first time i runned it as admin and i m getting error as user and password denied pls tell me what has to be done.
Ann said…
Hi Sir,
I need a help in installing Oracle 10g. While installing it, im encountering an error like "The value of environment variable path is more than 1023 characters. This value cannot be set" The options available are : Help, Retry, Ignore and Cancel. Please tell me what should I do now..

Unknown said…
my laptop has been formatted. how to download oracle10g
Unknown said…
configure the compatiability mode, and set it to xp....worked for me
Rana said…
Follow the steps shown in this video to successfully install Oracle Database on Windows 7/Vista.

Where is video?
Prakash patra said…
the value of the environment variable path is more than 1023 characters this value cannot be set this error is coming while installing. pleas heal me
Thank you, owner, of the web page for showing healthy information. I am very impressed by you. The discussion section is good but just on average. You can find information regarding IT services at.
best software services in hyderabad

Popular posts from this blog

SQL Interview Questions on Subqueries

SUB Queries:
1. List the employees working in research department 2. List employees who are located in New York and Chicago
3. Display the department name in which ANALYSTS are working
4. Display employees who are reporting to JONES
5. Display all the employees who are reporting to Jones Manager
6. Display all the managers in SALES and ACCOUNTING department
7. Display all the employee names in Research and Sales Department who are having at least 1 person reporting to them
8. Display all employees who do not have any reportees
9. List employees who are having at least 2 reporting
10. List the department names which are having more than 5 employees
11. List department name having at-least 3 salesman
12. List employees from research and accounting having at-least 2 reporting
13. Display second max salary
14. Display 4th max salary
15. Display 5th max salary  -- Answer for nth Max Salary
Co-Related Subqueries:
16. Write a query to get 4th max salary from EMP table
17. Write a query to get 2nd…

Basics of RDBMS

Small set of information becomes data, this set of information helps make decision. Data is always some useful information.

Place where you store the data. Database represents some aspect of the real world called "miniworld". A database is designed, built and populated with data for a specific purpose. It has intended group of users and some preconceived applications in which these users are interested.

In other words, a database has some source from which data is derived, some degree of interaction with events in the real world and an audience that is actively interested in the contents of the database.

Database can also be defined as collection of one or more tables.

Ex: Mobile, human brain etc

DBMS (Database Management System)
Is a program that stores retrieves and modifies data in the database on request.

Study of different techniques of design, development and maintenance of the database

Types of DBMS
These types are based upon their management of database s…

Answers for SQL Functions

1. SQL> SELECT empno, ename FROM emp WHERE Length(ename) = 4;

2. SQL> SELECT empno, ename, job FROM emp where Length(job)=7;

3. SQL> SELECT Length('qspiders') - Length(replace('qspiders','s','')) FROM dual;

4. SQL>  SELECT empno, ename, job FROM emp WHERE Instr(job,'MAN') >0;

5. SQL> SELECT empno, ename, job FROM emp WHERE Instr(job, 'MAN') =1;

6. SQL> SELECT empno, ename, job FROM emp WHERE (Length(ename) - Length(Replace(ename, 'L',''))) = 1;

7. SQL> SELECT * FROM dept WHERE Instr(dname,'O') > 0;

8. SQL> SELECT Concat(ename,' working as a ') || Concat(job, ' earns ') || Concat(sal, '  in ') || Conc
at('dept ',deptno) AS text from emp;


SQL> SELECT Concat(Concat(Concat(Concat(Concat(Concat(Concat(ename,' working as a '), job),' earns '), sal),'  in '),'dept '), deptno) AS text FROM emp;

9. SQL> SELECT empno, ename…