Solved

How to uninstall Apps R12 from Linux completely?

Posted on 2011-03-13
12
1,511 Views
Last Modified: 2013-12-19
I am totally new for Apps R12, and want to uninstall it from my linux system, so that I can reinstall it.
I need steps to do that.
Please suggest

Thanks
0
Comment
Question by:Devinder Singh Virdi
  • 7
  • 3
  • 2
12 Comments
 
LVL 78

Expert Comment

by:arnold
ID: 35123298
Which linux distro do you use?  Did you use an RPM or a DPKG to install it?
rpm -qa | grep <App R12 package name>
rpm -e <App R12 package name>

dpkg --list | grep <App R12 package name>
dpkg -r <App R12 package name>

not sure you want to remove it so that you can reinstall it? What is it you are trying to fix?

There is a way to use rpm/dpkg for the package to be verified.
If you are on Solaris, you use use the pkginfo and pkgrm to remove the package
0
 
LVL 15

Author Comment

by:Devinder Singh Virdi
ID: 35123462
I installed using rapid wiz, and for my practice I want to uninstall it.
I am also having lots of problems, so i am thinking of reinstalling it and after that I will note every steps I am doing.
Also which Tns and Listener files is used by db owner?
actually I changed DB name and now not able to start listener, tnsping etc. I am getting ORA-12154
This is also one of the reason I am want to reinstall everything.
But if I can fix all these without reinstall that will be the best solution.
Following are the current problems:
1. able to connect DB without using net services otherwise getting ORA 12154 error.
2. unable to use http://domain.com:8076
3. In order to try the command sh adstpall.sh APPS/<APPS password> I forgot APPS password. Dont know how to change it. I can use ALTER USER command, but not sure if that is the correct way or not.
0
 

Expert Comment

by:mohssinm
ID: 35123565
Hi ,

   Try using rm -rf to delete all folder related
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 15

Author Comment

by:Devinder Singh Virdi
ID: 35123579
@mohssinm:
That the final solution, but i am looking one step prior.
0
 

Assisted Solution

by:mohssinm
mohssinm earned 100 total points
ID: 35123636
Fix those problem without reinstall will give you good experiance .
0
 
LVL 78

Accepted Solution

by:
arnold earned 150 total points
ID: 35123722
$ORACLE_HOME/oratab I think is where the items are defined.
The reason you can not start the listener might be cause the last DB shutdown was unclean.
You need to check the error log and if needed to "repair" the db at which point the listener will start working again.

http://ora-12154.ora-code.com/

I'd agree with mohssinm, all a remove and reinstall will do is teach you to remove and install.
Fixing this will teach you much more from troubleshooting, to consider/eliminate causes/solutions (critical thinking).
Since should you encounter the same situation on the Job a remove/reinstall will not fix the underlying issue given that you can not discard the data nor the database.
0
 
LVL 15

Author Comment

by:Devinder Singh Virdi
ID: 35123984
Thanks,
Here is the first problem. I am not able to do tnsping. I did the following

tnsping DEVDB
TNS Ping Utility for Linux: Version 11.1.0.7.0 - Production on 13-MAR-2011 22:43:58
Copyright (c) 1997, 2008, Oracle.  All rights reserved.
Used parameter files:
TNS-03505: Failed to resolve name

Above statement is looking for which parameter file. Since I already changed DB name, Instance name and few directories names as well, but need to know if that effects this utility for 11g.

Another thing is ps -ef | grep smon is giving me OLD database name.
0
 
LVL 15

Author Comment

by:Devinder Singh Virdi
ID: 35124003
Also the command CREATE SPFILE FROM PFILE='.....'  created the spfile with OLD dbname.
Am I missing something in renaming DB?
0
 
LVL 78

Expert Comment

by:arnold
ID: 35124100
do you have the tnsname.ora
Which system are you on Linux Centos/RedHAT, Debian version or Solaris?
http://www.experts-exchange.com/Database/Oracle/Q_26857233.html?cid=1131
http://stackoverflow.com/questions/1749512/commandline-to-modify-tnsnames-ora

Provide some use of oracle command line tools to make adjustments to the configuration.
0
 
LVL 15

Author Comment

by:Devinder Singh Virdi
ID: 35124108
Got the answer of ps -ef| grep smon
database was down and I used OLD ORACLE_SID to connect. Since pfile has correct database name and instance name, from database point of view it was showing me correct values when using
SHOW PARAMETER DB_NAME
SHOW PARAMETER INSTANCE_NAME,
but echo $ORACLE_SID gave me old name and when I changed this and restarted the database, everthing looks normal.

I changed OS variable to point correct tnsnames.ora by modifying TNS_ADMIN variable.
Now I have to see listener one.
0
 
LVL 15

Author Comment

by:Devinder Singh Virdi
ID: 35124357
I noticed couple of variables problem in my apps environment files as well as in listener file.
ie, I was using DEVDB database therefore my entries were like this:
DEVDB = (DESCRIPTION .... )
SID_LIST_LISTENER = (.....) , I need to change this as SID_LIST_DEVDB
I dont know the concept of ifile, which is last statement of listener.
This file has only 2 bytes.

I think now i can relink Apps with new DB.
I will get back to you soon.
0
 
LVL 15

Author Closing Comment

by:Devinder Singh Virdi
ID: 35125236
Thanks,
I found most of the answer without reinstalling it.
I am opening new thread for other problems.

Regards
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Alternative to GTT for a temp table for further reuse in Oracle 8 44
SQL2016 to ORACLE11G linked-server 6 49
Oracle Errors 11 45
oracle query 3 25
Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

713 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question