Solved

INSTALL HELP

Posted on 2004-08-17
5
3,494 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

Save the day with this special offer from ATEN!

Save 30% on the CV211 using promo code EXPERTS30 now through April 30th. The ATEN CV211 connects a laptop directly to any server allowing you instant access to perform data maintenance and local operations, for quick troubleshooting, updating, service and repair.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Problem to refer to codes 10 126
more than one path in advanced variables while installing netbeans 2 104
Multi-threading in Tomcat 4 213
listing all functions in JavaScript 19 251
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…
Verbose logging is used to diagnose garbage collector problems. By default, -verbose:gc output is written to either native_stderr.log or native_stdout.log.   It is also possible to redirect the logs to a user-specified file. This article will de…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

739 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