Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2004
    Posts
    8

    Unanswered: how to change the password for my newly created database instance?

    fellows, I manually created a new instance of a database (oracle on linux), using CREATE DATABASE command.

    However, I have no idea which user and/or password to use in order to access it.

    1) how do I create a new user for that instance?
    2) how do I change the password?

    FYI, my command to create was:

    CREATE DATABASE ETSDB2
    2 Maxinstances 1
    3 Maxloghistory 1
    4 Maxlogfiles 10
    5 Maxdatafiles 100
    6 LOGFILE GROUP 1 ('/oracle/db/oradata/ETSDB2/redo01.log') SIZE 100M,
    GROUP 2 ('/oracle/db/oradata/ETSDB2/redo02.log') SIZE 100M,
    7 8 GROUP 3 ('/oracle/db/oradata/ETSDB2/redo03.log') SIZE 100M
    9 Datafile '/oracle/db/oradata/ETSDB2/temp01.dbf'
    10 size 300M reuse autoextend on next 15M maxsize unlimited
    11 character set US7ASCII
    12 default temporary tablespace TEMP
    13 tempfile '/oracle/db/oradata/ETSDB2/temp_01.dbf' SIZE 70M
    14 extent management local uniform size 1M;


    thanks!!!

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    create user:

    connect sys as sysdba

    create user <user> identified by <pwd> default tablespace <tblsps> temporary tablespace <temp>;

    grant connect , resource to <user>;

    change pwd

    alter user sys identified by <pwd>; or

    issue: orapwd file=orapw<SID> entries=<n> password=<pwd>

  3. #3
    Join Date
    Apr 2003
    Location
    Minneapolis, MN
    Posts
    273
    (1) connect to linux as oracle user and from the command prompt run the profile (environment variable) for this db.

    (2).... ]$ sqlplus

    (3) SQL> conn / as sysdba

    HTH
    Bhavin

    MS Computer Science
    OCP DBA 9i/8i

  4. #4
    Join Date
    Mar 2004
    Posts
    8
    but if I use this:


    create user <user> identified by <pwd> default tablespace <tblsps> temporary tablespace <temp>;

    what's the name of my tablespace (<tblsps>)?

    ?

    Originally posted by osy45
    create user:

    connect sys as sysdba

    create user <user> identified by <pwd> default tablespace <tblsps> temporary tablespace <temp>;

    grant connect , resource to <user>;

    change pwd

    alter user sys identified by <pwd>; or

    issue: orapwd file=orapw<SID> entries=<n> password=<pwd>

  5. #5
    Join Date
    Nov 2002
    Posts
    833
    Originally posted by aegcp
    but if I use this:


    create user <user> identified by <pwd> default tablespace <tblsps> temporary tablespace <temp>;

    what's the name of my tablespace (<tblsps>)?

    ?
    by default it is always system, but it is not a good idea to put other users' data and objects in system tablespace. Though create a new one

    create tablespace <tblsps> datafile "filespecs" size ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •