Solved

INSTALL HELP

Posted on 2004-08-17
5
3,499 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

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!

Question has a verified solution.

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

Most of the developers using Tomcat find it easy to configure the datasource in Server.xml and use the JNDI name in the code to get the connection.  So the default connection pool using DBCP (or any other framework) is made available and the life go…
This article is about some of the basic and important steps to be used to improve the performance in web-sphere commerce application development. 1) Always leverage the Dyna-caching facility provided by the product 2) Remove the unwanted code …
If you're a developer or IT admin, you’re probably tasked with managing multiple websites, servers, applications, and levels of security on a daily basis. While this can be extremely time consuming, it can also be frustrating when systems aren't wor…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…

707 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