DevOps, CI/CD and Automation

Just created the newuser in 10g.

I tried to login through sqlplus and got the following error

-rwxr-x--x 1 oracle oinstall 830120 Aug 18 14:23 exp
-rwxr-x--x 1 oracle oinstall 140128 Aug 18 14:23 tkprof
-rwxr-x--x 1 oracle oinstall 898416 Aug 18 14:23 sqlldr
-rwxr-x--x 1 oracle oinstall 12838968 Aug 18 14:23 rman
-rwxr-x--x 1 oracle oinstall 470320 Aug 18 14:23 kgmgr
-rwxr-x--x 1 oracle oinstall 20280 Aug 18 14:23 loadpsp
-rwxr-x--x 1 oracle oinstall 233840 Aug 18 14:23 impdp
-rwxr-x--x 1 oracle oinstall 226896 Aug 18 14:23 expdp
-rwxr-x--x 1 oracle oinstall 27288 Aug 18 14:23 tstshm
-rwxr-x--x 1 oracle oinstall 16440 Aug 18 14:23 maxmem
-rwxr-x--x 1 oracle oinstall 31856 Aug 18 14:23 genezi
-rwxr-x--x 1 oracle oinstall 643824 Aug 18 14:23 dbv
-rwxr-x--x 1 oracle oinstall 26736 Aug 18 14:23 orapwd
-rwxr-x--x 1 oracle oinstall 594720 Aug 18 14:23 dumpsga
-rwxr-x--x 1 oracle oinstall 16456 Aug 18 14:23 dbfsize
-rwxr-x--x 1 oracle oinstall 594368 Aug 18 14:23 mapsga
-rwxr-x--x 1 oracle oinstall 34432 Aug 18 14:23 extproc
-rwxr-x--x 1 oracle oinstall 33584 Aug 18 14:23 cursize
-rwxr-x--x 1 oracle oinstall 47216 Aug 18 14:23 hsots
-rwxr-x--x 1 oracle oinstall 46808 Aug 18 14:23 hsdepxa
-rwxr-x--x 1 oracle oinstall 152032 Aug 18 14:23 hsalloci
-rwxr-x--x 1 oracle oinstall 28332 Aug 18 14:23 extproc32
-rwxr-x--x 1 oracle oinstall 69112 Aug 18 14:23 agtctl
-rwxr-x--x 1 oracle oinstall 138552 Aug 18 14:23 sbttest
-rwxr-x--x 1 oracle oinstall 2515480 Aug 18 14:23 dgmgrl
-rwxr-x--x 1 oracle oinstall 165424 Aug 18 14:23 nid
-rwxr-x--x 1 oracle oinstall 1339408 Aug 18 14:23 hsodbc
-rwx------ 1 oracle oinstall 16496 Aug 18 14:23 extjobo
-rwxr-x--x 1 oracle oinstall 6838688 Aug 18 14:23 kfod
-rws--s--x 1 nobody nobody 16496 Aug 18 14:23 extjob
-rwxr-xr-x 1 oracle oinstall 34076 Aug 18 14:23 sslsetup
-rwxr-xr-x 1 oracle oinstall 8032 Aug 18 14:23 emutil
-rw-r--r-- 1 oracle oinstall 66522 Aug 18 14:23 emctl.pl
-rwxr--r-- 1 oracle oinstall 9310 Aug 18 14:23 emctl
-rw-r--r-- 1 oracle oinstall 17115 Aug 18 14:23 EmctlCommon.pm
-rwxr-xr-x 1 oracle oinstall 3185 Aug 18 14:23 targetdeploy.pl
-rwxr-xr-x 1 oracle oinstall 985 Aug 18 14:23 searchctl
-rwx------ 1 oracle oinstall 2806 Aug 18 14:23 onsctl
-rwxr-xr-x 1 oracle oinstall 1600 Aug 18 14:23 emca
-rwxr-xr-x 1 oracle oinstall 6658 Aug 18 14:23 repo_mig
-rwxr-xr-x 1 oracle oinstall 862 Aug 18 14:23 emtgtctl
-rwxr-xr-x 1 oracle oinstall 3757 Aug 18 14:23 emagentdeploy.pl
-rwxr-xr-x 1 oracle oinstall 5156 Aug 18 14:23 dbca
-r-xr-xr-x 1 oracle oinstall 12051 Aug 18 14:23 localconfig
-rw-r--r-- 1 oracle oinstall 355 Aug 19 13:31 createdb.log
-rw-r--r-- 1 oracle oinstall 1561 Aug 19 13:53 createtsp.log
-rw-r--r-- 1 oracle oinstall 137 Aug 30 11:01 afiedt.buf
$ ./sqlplus

SQL*Plus: Release 10.1.0.2.0 - Production on Tue Aug 30 15:05:31 2005

Copyright (c) 1982, 2004, Oracle. All rights reserved.

Enter user-name: system
Enter password:

Connected to:
Oracle Database 10g Release 10.1.0.2.0 - 64bit Production

SQL> grant create session to gavdba;

Grant succeeded.

