Results 1 to 10 of 10
  1. #1
    Join Date
    Apr 2009
    Posts
    4

    Unanswered: sqlplus login/passwd

    I installed to oracle 10g express version for linux, It has been a while and I dont remember the oralce username and passwd that I had given during installation.

    When I run sqlplus at the command prompt it asks me for a username and passwd.

    How do I reset the root username and passwd .

    thanks
    Prashanth

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >How do I reset the root username and passwd
    root schema does not exist (by default).
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Apr 2009
    Posts
    4
    Let me rephrase how do I reset sqlplus username and passwd

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    sqlplus
    / as sysdba
    ALTER USER SCHEMANAME IDENTIFIED BY PASSWORD;
    EXIT
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Apr 2009
    Posts
    4
    I tried this

    sqlplus / as sysdba

    but it still prompts me for username and passwd.

    What is the command sqlplus ... that I should run

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    You need to be logged into th Operating System as the owner of the Oracle software tree.

    Post Operating System (OS) name & version for DB server system.
    Post Oracle version to 4 decimal place of database s/w.
    Post client environmental variables (either SET or env | sort )
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  7. #7
    Join Date
    Apr 2009
    Posts
    4
    OS version........linux localhost.localdomain 2.6.9-1.667 #1 Tue Nov 2 14:41:25 EST 2004 i686 i686 i386 GNU/Linux

    Oracle version 10.2.0.1.0

    client env

    KDE_MULTIHEAD=false
    SSH_AGENT_PID=3252
    HOSTNAME=localhost.localdomain
    SHELL=/bin/bash
    TERM=xterm
    CATALINA_HOME=/usr/share/tomcata
    HISTSIZE=1000
    GTK2_RC_FILES=/etc/gtk-2.0/gtkrc:/root/.gtkrc-2.0:/root/.kde/share/config/gtkrc
    NLS_LANG=AMERICAN_AMERICA.AL32UTF8
    GTK_RC_FILES=/etc/gtk/gtkrc:/root/.gtkrc:/root/.kde/share/config/gtkrc
    GS_LIB=/root/.fonts
    WINDOWID=33554439
    KDE_FULL_SESSION=true
    USER=root
    XCURSOR_SIZE=
    LD_LIBRARY_PATH=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib:/usr/tibco/tibrv/lib:/usr/lib
    LS_COLORS=no=00:fi=00:di=00;34:ln=00;36i=40;33:so=00;35:bd=40;33;01:cd=40;33;01r=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32: *.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*. sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj =00;31:*.taz=00;31:*.lzh=00;31:*.zip=00;31:*.z=00; 31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.t z=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif =00;35:*.bmp=00;35:*.xbm=00;35:*.xpm=00;35:*.png=0 0;35:*.tif=00;35:
    ORACLE_SID=XE
    SSH_AUTH_SOCK=/tmp/ssh-OGrbYG3251/agent.3251
    KDEDIR=/usr
    SESSION_MANAGER=local/localhost.localdomain:/tmp/.ICE-unix/3357
    KONSOLE_DCOP=DCOPRef(konsole-4058,konsole)
    MAIL=/var/spool/mail/root
    DESKTOP_SESSION=kde
    PATH=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/root/bin:/usr/bin:/bin:/usr/tibco/tibrv/bin:/usr/share/ant/bin:/usr/libexec
    KONSOLE_DCOP_SESSION=DCOPRef(konsole-4058,session-1)
    INPUTRC=/etc/inputrc
    PWD=/mnt
    JAVA_HOME=/usr/java/jdk1.5.0_09
    LANG=en_US.UTF-8
    GDMSESSION=kde
    SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
    HOME=/root
    SHLVL=3
    XCURSOR_THEME=default
    LOGNAME=root
    CLASSPATH=/usr/java/jdk1.5.0_09:/usr/share/tomcata/common/lib/servlet-api.jar:/usr/share/tomcata/common/lib/jsp-api.jar:/usr/share/jdk1.5.0_09:/usr/share/jakarta-tomcat-4.1.3:/root/trading:/root/pras/com:root/tib/src/examples/java:usr/tibco/tibrv/lib/tibrvnative.jar
    DBUS_SESSION_BUS_ADDRESS=unix:abstract=/tmp/dbus-CeqtbMNSW4
    LESSOPEN=|/usr/bin/lesspipe.sh %s
    DISPLAY=:0.0
    ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
    G_BROKEN_FILENAMES=1
    COLORTERM=
    XAUTHORITY=/root/.Xauthority
    _=/bin/env
    OLDPWD=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin

  8. #8
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Which OS user owns /usr/lib/oracle/xe/app/oracle/product/10.2.0/server tree?
    Why is Oracle software installed under /usr/lib?

    You should NOT be running as root!
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  9. #9
    Join Date
    Jan 2009
    Location
    Dhaka, Bangladesh
    Posts
    51
    Quote Originally Posted by mylvarab
    I installed to oracle 10g express version for linux, It has been a while and I dont remember the oralce username and passwd that I had given during installation.

    When I run sqlplus at the command prompt it asks me for a username and passwd.

    How do I reset the root username and passwd .

    thanks
    Prashanth
    First of all log in to the OS user account you used to create the database.

    ... check ORACLE_SID, ORACLE_HOME is set properly

    then in command line

    $ sqlplus / as sysdba

    sql> alter user sys identified by new_password;
    Mohammad Hasan Shaharear
    E-mail
    Blog: http://shaharear.blogspot.com

  10. #10
    Join Date
    Apr 2009
    Posts
    30
    Hello !
    I think you should reinstall the oracle version on your system if possible.If you have some data in your database then take the backup of .dbf files on your system.you will find those files under oracle installed dir.for safer side take the backup of .ctl anf .log files also.

Posting Permissions

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