Solved

INSTALL HELP

Posted on 2004-08-17
5
3,478 Views
Last Modified: 2013-12-01
On a clean, standalone computer I am attempting to follow oracle by example instructions, I have;
added to the primary dns suffix of the computer,
added the ip and host name to the hosts file,
installed the Ora9i AS infrastructure;
     - name = Ora9ias_home
     - path = d:\ora9ias
     - instance name = infra,
installed the BI and forms option
     - name = Ora9ias_bi_home
     - path = d:\ora9ias_bi etc...
During this Oracle has created a DB = iasdb.jp.    
I login to sql as system, create a user, then i go to the c prompt to IMP.  I cant IMP as anybody, I get the message
IMP 00058 Oracle error 12560 encountered
ORA 12560 TNS protocol adapter error
IMP 00000 Import terminated unsuccessfully

0
Comment
Question by:tecumsehjoe
5 Comments
 
LVL 22

Expert Comment

by:Helena Marková
ID: 11828089
Maybe this article from Metalink will point you to the right direction though it is about Designer:

* fact: Oracle Designer 6.5
* fact: CKRAU - Repository Administration Utility
* fact: MS Windows NT
* fact: MS Windows 2000
* fact: MS Windows 98
* symptom: Installing the Repository from the Repository Administration Utility (RAU) gives errors.
* symptom: IMP-00058: ORACLE error 12560 encountered
* symptom: TNS-12560 / ORA-12560: TNS:protocol adapter error
* symptom: IMP-00000: Import terminated unsuccessfully
* symptom: Designer client and the Import/Export utilities are installed in separate Oracle Home directories
* symptom: Error when double clicking the executables IMP.EXE or EXP.EXE
* symptom: Can connect successfully to SQL*Plus from the Designer oracle_home\bin directory
* symptom: Error when connecting to SQL*Plus from the import/export tools oracle_home\bin directory.
* cause: The RAU check requirements parameter EXECUTE_PLUS_RAU under the key [HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\REPOS61] has a string value oracle_home\bin\sqlplus.exe where oracle_home is the directory where the import/export tools have been installed or any other directory where the SQL* Net configuration files do not exist.

fix:

Change the RAU parameter value for the variable EXECUTE_PLUS_RAU to just sqlplus.exe.

During the repository installation the RAU determines the location of SQL*Plus and SQL*Net configuration files (e.g.. tnsnames.ora) in order to perform the import operation. This should be the oracle_home for the Designer client.

Note : At the end of the Designer client installation the Universal Installer installs the files required ONLY for the repository installation, migration, import, and export. SQL*Plus should not by used directly from this directory as other SQL*Net files (e.g.: tnsnames.ora) do not exist in this oracle_home.
0
 
LVL 1

Expert Comment

by:Poornimashiv
ID: 11828484
Hi,

Are you able to import as normal Scott User?
Are you able to login to SQL as the new User that you have created? Also make sure that you are able to start the iasdb Database.

Regards,
Poornima
0
 

Author Comment

by:tecumsehjoe
ID: 11829018
i have found the fix and am able to import, thanx
0
 

Accepted Solution

by:
modulo earned 0 total points
ID: 12082284
PAQed, with points refunded (500)

modulo
Community Support Moderator
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

This exercise is about for the following scenario: Dmgr and One node with 2 application server. Each application server contains it owns application. Application server name as follows server1 contains app1 server2 contains app1 Prereq…
Upgrading Tomcat – There are a couple of methods to upgrade Tomcat is to use The Apache Installer is to download and unzip and run the services.bat remove|install Tomcat6 Because of the App that we are working with, we can only use Tomcat 6.…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…
Delivering innovative fully-managed cloud services for mission-critical applications requires expertise in multiple areas plus vision and commitment. Meet a few of the people behind the quality services of Concerto.

932 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now