Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2013
    Posts
    39
    Provided Answers: 2

    Answered: not able to connect the db as sysdba

    Hi,

    few days ago i was able to login as sysdba now i am not able to connect to the db as a sysdba. Please advise...

    Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
    PL/SQL Release 12.1.0.2.0 - Production
    "CORE 12.1.0.2.0 Production"
    TNS for Linux: Version 12.1.0.2.0 - Production
    NLSRTL Version 12.1.0.2.0 - Production

    $sqlplus / as sysdba

    ERROR:
    ORA-01017: invalid username/password; logon denied

    Enter user-name: sys/pass@testdb as sysdba

    Connected to:
    Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
    With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
    SQL>

  2. Best Answer
    Posted by awais290

    "I got this fixed..

    this is for Oracle database on linux.....

    if your $ORACLE_HOME/network/admin/sqlnet.ora has this entry then remove it or make it to none

    SQLNET.AUTHENTICATION_SERVICES= (NTS)

    because this is for AD authentication for Windows user..."


  3. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    post results from OS commands below

    id
    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.

  4. #3
    Join Date
    Feb 2013
    Posts
    39
    Provided Answers: 2
    [oracle@itmd12c expdump]$ id
    uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba),54323(oper) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023

    [oracle@itmd12c expdump]$ env | sort
    CLASSPATH=/u01/app/oracle/product/12.1.0/db_1/jlib:/u01/app/oracle/product/12.1.0/db_1*/rdbms/jlib
    HISTCONTROL=ignoredups
    HISTSIZE=1000
    HOME=/home/oracle
    HOSTNAME=itmd12c
    LANG=en_US.UTF-8
    LD_LIBRARY_PATH=/u01/app/oracle/product/12.1.0/db_1/lib:/lib:/u*sr/lib
    LESSOPEN=||/usr/bin/lesspipe.sh %s
    LOGNAME=oracle
    LS_COLORS=rs=0:di=01;34:ln=01;36:mh=00i=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01r=40;31;01:mi=01;05;37;41:su=37;41:sg=30;43:ca=30; 41:tw=30;42w=34;42:st=37;44:ex=01;32:*.tar=01;31:*.tgz=01;31: *.arc=01;31:*.arj=01;31:*.taz=01;31:*.lha=01;31:*. lz4=01;31:*.lzh=01;31:*.lzma=01;31:*.tlz=01;31:*.t xz=01;31:*.tzo=01;31:*.t7z=01;31:*.zip=01;31:*.z=0 1;31:*.Z=01;31:*.dz=01;31:*.gz=01;31:*.lrz=01;31:* .lz=01;31:*.lzo=01;31:*.xz=01;31:*.bz2=01;31:*.bz= 01;31:*.tbz=01;31:*.tbz2=01;31:*.tz=01;31:*.deb=01 ;31:*.rpm=01;31:*.jar=01;31:*.war=01;31:*.ear=01;3 1:*.sar=01;31:*.rar=01;31:*.alz=01;31:*.ace=01;31: *.zoo=01;31:*.cpio=01;31:*.7z=01;31:*.rz=01;31:*.c ab=01;31:*.jpg=01;35:*.jpeg=01;35:*.gif=01;35:*.bm p=01;35:*.pbm=01;35:*.pgm=01;35:*.ppm=01;35:*.tga= 01;35:*.xbm=01;35:*.xpm=01;35:*.tif=01;35:*.tiff=0 1;35:*.png=01;35:*.svg=01;35:*.svgz=01;35:*.mng=01 ;35:*.pcx=01;35:*.mov=01;35:*.mpg=01;35:*.mpeg=01; 35:*.m2v=01;35:*.mkv=01;35:*.webm=01;35:*.ogm=01;3 5:*.mp4=01;35:*.m4v=01;35:*.mp4v=01;35:*.vob=01;35 :*.qt=01;35:*.nuv=01;35:*.wmv=01;35:*.asf=01;35:*. rm=01;35:*.rmvb=01;35:*.flc=01;35:*.avi=01;35:*.fl i=01;35:*.flv=01;35:*.gl=01;35:*.dl=01;35:*.xcf=01 ;35:*.xwd=01;35:*.yuv=01;35:*.cgm=01;35:*.emf=01;3 5:*.axv=01;35:*.anx=01;35:*.ogv=01;35:*.ogx=01;35: *.aac=01;36:*.au=01;36:*.flac=01;36:*.mid=01;36:*. midi=01;36:*.mka=01;36:*.mp3=01;36:*.mpc=01;36:*.o gg=01;36:*.ra=01;36:*.wav=01;36:*.axa=01;36:*.oga= 01;36:*.spx=01;36:*.xspf=01;36:
    MAIL=/var/spool/mail/oracle
    OLDPWD=/home/oracle
    ORACLE_BASE=/u01/app/oracle
    ORACLE_HOME=/u01/app/oracle/product/12.1.0/db_1
    ORACLE_SID=devtest
    PATH=/u01/app/oracle/product/12.1.0/db_1/bin:/usr/sbin:/usr/local/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/home/oracle/.local/bin:/home/oracle/bin
    PWD=/orabasic/expdump
    SELINUX_LEVEL_REQUESTED=
    SELINUX_ROLE_REQUESTED=
    SELINUX_USE_CURRENT_RANGE=
    SHELL=/bin/bash
    SHLVL=1
    SSH_CLIENT=10.196.69.57 54763 22
    SSH_CONNECTION=10.196.69.57 54763 10.30.1.150 22
    SSH_TTY=/dev/pts/1
    TERM=xterm
    TMPDIR=/tmp
    TMP=/tmp
    USER=oracle
    _=/usr/bin/env
    XDG_RUNTIME_DIR=/run/user/54321
    XDG_SESSION_ID=511

  5. #4
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  6. #5
    Join Date
    Feb 2013
    Posts
    39
    Provided Answers: 2
    I got this fixed..

    this is for Oracle database on linux.....

    if your $ORACLE_HOME/network/admin/sqlnet.ora has this entry then remove it or make it to none

    SQLNET.AUTHENTICATION_SERVICES= (NTS)

    because this is for AD authentication for Windows user...
    Last edited by awais290; 05-27-15 at 15:12.

Posting Permissions

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