?
Solved

INSTALL HELP

Posted on 2004-08-17
5
Medium Priority
?
3,508 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

ATEN's HDBaseT Presentation at InfoComm 2017

Hear ATEN Product Manager YT Liang review HDBaseT technology, highlighting ATEN’s latest solutions as they relate to real-world applications during her presentation at the HDBaseT booth at InfoComm 2017.

Question has a verified solution.

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

Configure Web Service (server application) I. Configure security for Web Services methods First, we need to protect Session bean which implements the service: 1. Open EJB deployment descriptor (ejb-jar.xml) in the EJB project that contains you…
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.…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses

743 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