Home » Infrastructure » Windows » Can not create database PACKS and create a user PACKS (merged)
Can not create database PACKS and create a user PACKS (merged) [message #567400] Mon, 01 October 2012 02:08 Go to next message
ariffcal
Messages: 100
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
Re: Can not create database PACKS [message #567402 is a reply to message #567400] Mon, 01 October 2012 02:22 Go to previous messageGo to next message
Michel Cadot
Messages: 59087
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


Re: Can not create database PACKS [message #567409 is a reply to message #567400] Mon, 01 October 2012 02:41 Go to previous messageGo to next message
ariffcal
Messages: 100
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
Re: Can not create database PACKS [message #567410 is a reply to message #567409] Mon, 01 October 2012 02:44 Go to previous messageGo to next message
Littlefoot
Messages: 19603
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.
Re: Can not create database PACKS [message #567414 is a reply to message #567409] Mon, 01 October 2012 02:56 Go to previous messageGo to next message
ariffcal
Messages: 100
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
Re: Can not create database PACKS [message #567417 is a reply to message #567414] Mon, 01 October 2012 03:14 Go to previous messageGo to next message
Littlefoot
Messages: 19603
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.
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 Go to previous messageGo to next message
ariffcal
Messages: 100
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
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 Go to previous messageGo to next message
Littlefoot
Messages: 19603
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 ...".
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 Go to previous messageGo to next message
Michel Cadot
Messages: 59087
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
create a user in Oracle 10g Express [message #567446 is a reply to message #567440] Mon, 01 October 2012 06:36 Go to previous messageGo to next message
ariffcal
Messages: 100
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 .



Re: create a user in Oracle 10g Express [message #567449 is a reply to message #567446] Mon, 01 October 2012 06:42 Go to previous message
Michel Cadot
Messages: 59087
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You didn't read Littlefoot's post, did you?

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


Current Time: Tue Sep 16 16:41:47 CDT 2014

Total time taken to generate the page: 0.10318 seconds