Home » RDBMS Server » Server Utilities » Restore (Oracle 11g 64 bit, Window Server 2008 R2)
Restore [message #563166] Thu, 09 August 2012 04:40 Go to next message
oracle@learner
Messages: 67
Registered: October 2011
Member

I have new configured window Server 2008 R2 Domain base. And installed Oracle 11g Successfully. And created database "test" from DCA. But when i try to connect the database its fail.

thanks in advance.
Re: Restore [message #563167 is a reply to message #563166] Thu, 09 August 2012 04:44 Go to previous messageGo to next message
Littlefoot
Messages: 19770
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
How did you "try to connect"? SQL*Plus? Could you copy/paste the whole session (as "its fail" is less than descriptive).

Also, what are you "restoring" (as suggested by topic title)? I understood that you created a brand new database ...
Re: Restore [message #563169 is a reply to message #563167] Thu, 09 August 2012 04:49 Go to previous messageGo to next message
Michel Cadot
Messages: 59748
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Answer to your questions in his previous topic where you helped him to install Oracle. Wink

Regards
Michel

[Updated on: Thu, 09 August 2012 04:52]

Report message to a moderator

Re: Restore [message #563170 is a reply to message #563167] Thu, 09 August 2012 05:01 Go to previous messageGo to next message
oracle@learner
Messages: 67
Registered: October 2011
Member

I have created database from DCA as test with username test and passeword test. But when i connect from sql


SQL*Plus: Release 11.2.0.1.0 Production on Fri Aug 10 15:22:39 2012

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Enter user-name: test
Enter password:
ERROR:
ORA-01017: invalid username/password; logon denied


Enter user-name:


this message has comes up.

Please help! Sad
Re: Restore [message #563173 is a reply to message #563170] Thu, 09 August 2012 05:12 Go to previous messageGo to next message
Michel Cadot
Messages: 59748
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You mix up database name "test" and schema/user name you didn't created any.
But DBCA has asked for SYS and SYSTEM passwords, use them.

AND feedback to your previous topic.

Regards
Michel
Re: Restore [message #563177 is a reply to message #563173] Thu, 09 August 2012 05:58 Go to previous messageGo to next message
oracle@learner
Messages: 67
Registered: October 2011
Member

i have reset password for SYS and SYSTEM to test
Re: Restore [message #563178 is a reply to message #563177] Thu, 09 August 2012 06:01 Go to previous messageGo to next message
Littlefoot
Messages: 19770
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
OK; so, can you connect with
sqlplus sys/test as sysdba
Re: Restore [message #563179 is a reply to message #563178] Thu, 09 August 2012 06:08 Go to previous messageGo to next message
oracle@learner
Messages: 67
Registered: October 2011
Member

Thanks now it is connected. Then how can configure Database for creating table.
Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

C:\Users\Administrator>telnet srv-cashub1
'telnet' is not recognized as an internal or external command,
operable program or batch file.

C:\Users\Administrator>telnet
'telnet' is not recognized as an internal or external command,
operable program or batch file.

C:\Users\Administrator>sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on Fri Aug 10 16:29:39 2012

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Enter user-name: sys/test as sysdba

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>
Re: Restore [message #563180 is a reply to message #563179] Thu, 09 August 2012 06:16 Go to previous messageGo to next message
Littlefoot
Messages: 19770
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You need to create a new user, then connect as it (newly created user) and start creating tables.

Here's a short walkthrough:
SQL> select tablespace_name from dba_tablespaces;

TABLESPACE_NAME
------------------------------
SYSTEM
UNDOTBS1
SYSAUX
TEMP
USERS

SQL> create user brisime identified by bri
  2  default tablespace users
  3  temporary tablespace temp
  4  profile default
  5  quota unlimited on users;

User created.

SQL> grant create session, create table to brisime;

Grant succeeded.

SQL> connect brisime/bri@ora10
Connected.

SQL> create table my_first_table (col date);

Table created.

SQL> insert into my_first_table (col) values (sysdate);

1 row created.

SQL> select * from my_first_table;

COL
-------------------
09.08.2012 13:16:12

SQL>


However, I think that you should read some documentation first. Although you are on 11g, have a look at this 10g documentation page - its "Getting started" section is what you should read (Concepts first, then 2 day DBA). After that, go to SQL Reference. These should make a good starting point for you.

[Updated on: Thu, 09 August 2012 06:17]

Report message to a moderator

Re: Restore [message #563187 is a reply to message #563179] Thu, 09 August 2012 06:32 Go to previous messageGo to next message
oracle@learner
Messages: 67
Registered: October 2011
Member

How can I restore backup file DMP to this new oracle 11g database.
Re: Restore [message #563188 is a reply to message #563187] Thu, 09 August 2012 06:41 Go to previous messageGo to next message
Littlefoot
Messages: 19770
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
IMP or IMPDP, depending on the way you took the export.
Re: Restore [message #563196 is a reply to message #563188] Thu, 09 August 2012 08:06 Go to previous messageGo to next message
oracle@learner
Messages: 67
Registered: October 2011
Member

I use exp command as below :-
exp test/test@orclimpl parfile=testbk.txt


Parfile as below:-
BUFFER=2097152
FILE=test_Full.dmp
FULL=n
OWNER=test
GRANTS=y
COMPRESS=n
CONSISTENT=y


exported file name is test_Full.dmp and I would like to import/restore in newly installed oracle 11g Window server domain.

Thanks again in advance.!!
Re: Restore [message #563200 is a reply to message #563196] Thu, 09 August 2012 08:35 Go to previous messageGo to next message
Michel Cadot
Messages: 59748
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
imp user/psw fromuser=test touser=test bufffer=2097152

Regards
Michel
Re: Restore [message #563288 is a reply to message #563200] Sat, 11 August 2012 04:17 Go to previous messageGo to next message
oracle@learner
Messages: 67
Registered: October 2011
Member

Should I have to create the user test in new oracle 11g or simple i have to put the imp command.? The following message comes..
Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

C:\Users\Administrator>e:

E:\>cd d
The system cannot find the path specified.

E:\>cd Backup

E:\Backup>imp test/test fromuser=test touser=newtest bufffer=2097152
LRM-00101: unknown parameter name 'bufffer'

IMP-00022: failed to process parameters, type 'IMP HELP=Y' for help
IMP-00000: Import terminated unsuccessfully

E:\Backup>


Thanks!

[Updated on: Sat, 11 August 2012 04:55]

Report message to a moderator

Re: Restore [message #563290 is a reply to message #563288] Sat, 11 August 2012 05:15 Go to previous messageGo to next message
oracle@learner
Messages: 67
Registered: October 2011
Member

When try to connect from Net manager , not able to connect.
Attempting to connect using userid:  test1
The test did not succeed.
ORA-01017: invalid username/password; logon denied

There may be an error in the fields entered,
or the server may not be ready for a connection. 
Re: Restore [message #563294 is a reply to message #563290] Sat, 11 August 2012 08:33 Go to previous messageGo to next message
BlackSwan
Messages: 23029
Registered: January 2009
Senior Member
what is valid username/password for this DB?
Re: Restore [message #563295 is a reply to message #563288] Sat, 11 August 2012 09:27 Go to previous message
Littlefoot
Messages: 19770
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
oracle@learner wrote on Sat, 11 August 2012 11:17

E:\Backup>imp test/test fromuser=test touser=newtest bufffer=2097152
LRM-00101: unknown parameter name 'bufffer'

IMP-00022: failed to process parameters, type 'IMP HELP=Y' for help

Previous Topic: expdp fails
Next Topic: EXTERNAL TABLE PROBLEM
Goto Forum:
  


Current Time: Sun Nov 23 01:54:20 CST 2014

Total time taken to generate the page: 0.08083 seconds