Home » RDBMS Server » Server Utilities » Exporting Database (Oracle 9i)
Exporting Database [message #458491] Mon, 31 May 2010 01:08 Go to next message
Obwaka
Messages: 5
Registered: May 2010
Junior Member
Hi,

I am Trying to Export my database and whenever I try to login it is giving Ora-Error 1017 Invalid Username/Password.

If I Login as System and Manager it is accepting but I am not able to Export all my Database.

Any Help??
Re: Exporting Database [message #458493 is a reply to message #458491] Mon, 31 May 2010 01:14 Go to previous messageGo to next message
Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post what you do and get.

Regards
Michel
Re: Exporting Database [message #458549 is a reply to message #458493] Mon, 31 May 2010 03:50 Go to previous messageGo to next message
Obwaka
Messages: 5
Registered: May 2010
Junior Member
Hi Michel,

According to this attached files, My Database is actdat.
if I connect through Username:system/manager@actdat it brings the Error 1017 But if I connect through Username:SYSTEM/MANAGER using Caps and not specifying the Database, I am able to connect.

Look at the Attached files.

Rgds
Obwaka
  • Attachment: Error.JPG
    (Size: 228.83KB, Downloaded 976 times)
Re: Exporting Database [message #458551 is a reply to message #458549] Mon, 31 May 2010 03:55 Go to previous messageGo to next message
Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Sorry but as many others I can't or don't want to download files.
So copy and paste it as text inside the post.

Regards
Michel
Re: Exporting Database [message #458555 is a reply to message #458551] Mon, 31 May 2010 04:18 Go to previous messageGo to next message
Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As far as I can tell, Oracle's unsernames and passwords are case insensitive (in versions I used so far; that excludes 11g). Therefore that is probably not the case.

But, did you see what you posted? The first username and the second one differ.
1) Username: system/manager@actdat
2) Username: SYSTEM/MANAGER

Where did "@actdat" go?

In other words: you probably don't connect to the same database.
Re: Exporting Database [message #459580 is a reply to message #458555] Mon, 07 June 2010 04:40 Go to previous messageGo to next message
Obwaka
Messages: 5
Registered: May 2010
Junior Member
Hi,

If I try to Connect as system/manager@actdat it is saying invalid Username, but if I am connecting as SYSTEM/MANAGER (NB CAPS IS ON) It is connecting but not all Database is being exported.

Rgds
Obwaka.
Re: Exporting Database [message #460084 is a reply to message #458551] Wed, 09 June 2010 09:11 Go to previous messageGo to next message
Obwaka
Messages: 5
Registered: May 2010
Junior Member
Hi Michel,

I tried sending the files but the forum could not allow me. It is saying I cannot use links be cause I have not posted more than five msgs. So, I have attached everything in a .txt file.

Just try look at the txt file. I hope it will be fine with you.

Rgds
Obwaka.
  • Attachment: File.txt
    (Size: 2.89KB, Downloaded 1478 times)
Re: Exporting Database [message #460086 is a reply to message #460084] Wed, 09 June 2010 09:24 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Exporting Database (Oracle 9i)
>Export : Release 8.1.7.0.0 - Production on Wed Jun 9 16:17:53 2010
>D:\oracle\ora81\network\admin\tnsnames.ora

post results from following SQL

SELECT * FROM V$VERSION;

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: Exporting Database [message #460199 is a reply to message #460086] Thu, 10 June 2010 02:31 Go to previous messageGo to next message
Obwaka
Messages: 5
Registered: May 2010
Junior Member

SQL*Plus: Release 8.1.7.0.0 - Production on Thu Jun 10 10:07:12 2010

(c) Copyright 2000 Oracle Corporation. All rights reserved.


Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production

SQL> SELECT * FROM V$VERSION;

BANNER
----------------------------------------------------------------
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
PL/SQL Release 8.1.7.0.0 - Production
CORE 8.1.7.0.0 Production
TNS for 32-bit Windows: Version 8.1.7.0.0 - Production
NLSRTL Version 3.4.1.0.0 - Production
Re: Exporting Database [message #460245 is a reply to message #460199] Thu, 10 June 2010 05:33 Go to previous message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
you didn`t answered all the questions !
Quote:
Where did "@actdat" go?


post the contents from your tnsnames.ora


And michel asked you to post what you did not the content of tnsnames.ora file.

to be frank I never worked on that Oracle version(8i).
"What happend when you put <1>E insted of 1"

And I will post your tnsnames.ora file content here
Quote:
Hi Michel,

My Database name is ORDTRACK and Service Name is actdat.
If i need to export, I usually login using: system/manager@actdat
i.e.

c:\>exp

Export : Release 8.1.7.0.0 - Production on Wed Jun 9 16:17:53 2010

(c) copyright 2000 oracle corporation. All rights reserved.

username: system/manager@actdat

EXP-00056: Oracle error 1017 encountered
ORA-01017: Invalid username/password; logon denied


----------------------------------------------------------

If i try connecting using system/manager without specifying the conection string it is accepting. But the problem is that when i try to export not all the tables in my database are being exported.

Also if I connect to SQL Plus without specifying the Host string, I am able to connect. I type Username as 'system' and Password as 'manager'.


--------------------------------------------------------------

This is my tnsnames.ora file in the Client machine

# TNSNAMES.ORA Network Configuration File: D:\oracle\ora81\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = x.x.x.116)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = actdat)
(PRESENTATION = http://admin)
)
)

actdat =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = x.x.94.59)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ordtrack)
)
)

testprod =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = x.x.x.x)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = testprod)
)
)

test =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = x.x.x.45)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = test)
)
)

---------------------------------------------------------------

This is also my tnsnames.ora file in the Server

# TNSNAMES.ORA Network Configuration File: F:\oracle\ora81\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORDTRACK =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = Ordtrack)
)
)

INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = Ordtrack)
(PRESENTATION = http://admin)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

-------------------------------------------------------------

Any kind of help will be appreciated.
Rgds
Obwaka.


sure you are not connected to "x.x.94.59" you connected to "server"

Confirm it
sriram Smile
Previous Topic: Export/Import using unix pipe
Next Topic: Does Oracle Forms & Report Serices (Standalone) Support Data Export utility
Goto Forum:
  


Current Time: Wed Apr 24 15:36:10 CDT 2024