SQL> grant role dba to gavdba;
grant role dba to gavdba
*
ERROR at line 1:
ORA-00990: missing or invalid privilege


SQL> grant connect to gavdba;

Grant succeeded.

SQL> grant resource to gavdba;

Grant succeeded.

SQL> grant dba to gavdba;

Grant succeeded.

SQL> Gran EXP_FULL_DATABASE to gavdba;
SP2-0734: unknown command beginning "Gran EXP_F..." - rest of line ignored.
SQL> grant exp_full_database to gavdba;

Grant succeeded.

SQL> grant imp_full_database to gavdba;

Grant succeeded.

SQL> grant executor_role to gavdba;
grant executor_role to gavdba
*
ERROR at line 1:
ORA-01919: role 'EXECUTOR_ROLE' does not exist


SQL> grant select_catalog_role to user;
grant select_catalog_role to user
*
ERROR at line 1:
ORA-00987: missing or invalid username(s)


SQL> grant select_catalog_role to gavdba;

Grant succeeded.

SQL> grant recovery_catalog_owner to gavdba;

Grant succeeded.

SQL> exit
Disconnected from Oracle Database 10g Release 10.1.0.2.0 - 64bit Production
$ clear
$ sl -ltr
ksh: sl: not found
$ ls
DBConsole.pm fmputlhp ocssd
EMAgent.pm genagtsh ocssd.bin
EMDeploy.pm genclntsh oerr
EmctlCommon.pm genclntst oidadmin
EmctlCommon.pm.template genezi oidca
IASConsole.pm geneziO oidprovtool
adapters genksms oifcfg
afiedt.buf gennfgt ojvmjava
agentok.sh gennttab olsadmintool
agtctl genoccish olsoidsync
agtctlO gensyslib onsctl
cemutls gsd oracg
clscfg gsd.sh oracle
clsfmt gsdctl oracleO
clsid helpins oradism
coraenv hsalloci oraenv
createdb.log hsallociO orajaxb
createtsp.log hsdepxa orapipe
crsctl hsdepxaO orapki
crsctl.bin hsodbc orapwd
csscan hsodbcO orapwdO
csscanO hsots oratclsh
ctxkbtc hsotsO oratclsh0
ctxlc imp oraxml
ctxlcO impO oraxsl
ctxload impdp osdbagrp
ctxloadO impdpO osh
cursize isqlplusctl ott
cursizeO isqlplusctl.pl proc
dbca kfod proxyserv
dbfsize kfod0 pupbld
dbfsizeO kgmgr racgchsn
dbhome kgmgrO racgeut
dbshut kgpmon racgimon
dbstart lbuilder racgmain
dbua lcsscan racgmdb
dbv ldapadd racgwrap
dbvO ldapaddmt rawutl
deploync ldapbind relink
dgmgrl ldapcompare repo_mig
dgmgrlO ldapdelete repo_mig.template
dropjava ldapmoddn rman
dsml2ldif ldapmodify rmanO
dumpsga ldapmodifymt runclass
dumpsga0 ldapsearch sbttest
e2eme ldifmigrator sbttestO
e2eme0 lmsgen schema
echodo loadjava searchctl
emagent loadpsp searchctl.pl
emagent0 loadpspO setsso.pl
emagentdeploy.pl localconfig sqlldr
emagtm lsnodes sqlldrO
emagtm0 lsnrctl sqlplus
emca lsnrctl0 sqlplusO
emctl lxchknlb srvconfig
emctl.pl lxegen srvctl
emctl.pl.template lxinst srvmspawn
emctl.template makerootca.sh sslsetup
emdctl makeserverwlt sslsetup.sh.template
emdctl0 mapsga statusnc
emdfail.command mapsga0 symfind
emdlctl.template maxmem sysresv
emdrollogs.pl maxmemO targetdeploy.pl
emlfail.command mkstore tkprof
emrepdown.pl ncomp tkprofO
emrepdown.sh netca tns2nis
emtgtctl netca_deinst.sh tnslsnr
emtgtctl.template netlaunch tnslsnr0
emtgtctl2 netmgr tnsping
emtgtctl20 nid tnsping0
emutil nidO transx
emutil.template nmb trcasst
emwd nmb0 trcroute
emwd.pl nmei trcroute0
exp nmei0 trcsess
expO nmo tstshm
expdp nmo0 tstshmO
expdpO nmo0 umu
extjob nmocat unzip
extjobO nmocat0 vipca
extjobo nmuct wrap
extjoboO nmupm wrapO
extproc nmupm0 xml
extproc32 nmus xmlcg
extproc32O nmus0 xsl
extprocO ocrcheck xsql
extractlib ocrconfig xvm
fmputl ocrdump zip
$ sqlplus

SQL*Plus: Release 10.1.0.2.0 - Production on Tue Aug 30 15:13:30 2005

Copyright (c) 1982, 2004, Oracle. All rights reserved.

Enter user-name: gavdba
Enter password:
Error accessing PRODUCT_USER_PROFILE
Warning: Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM

We are using the default role.
Please advise.
From
P