Perl for Oracle Dbas

2017-07-07 02:10:07

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Z]

package variables , Perl

packages

ActivePerl for DDL::Oracle

extracting DDL from [See ddl_oracle.pl]

Perl

PPM ActivePerl, advantages of

prebuilt, installing Perl on Unix from

.gz suffix and

required by Cygwin

downloading

pager parameter (dbup.conf)

parameter files, created by defrag.pl command

parameter_diff_rpt

example output

reporting changes to initialization parameters

parameter_rpt, reporting on initialization parameters

parameters

binding to SQL statements

configuring

initialization, reporting changes to

reporting changes to

Params::Validate

installing on Win32

Mason and 2nd

parentheses (()), Perl regex metacharacter

password encryption

via TCP socket, pwd.pl

password server

client module communicating with

installing as Unix daemon or Win32 service

installing kss_NT.pl

loading parameters

PDBA [See PDBA password server]

PDBA repository and

scanning command line for options intended for

passwords

batch, problems with

encrypted, retrieving

encrypting [See also password encryption]

PDBA Toolkit scripts

generating in PDBA::DBA

inherent problems with

Karma security, TermReadKey.pm

managing via pwd.pl

Oracletool security levels

PDBA Toolkit password-control modules

security of

PATH variable

gnuplot and

installing Perl and

resetting when building Perl for oracle user

separator in, determining

pathsep method (PDBA module)

PDBA Extensions (PDBAx)

PDBA module

adding usage method to

configuring

methods

PDBA password client

configuring

creating configuration file for

PDBA password server

configuring

encrypting passwords

securing pwd.conf

setting passwords

setting TCP port

setting up password server users

setting up per-account authorization

running on Unix

running on Win32

Windows NT 4.0/2000

PDBA repository

allotting storage space for

changing date format in reports

creating baseline for

DBD::Oracle and

installing

access to V$PARAMETER/V$INSTANCE parameters

copying pdbarepq.conf

editing pdba_tbs8i.sql

tablespace creation

loading with data

Oracle data dictionary and

tables in

overhead

password server and

specialized tables in

table structure

viewing data

zzz [See also reports, of database changes][See also reports, of database changes]

PDBA Toolkit (Perl DBA Toolkit)

building database repository with 2nd [See also PDBA repository]

configuring

password client

password server

PDBA module

PDBA::CM

connection manager

downloading

example behaviors to modify

extending 2nd

zzz [See also PDBA::OPT PDBA::PWC][See also PDBA::OPT PDBA::PWC]

installing

on Unix

on Win32

methods [See PDBA::DBA]

modules 2nd 3rd

modifying

PDBA module

PDBA::CM

PDBA::ConfigFile

PDBA::ConfigLoad

PDBA::Daemon

PDBA::DBA

PDBA::GQ

PDBA::LogFile

PDBA::OPT

PDBA::PidFile

PDBA::PWC

PDBA::PWD

PDBA::PWDNT

Win32::Daemon

password client [See PDBA::PWC]

password client for NT [See PDBA::PWDNT]

passwords, managing [See PDBA::PWD]

programs in

repository [See PDBA repository]

required modules, directory for on Unix

security, script installation order

utilities [See PDBA module]

utilities logging [See PDBA::LogFile]

PDBA Toolkit scripts 2nd

baseline.pl, collecting baseline data dictionary data

checksums and

chkalert.pl, monitoring alert log with

create_user.pl

database administration 2nd

dba_jobsm.pl

configuring

functions/formats description

modifying

script description

dbup.pl/dbup_NT.pl

monitoring database connections

testing monitor

ddl_oracle.pl

directory for on Unix

directory paths for

dropping user accounts

dup_user.pl

extending toolkit

extracting DDL and data

functions/formats, line-by-line description of

idxr.pl, rebuilding indexes

installing

killing sniped sessions

kss.pl

installing on Unix

installing on Win32

line-by-line description of

logging by

maintaining indexes

managing extent usage

managing user accounts

maxext.pl

modifying

monitoring

monitoring alert log with

monitoring database connections

monitoring databases

