Connection Error With BRTOOLS and "sqlplus console".

[Former Member]

Connection Error With BRTOOLS and "sqlplus console".

Best regards.

We have problems making backups from BRTOOLS, to prepare select the right tools he responds BR0301W SQL error -1031 at location BrDbaConnect-2,

FEATURES OS

OS Name Microsoft® Windows Server® 2008 Standard

Version  6.0.6002 Service Pack 2 Build 6002

Other OS Description         Not Available

OS Manufacturer                Microsoft Corporation

System Name       SAPOBDSTG-01

System Manufacturer        VMware, Inc.

System Model      VMware Virtual Platform

System Type         x64-based PC

FEATURES DB

Oracle Database 11g Enterprise Edition

Release 11.2.0.2.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Notes application to solve the problem.

Note 134592 - Importing the SAPDBA role (sapdba_role.sql)

Note 1597194 - Database Vault Installation Guide for SAP

Note 1595481 - Database User Management in a Database Vault Environment

Note 1605004 - Database Vault: Online Redefinition

Other situations or references.

When entering the intent "SQLPLUS console" via sqlplus "/ as SYSDBA" replies the error: ORA-01031: insufficient privileges

Attempted solutions.

*Se re-creo el archivo PWDPRD.ORA

* verify file sqlnet.ora

                ################

# Filename......: sqlnet.ora

# Created.......: created by SAP AG, R/3 Rel. >= 6.10

# Name..........:

# Date..........:

# @(#) $Id: //bas/720_REL/src/krn/tpls/ora/SQLNET.ORA#1 $

################

AUTOMATIC_IPC = ON

TRACE_LEVEL_CLIENT = OFF

1. NAMES.DEFAULT_DOMAIN = WORLD

# 05.01.06 unsorported parameter now

#NAME.DEFAULT_ZONE = WORLD

# 05.01.06 set the default to 10

1. SQLNET.EXPIRE_TIME = 10
2. SQLNET.AUTHENTICATION_SERVICES = (NTS)

# 05.01.06 set to default

#TCP.NODELAY=YES

# 05.01.06 set to 32768

DEFAULT_SDU_SIZE=32768

curious

To create a user other than the <sid>adm "PRDadm" I can smoothly enter the SQLPLUS "/ AS SYSADM" and DASE conextar the PRD and when I set user variables it stops working.

[Former Member]

Greetings to All.

Was solved, it was made a reboot of all systems including the AD domain is the AD was suspected the problem was.

success

[Former Member]

Hi Deepak Kori

thank you very much for your answer.

Since this variable is set in the same system put all variables if you notice anything that I can escape

ALLUSERSPROFILE=C:\ProgramData

APPDATA=C:\Users\prdadm\AppData\Roaming

CLIENTNAME=CCL-NBK-RT

CommonProgramFiles=C:\Program Files\Common Files

CommonProgramFiles(x86)=C:\Program Files (x86)\Common Files

COMPUTERNAME=SAPOBDSTG-01

ComSpec=C:\Windows\system32\cmd.exe

DBMS_TYPE=ora

dbs_ora_schema=SAPSR3

dbs_ora_tnsname=PRD

DFSTRACINGON=FALSE

FP_NO_HOST_CHECK=NO

HOMEDRIVE=C:

HOMEPATH=\Users\prdadm

LOCALAPPDATA=C:\Users\prdadm\AppData\Local

LOGONSERVER=\\xxxxxxx

NLS_LANG=AMERICAN_AMERICA.UTF8

NUMBER_OF_PROCESSORS=6

ORACLE_HOME=F:\oracle\PRD\11202

ORACLE_SID=PRD

OS=Windows_NT

Path=F:\oracle\PRD\11202\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\

Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;E:\orapatch\OPatch;\\SAPPRDSTG-

01\sapmnt\PRD\SYS\exe\uc\NTAMD64

PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC

PROCESSOR_ARCHITECTURE=AMD64

PROCESSOR_IDENTIFIER=Intel64 Family 6 Model 44 Stepping 2, GenuineIntel

PROCESSOR_LEVEL=6

PROCESSOR_REVISION=2c02

ProgramData=C:\ProgramData

ProgramFiles=C:\Program Files

ProgramFiles(x86)=C:\Program Files (x86)

PROMPT=$P$G

PSModulePath=C:\Windows\system32\WindowsPowerShell\v1.0\Modules\

PUBLIC=C:\Users\Public

SAPDATA_HOME=G:\oracle\PRD

SAPEXE=\\SAPPRDSTG-01\sapmnt\PRD\SYS\exe\uc\NTAMD64

SAPLOCALHOST=xxxxxxxxx

SAPSYSTEMNAME=PRD

SAP_DIR_PERF=F:\usr\sap\PRFCLOG

SESSIONNAME=RDP-Tcp#0

SystemDrive=C:

SystemRoot=C:\Windows

TEMP=F:\usr\sap\PRD\tmp\2

TMP=F:\usr\sap\PRD\tmp\2

TNS_ADMIN=\\SAPPRDSTG-01\sapmnt\PRD\SYS\profile\oracle

TRACE_FORMAT_SEARCH_PATH=\\winseqfe\release\Windows6.0\lh_sp2rtm\6002.18005.0904

10-1830\amd64fre\symbols.pri\TraceFormat

USERDNSDOMAIN=INPROLEC.NET

USERDOMAIN=INPROLEC

USERNAME=prdadm

USERPROFILE=C:\Users\prdadm

[former_member188883]

Hi Renny,

Could you set ORACLE_HOME for user prdadm and check the results.

Regards,

Deepak Kori