OraFAQ Forum: Windows » Can not create database PACKS and create a user PACKS (merged)

Home » Infrastructure » Windows » Can not create database PACKS and create a user PACKS (merged)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Can not create database PACKS and create a user PACKS (merged) [message #567400]

Mon, 01 October 2012 02:08

ariffcal
Messages: 107
Registered: April 2011

Senior Member

I am trying to create database called PACKS .

I login as

Enter as scott/tiger

Then

SQL> conn / as sysdba
Connected.
SQL> conn system/manager
ERROR:
ORA-01017: invalid username/passwor

Warning: You are no longer connecte
SQL> conn system/oracle
ERROR:
ORA-01017: invalid username/passwor

SQL> conn / as sysdba
Connected.
SQL> alter user system identified b

User altered.

SQL> commit;

Commit complete.

SQL> conn system/manager
Connected.
SQL>

The I give coomand

Enter as scott/tiger

Then

SQL> conn / as sysdba
Connected.
SQL> conn system/manager
ERROR:
ORA-01017: invalid username/passwor

Warning: You are no longer connecte
SQL> conn system/oracle
ERROR:
ORA-01017: invalid username/passwor

SQL> conn / as sysdba
Connected.
SQL> alter user system identified b

User altered.

SQL> commit;

Commit complete.

SQL> conn system/manager
Connected.
SQL>
CREATE DATABASE PACKS
USER SYS IDENTIFIED BY PACKS
USER SYSTEM IDENTIFIED BY PACKS
LOGFILE GROUP 1 ('/u01/app/oracle/oradata/mynewdb/redo01.log') SIZE 100M,
GROUP 2 ('/u01/app/oracle/oradata/mynewdb/redo02.log') SIZE 100M,
GROUP 3 ('/u01/app/oracle/oradata/mynewdb/redo03.log') SIZE 100M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
CHARACTER SET US7ASCII
NATIONAL CHARACTER SET AL16UTF16
EXTENT MANAGEMENT LOCAL
DATAFILE '/u01/app/oracle/oradata/mynewdb/system01.dbf' SIZE 325M REUSE
SYSAUX DATAFILE '/u01/app/oracle/oradata/mynewdb/sysaux01.dbf' SIZE 325M REUSE
DEFAULT TABLESPACE users
DATAFILE '/u01/app/oracle/oradata/mynewdb/users01.dbf'
SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE '/u01/app/oracle/oradata/mynewdb/temp01.dbf'
SIZE 20M REUSE
UNDO TABLESPACE undotbs
DATAFILE '/u01/app/oracle/oradata/mynewdb/undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;

Getting error ora - 01100 database mounted

Please help

Report message to a moderator

Re: Can not create database PACKS [message #567402 is a reply to message #567400]

Mon, 01 October 2012 02:22

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

Getting error ora - 01100 database mounted

The actual message is: "ORA-01100: database already mounted".
You cannot create a database that is already created.
You cannot create a database connected as SYSTEM.

Your post is a mess.
I don't even understand if you really execute what you posted in the order you posted this.

Maybe you confuse "database" and "schema".

Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.

Use SQL*Plus and copy and paste your session, the WHOLE session.

Regards
Michel

Report message to a moderator

Re: Can not create database PACKS [message #567409 is a reply to message #567400]

Mon, 01 October 2012 02:41

ariffcal
Messages: 107
Registered: April 2011

Senior Member

The code is given below.

SQL> alter user system identified b

User altered.

SQL> commit;

Commit complete.

SQL> conn system/manager
Connected.
SQL>
CREATE DATABASE PACKS
USER SYS IDENTIFIED BY PACKS
USER SYSTEM IDENTIFIED BY PACKS
LOGFILE GROUP 1 ('/u01/app/oracle/oradata/mynewdb/redo01.log') SIZE 100M,
GROUP 2 ('/u01/app/oracle/oradata/mynewdb/redo02.log') SIZE 100M,
GROUP 3 ('/u01/app/oracle/oradata/mynewdb/redo03.log') SIZE 100M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
CHARACTER SET US7ASCII
NATIONAL CHARACTER SET AL16UTF16
EXTENT MANAGEMENT LOCAL
DATAFILE '/u01/app/oracle/oradata/mynewdb/system01.dbf' SIZE 325M REUSE
SYSAUX DATAFILE '/u01/app/oracle/oradata/mynewdb/sysaux01.dbf' SIZE 325M REUSE
DEFAULT TABLESPACE users
DATAFILE '/u01/app/oracle/oradata/mynewdb/users01.dbf'
SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE '/u01/app/oracle/oradata/mynewdb/temp01.dbf'
SIZE 20M REUSE
UNDO TABLESPACE undotbs
DATAFILE '/u01/app/oracle/oradata/mynewdb/undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;

Getting error ora - 001100 database mounted

Please help

Report message to a moderator

Re: Can not create database PACKS [message #567410 is a reply to message #567409]

Mon, 01 October 2012 02:44

Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

If you altered user SYSTEM and modified its password to "B", how come you connected as SYSTEM/MANAGER?

It is difficult to assist when you are telling lies.

Report message to a moderator

Re: Can not create database PACKS [message #567414 is a reply to message #567409]

Mon, 01 October 2012 02:56

ariffcal
Messages: 107
Registered: April 2011

Senior Member

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Produ
With the Partitioning, OLAP and Data Mining options

SQL> CREATE DATABASE PACKS
2 USER SYS IDENTIFIED BY PACKS
3 USER SYSTEM IDENTIFIED BY PACKS
4 LOGFILE GROUP 1 ('/u01/app/oracle/oradata/mynewdb/redo01.
5 GROUP 2 ('/u01/app/oracle/oradata/mynewdb/redo02.
6 GROUP 3 ('/u01/app/oracle/oradata/mynewdb/redo03.
7 MAXLOGFILES 5
8 MAXLOGMEMBERS 5
9 MAXLOGHISTORY 1
10 MAXDATAFILES 100
11 CHARACTER SET US7ASCII
12 NATIONAL CHARACTER SET AL16UTF16
13 EXTENT MANAGEMENT LOCAL
14 DATAFILE '/u01/app/oracle/oradata/mynewdb/system01.dbf' S
15 SYSAUX DATAFILE '/u01/app/oracle/oradata/mynewdb/sysaux01
16 DEFAULT TABLESPACE users
17 DATAFILE '/u01/app/oracle/oradata/mynewdb/users01.dbf'
18 SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
19 DEFAULT TEMPORARY TABLESPACE tempts1
20 TEMPFILE '/u01/app/oracle/oradata/mynewdb/temp01.dbf'
21 SIZE 20M REUSE
22 UNDO TABLESPACE undotbs
23 DATAFILE '/u01/app/oracle/oradata/mynewdb/undotbs01.db
24 SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
CREATE DATABASE PACKS
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-01100: database already mounted

Pls help , getting theabove message , while logedin as SYSTEM/MANAGER

Report message to a moderator

Re: Can not create database PACKS [message #567417 is a reply to message #567414]

Mon, 01 October 2012 03:14

Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

It appears that you didn't read Michel's message, did you?
Michel

You cannot create a database that is already created.
You cannot create a database connected as SYSTEM.

Report message to a moderator

create a user in Oracle 10g Express edition named PACKS password PACKS. [message #567430 is a reply to message #567400]

Mon, 01 October 2012 05:15

ariffcal
Messages: 107
Registered: April 2011

Senior Member

1. How to create a user in Oracle 10g Express edition named PACKS password PACKS.

2. Then create a ODBC DSN called PACKS pointing to that .

Can u pls give me the coding and help me .

Thanks

Report message to a moderator

Re: create a user in Oracle 10g Express edition named PACKS password PACKS. [message #567433 is a reply to message #567430]

Mon, 01 October 2012 05:32

Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

The first part is easy: connect as a privileged user (such as SYS) and CREATE USER. However, that's most probably not enough as that user doesn't have any privileges (it can't even connect to the database) so you need to GRANT certain privileges. Here's an example:

C:\>sqlplus sys@xe as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Pon Lis 1 12:29:41 2012

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

Enter password:

Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production

SQL> select tablespace_name from dba_tablespaces;

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

SQL> create user packs identified by packs
  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 packs;

Grant succeeded.

SQL> connect packs/packs@xe
Connected.
SQL> create table test (col1 number);

Table created.

SQL>

AS of the second part: I wouldn't know how to "create a ODBC DSN ...".

Report message to a moderator

Re: create a user in Oracle 10g Express edition named PACKS password PACKS. [message #567440 is a reply to message #567433]

Mon, 01 October 2012 05:54

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

To create an ODBC DSN, go to the Control Panel, open Adminstration Tools, then the ODBC item (name depends on version) and then follow the assistant.

Regards
Michel

Report message to a moderator

create a user in Oracle 10g Express [message #567446 is a reply to message #567440]

Mon, 01 October 2012 06:36

ariffcal
Messages: 107
Registered: April 2011

Senior Member

I would like to

create a user in Oracle 10g Express edition named, PACKS with password PACKS.

Can u pls give me the coding .

Should I log in as systems Manager .

Report message to a moderator

Re: create a user in Oracle 10g Express [message #567449 is a reply to message #567446]

Mon, 01 October 2012 06:42

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You didn't read Littlefoot's post, did you?

Regards
Michel

Report message to a moderator

Previous Topic:	Unable to kill a session using Orakill
Next Topic:	Oracle Service doesn't start

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 16:33:53 CDT 2024