mucr8.pl

password encryption

pdba_tbs8i.sql

repository

spdrvr.pl

command-line options

implementation of

options and tags

parameters

PDBA-generated SQL used with

predefined reports

reporting parameter changes

viewing repository data

sqlunldr.pl

SXP

sxp.pl

command-line options

password/privilege messages

unique constraint error

sxpcmp.pl

example output

sxprpt.pl

tablespace creation

pdba.conf

PDBA.ppd

PDBA::CM

configuration file [See cm.conf]

configuring

RaiseError/AutoCommit

SYSDBA/SYSOPER, login cases for

PDBA::ConfigFile

simplifying configuration

PDBA::ConfigLoad

loading script configuration files

referring to config variables by package name

PDBA::Daemon

creating Unix daemon in Perl

using Unix daemons in Perl

PDBA::DBA

creating user accounts

generating passwords in

PDBA::GQ

modifying

PDBA::LogFile

methods

PERMS attribute

PDBA::OPT 2nd 3rd

command-line overrides for

password server and

PDBA::PidFile

PDBA::PWC 2nd

password server and

using in Perl scripts

on Win32 [See PDBA::PWDNT]

PDBA::PWD

PDBA password server and

PDBA::PWDNT

PDBA_HOME variable

PDBA Toolkit and

default on Unix

installing on Win32

Unix configuration files

retrieving value of

code example

setting from command line

pdba_tbs8i.sql

pdbaHome method (PDBA module)

code example

pdbarep_create.log

pdbarep_create.sql

pdbarepq.conf 2nd

PDBAx (PDBA Extensions)

percent sign (%)

Perl in Mason template

Perl variable notation

performance

Apache::DBI and

Apache::Registry and

CGI scripts 2nd 3rd [See also Apache::Registry]

limiting resource consumption

Mason and

Perl and

perl_mod

sniped sessions and 2nd

statistics, reporting via DBD::Chart

Perl

"use strict" line in

advantages of

Apache and

zzz [See also mod_perl][See also mod_perl]

applications, servicing users/ requests

arrays

determining size of

boolean variable type and

built-in functions

built-in string-handling functions

communicating with PL/SQL

connectivity with PL/SQL

contexts

list

scalar

void

corporate world and

creating Unix daemon

creating Win32 daemon 2nd

data munging [See data munging ]

data parsing [See SchemaView-Plus]

data structures, converting to/from strings

debuggers

distribution with shared libperl, determining whether running

documentation

perldoc command

resources

downloading

from CPAN

driver for SQL*Plus

embedding into

Apache [See mod_perl]

Embperl templates

Mason template

Oracle

PL/SQL

FAQ documents

finding installation of

GUI extensions

guide to [See also Perl scripts, program\/subroutine parameters]2nd

hash structures, saving in platform-independent files

hashes

installing

under Cygwin

on Unix

on Win32

limitations of

manpage documents

modules [See modules]

object orientation in

obtaining online information

operating system documentation

origins of

references

anonymous arrays\/hashes

arrow notation

ref operator

regexes

alternation /memory

delimiters in

greediness of

grep vs.

history of

interpolated strings

metacharacters

scalar/list context results

string-handling functions and

resources for futher information

scalars

scripts [See Perl scripts]

security, web resource for modules

source, installing Perl on Unix from

storing data structures in

tools for DBAs

connectivity tools

modules and applications

scripts

table of

upgrading

using Unix daemons

using Win32 services

versions of

web access in [See LWP.pm]

web extensions

on Win32

writing ad hoc SQL reports

XML and

XML parsers

perl -MCPAN command

PDBA Toolkit, installing modules required by

Perl C library, calling

Perl Database Interface [See Perl DBI]

Perl DBA Toolkit [See PDBA Toolkit]

Perl DBI (Database Interface)

API

class methods

combining with Perl/Tk

connecting to

Oracle

as SYSDBA/SYSOPER

database handles

SQL and cleanup

statement handle methods

DBD::Oracle and

coding with Oracle::OCI

documentation

downloading 2nd

extproc_perl and

functions, table of

guide to

installing

under Cygwin

on Unix

on Win32

limitations of

methods

metadata- related

Oracle-specific

OCI and, code example illustrating integration of

OCIExtProcContext and

online documentation for

origins of

running

Hello World example

by proxy

using in loop-back mode

variable naming conventions

versions of

Perl IDEs (integrated development environments), web resources for

Perl integrated development environments (IDEs), web resources for

Perl Interactive Query Tool (PIQT)

perl -MCPAN command

interactive CPAN shell

loading LWP-related modules

loading mod_perl and related modules

perl orac_dbal.pl command

Perl Package Description [See PPD]

Perl Package Manager [See PPM]

Perl scripts

calling subroutines

debugging

environment variables

lexical

package

package main

PDBA Toolkit and

program\/subroutine parameters

running

on Unix

on Win32

sending email from 2nd

taint mode

using PDBA::PWC in

perl -v command

Perl/Oracle

architecture

use by DBAs

Perl/Oracle architecture

DBD::Oracle

OCI

functions, table of

Perl DBI

Perl/Tk

combining with Perl DBI

downloading

example programs 2nd

installing

on Unix

on Win32

programs, basic structure of

resources for further information

PERL_LIB library, creating during extproc_perl deployment

perldbgui program

perldoc command, accessing Perl documentation

perldoc ExtUtils::MakeMaker command

PerlFreshRestart option

PERMS attribute (PDBA::LogFile)

persistent connections

pie charts , for performance statistics [See DBD::Chart]

ping method (Perl DBI)

PIQT (Perl Interactive Query Tool)

PIRPC package

PL/SQL

advantages of Perl

communicating with Perl

connectivity with Perl

embedding Perl into

features

limitations of

zzz [See also Perl, embedding into PL/SQL][See also Perl, embedding into PL/SQL]

PL/SQL Runtime Engine

PL/SQL Server Pages (PSPs)

PL/SQL Web Toolkit

mod_perl and

packages in

zzz [See also Apache::OWA][See also Apache::OWA]

platforms

Apache runs on

creating log files independent of

for Perl/Oracle

porting Unix applications to Win32 [See Cygwin]

retrieving types of

PLSExtProc

alternative use of for database context

patching DBD::Oracle

plsql_errstr method (DBD::Oracle)

plug-ins, Senora

DataDictionary, ls option

SQL*Plus vs.

table of

PluginMgr register command (Senora)

plus sign (+), Perl regex metacharacter 2nd

plus sign-question mark (+?), Perl regex metacharacter

PNG (Portable Network Graphics)

DBD::Chart and

installing

StatsView and

$port data structure (pwd.conf)

portability, exporting/importing objects into Oracle databases

Portable Network Graphics [See PNG]

POSIX commands, Mason and

PPD (Perl Package Description)

obtaining latest files

PPM (Perl Package Manager)

Perl DBI and

running

ppm command

ppm utility

zzz [See also PPM][See also PPM]

prepare method

PDBA::GQ

Perl DBI

prepare_cached method (Perl DBI)

primary_key method (Perl DBI)

primary_key_info method (Perl DBI)

print method (PDBA::LogFile)

printflush method (PDBA::LogFile) 2nd

printif method (PDBA::LogFile)

privileges

developer account

granting while creating user accounts

in mucr8.conf file

reporting on database privilege grants

system, reporting on changes to

procedures

calling with OUT parameters

cookie manipulation

extracting DDL from [See ddl_oracle.pl]

profile_rpt, reporting on profiles

PROFILEs

creating

setting RESOURCE_LIMIT parameter (Oracle)

PROFILEs (Oracle)

programs

background [See PDBA::Daemon Win32::Daemon]

concurrent, preventing running of

Perl scripts

PSPs (PL/SQL Server Pages)

ptkdb program

pwc.pl 2nd

command-line options for

zzz [See also PDBA password client][See also PDBA password client]

%pwd data structure (pwd.conf)

pwd.conf

data structures

securing

zzz [See also PDBA password server][See also PDBA password server]

pwd.pl

password management in

pwd_service.pl

locating on Win32

Категории