Visit Counter

Thursday, July 28, 2016

Install package on linux / Solaris rlwrap



RLWRAP for Linux / Solaris
------------

rlwrap is a 'readline wrapper', a small utility that uses the GNU
readline library to allow the editing of keyboard input for any
command. 

Download from below site

http://utopia.knoware.nl/~hlub/rlwrap/


[root@rac01 rlwrap-0.42]# ./configure

checking build system type... x86_64-unknown-linux-gnu
checking host system type... x86_64-unknown-linux-gnu
checking for a BSD-compatible install... /usr/bin/install -c
checking whether build environment is sane... yes
checking for a thread-safe mkdir -p... /bin/mkdir -p
checking for gawk... gawk
checking whether make sets $(MAKE)... yes
checking whether make supports nested variables... yes
checking whether make sets $(MAKE)... (cached) yes
checking whether build environment is sane... yes
checking for style of include used by make... GNU
checking for gcc... gcc
checking whether the C compiler works... yes
checking for C compiler default output file name... a.out
checking for suffix of executables... 
checking whether we are cross compiling... no
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether gcc accepts -g... yes
checking for gcc option to accept ISO C89... none needed
checking whether gcc understands -c and -o together... yes
checking dependency style of gcc... gcc3
checking how to run the C preprocessor... gcc -E
checking for grep that handles long lines and -e... /bin/grep
checking for egrep... /bin/grep -E
checking for ANSI C header files... yes
checking for sys/types.h... yes
checking for sys/stat.h... yes
checking for stdlib.h... yes
checking for string.h... yes
checking for memory.h... yes
checking for strings.h... yes
checking for inttypes.h... yes
checking for stdint.h... yes
checking for unistd.h... yes
checking minix/config.h usability... no
checking minix/config.h presence... no
checking for minix/config.h... no
checking whether it is safe to define __EXTENSIONS__... yes
checking for gcc... (cached) gcc
checking whether we are using the GNU C compiler... (cached) yes
checking whether gcc accepts -g... (cached) yes
checking for gcc option to accept ISO C89... (cached) none needed
checking whether gcc understands -c and -o together... (cached) yes
checking dependency style of gcc... (cached) gcc3
checking how to run the C preprocessor... gcc -E
checking for perl... /usr/bin/perl
checking for strip... strip
checking for ANSI C header files... (cached) yes
checking for sys/wait.h that is POSIX.1 compatible... yes
checking errno.h usability... yes
checking errno.h presence... yes
checking for errno.h... yes
checking fcntl.h usability... yes
checking fcntl.h presence... yes
checking for fcntl.h... yes
checking libutil.h usability... no
checking libutil.h presence... no
checking for libutil.h... no
checking for stdlib.h... (cached) yes
checking for string.h... (cached) yes
checking sched.h usability... yes
checking sched.h presence... yes
checking for sched.h... yes
checking sys/ioctl.h usability... yes
checking sys/ioctl.h presence... yes
checking for sys/ioctl.h... yes
checking for sys/wait.h... (cached) yes
checking sys/resource.h usability... yes
checking sys/resource.h presence... yes
checking for sys/resource.h... yes
checking stddef.h usability... yes
checking stddef.h presence... yes
checking for stddef.h... yes
checking termios.h usability... yes
checking termios.h presence... yes
checking for termios.h... yes
checking for unistd.h... (cached) yes
checking for stdint.h... (cached) yes
checking time.h usability... yes
checking time.h presence... yes
checking for time.h... yes
checking getopt.h usability... yes
checking getopt.h presence... yes
checking for getopt.h... yes
checking regex.h usability... yes
checking regex.h presence... yes
checking for regex.h... yes
checking curses.h usability... yes
checking curses.h presence... yes
checking for curses.h... yes
checking termcap.h usability... yes
checking termcap.h presence... yes
checking for termcap.h... yes
checking for term.h... yes
checking for ncurses/term.h... yes
checking argument type of tputs putc function... int
checking whether your getopt() correctly understands double colons in option string... yes
checking for an ANSI C-conforming const... yes
checking for pid_t... yes
checking whether time.h and sys/time.h may both be included... yes
checking whether gcc needs -traditional... no
checking return type of signal handlers... void
checking for getopt_long... yes
checking for getopt_long... (cached) yes
checking for isastream... yes
checking for mkstemps... yes
checking for pselect... yes
checking for putenv... yes
checking for readlink... yes
checking for sched_yield... yes
checking for setenv... yes
checking for setitimer... yes
checking for setsid... yes
checking for setrlimit... yes
checking for sigaction... yes
checking for snprintf... yes
checking for strlcpy... no
checking for strlcat... no
checking for strnlen... yes
checking for system... yes
checking for openpty in -lutil... yes
checking for openpty... yes
checking for getpty... no
checking for grantpt... yes
checking for unlockpt... yes
checking for getpt... yes
checking for pty/tty type... checking pty.h usability... yes
checking pty.h presence... yes
checking for pty.h... yes
OPENPTY
configure: checking for pty ranges...
checking for tgetent... no
checking for tgetent in -ltinfo... yes
checking for readline in -lreadline... yes
checking for tigetnum... yes
checking readline/readline.h usability... yes
checking readline/readline.h presence... yes
checking for readline/readline.h... yes
checking whether your readline headers know about rl_set_screen_size... yes
checking whether your readline library knows about rl_set_screen_size... checking for rl_set_screen_size... yes
checking whether your readline knows about rl_variable_value... yes
checking whether your readline knows about rl_readline_version... yes
Will rlwrap find command's working directory under /proc/<commands pid>/cwd? let's see...
checking for /proc/29459/cwd/configure.ac... yes
checking whether we can find command line under <opt_proc_mountpoint>/<pid>/cmdline and mirror it by overwriting our own *argv... no


checking that generated files are newer than configure... done
checking that generated files are newer than configure... done
configure: creating ./config.status
config.status: creating Makefile
config.status: creating filters/Makefile
config.status: creating doc/Makefile
config.status: creating src/Makefile
config.status: creating doc/rlwrap.man
config.status: creating config.h
config.status: executing depfiles commands

Now do:
    make (or gmake)  to build rlwrap
    make check       for instructions how to test it
    make install     to install it




[root@rac01 rlwrap-0.42]# make
make  all-recursive
make[1]: Entering directory `/ora/Desktop/rlwrap-0.42'
Making all in doc
make[2]: Entering directory `/ora/Desktop/rlwrap-0.42/doc'
sed -e 's#@DATADIR@#/usr/local/share#'  rlwrap.man > rlwrap.1
make[2]: Leaving directory `/ora/Desktop/rlwrap-0.42/doc'
Making all in src
make[2]: Entering directory `/ora/Desktop/rlwrap-0.42/src'
gcc -DHAVE_CONFIG_H -I. -I..    -DDATADIR=\"/usr/local/share\"  -g -O2 -MT main.o -MD -MP -MF .deps/main.Tpo -c -o main.o main.c
mv -f .deps/main.Tpo .deps/main.Po
gcc -DHAVE_CONFIG_H -I. -I..    -DDATADIR=\"/usr/local/share\"  -g -O2 -MT signals.o -MD -MP -MF .deps/signals.Tpo -c -o signals.o signals.c
mv -f .deps/signals.Tpo .deps/signals.Po
gcc -DHAVE_CONFIG_H -I. -I..    -DDATADIR=\"/usr/local/share\"  -g -O2 -MT readline.o -MD -MP -MF .deps/readline.Tpo -c -o readline.o readline.c
mv -f .deps/readline.Tpo .deps/readline.Po
gcc -DHAVE_CONFIG_H -I. -I..    -DDATADIR=\"/usr/local/share\"  -g -O2 -MT pty.o -MD -MP -MF .deps/pty.Tpo -c -o pty.o pty.c
mv -f .deps/pty.Tpo .deps/pty.Po
gcc -DHAVE_CONFIG_H -I. -I..    -DDATADIR=\"/usr/local/share\"  -g -O2 -MT completion.o -MD -MP -MF .deps/completion.Tpo -c -o completion.o completion.c
mv -f .deps/completion.Tpo .deps/completion.Po
gcc -DHAVE_CONFIG_H -I. -I..    -DDATADIR=\"/usr/local/share\"  -g -O2 -MT term.o -MD -MP -MF .deps/term.Tpo -c -o term.o term.c
mv -f .deps/term.Tpo .deps/term.Po
gcc -DHAVE_CONFIG_H -I. -I..    -DDATADIR=\"/usr/local/share\"  -g -O2 -MT ptytty.o -MD -MP -MF .deps/ptytty.Tpo -c -o ptytty.o ptytty.c
mv -f .deps/ptytty.Tpo .deps/ptytty.Po
gcc -DHAVE_CONFIG_H -I. -I..    -DDATADIR=\"/usr/local/share\"  -g -O2 -MT utils.o -MD -MP -MF .deps/utils.Tpo -c -o utils.o utils.c
mv -f .deps/utils.Tpo .deps/utils.Po
gcc -DHAVE_CONFIG_H -I. -I..    -DDATADIR=\"/usr/local/share\"  -g -O2 -MT string_utils.o -MD -MP -MF .deps/string_utils.Tpo -c -o string_utils.o string_utils.c
mv -f .deps/string_utils.Tpo .deps/string_utils.Po
gcc -DHAVE_CONFIG_H -I. -I..    -DDATADIR=\"/usr/local/share\"  -g -O2 -MT malloc_debug.o -MD -MP -MF .deps/malloc_debug.Tpo -c -o malloc_debug.o malloc_debug.c
mv -f .deps/malloc_debug.Tpo .deps/malloc_debug.Po
gcc -DHAVE_CONFIG_H -I. -I..    -DDATADIR=\"/usr/local/share\"  -g -O2 -MT filter.o -MD -MP -MF .deps/filter.Tpo -c -o filter.o filter.c
mv -f .deps/filter.Tpo .deps/filter.Po
gcc -DDATADIR=\"/usr/local/share\"  -g -O2   -o rlwrap main.o signals.o readline.o pty.o completion.o term.o ptytty.o utils.o string_utils.o malloc_debug.o filter.o  -lutil  -lreadline -ltinfo
make[2]: Leaving directory `/ora/Desktop/rlwrap-0.42/src'
Making all in filters
make[2]: Entering directory `/ora/Desktop/rlwrap-0.42/filters'
make[2]: Nothing to be done for `all'.
make[2]: Leaving directory `/ora/Desktop/rlwrap-0.42/filters'
make[2]: Entering directory `/ora/Desktop/rlwrap-0.42'
make[2]: Leaving directory `/ora/Desktop/rlwrap-0.42'
make[1]: Leaving directory `/ora/Desktop/rlwrap-0.42'
[root@rac01 rlwrap-0.42]# pwd





$ alias rl="rlwrap /ora/app/product/12.1.0/dbhome_1/bin/sqlplus / as sysdba"

$ r1

SQL> select * from cat;





Solaris Sparc 64-bit

Download Packages from below site.

http://ftp.telfort.nl/pub/mirror/sunfreeware/sparc/

# /tmp/

readline-6.2-sol10-sparc-local.gz
rlwrap-0.37-sol10-sparc-local.gz

#gunzip readline-6.2-sol10-sparc-local.gz  
#gunzip rlwrap-0.37-sol10-sparc-local.gz

readline-6.2-sol10-sparc-local 
rlwrap-0.37-sol10-sparc-local

#pkgadd -d readline-6.2-sol10-sparc-local
# pkgadd -d  rlwrap-0.37-sol10-sparc-local


root@afi-ssaerp2n:/tmp/test# pkgadd -d rlwrap-0.37-sol10-sparc-local

The following packages are available:
  1  SMCrlwrp     rlwrap
                  (sparc) 0.37

Select package(s) you wish to process (or 'all' to process
all packages). (default: all) [?,??,q]:

Processing package instance <SMCrlwrp> from </tmp/test/rlwrap-0.37-sol10-sparc-local>

rlwrap(sparc) 0.37
Chet Ramey, Hans Lub, et al
Using </usr/local> as the package base directory.
## Processing package information.
## Processing system information.
## Verifying disk space requirements.
## Checking for conflicts with packages already installed.

The following files are already installed on the system and are being
used by another package:
  /usr/local/bin <attribute change only>
  /usr/local/bin/rlwrap
  /usr/local/share <attribute change only>
  /usr/local/share/rlwrap <attribute change only>

Do you want to install these conflicting files [y,n,?,q] y
## Checking for setuid/setgid programs.

Installing rlwrap as <SMCrlwrp>

## Installing part 1 of 1.
/usr/local/bin/rlwrap
/usr/local/doc/rlwrap/AUTHORS
/usr/local/doc/rlwrap/BUGS
/usr/local/doc/rlwrap/COPYING
/usr/local/doc/rlwrap/ChangeLog
/usr/local/doc/rlwrap/INSTALL
/usr/local/doc/rlwrap/NEWS
/usr/local/doc/rlwrap/README
/usr/local/doc/rlwrap/TODO
/usr/local/doc/rlwrap/doc/Makefile
/usr/local/doc/rlwrap/doc/Makefile.am
/usr/local/doc/rlwrap/doc/Makefile.in
/usr/local/doc/rlwrap/doc/rlwrap.1
/usr/local/doc/rlwrap/doc/rlwrap.man
/usr/local/doc/rlwrap/doc/rlwrap.man.in
/usr/local/share/man/man1/rlwrap.1
/usr/local/share/rlwrap/completions/coqtop
/usr/local/share/rlwrap/completions/testclient
/usr/local/share/rlwrap/filters/README
/usr/local/share/rlwrap/filters/RlwrapFilter.3pm
/usr/local/share/rlwrap/filters/RlwrapFilter.pm
/usr/local/share/rlwrap/filters/censor_passwords
/usr/local/share/rlwrap/filters/count_in_prompt
/usr/local/share/rlwrap/filters/ftp_filter
/usr/local/share/rlwrap/filters/history_format
/usr/local/share/rlwrap/filters/listing
/usr/local/share/rlwrap/filters/logger
/usr/local/share/rlwrap/filters/null
/usr/local/share/rlwrap/filters/paint_prompt
/usr/local/share/rlwrap/filters/pipeline
/usr/local/share/rlwrap/filters/pipeto
/usr/local/share/rlwrap/filters/scrub_prompt
/usr/local/share/rlwrap/filters/simple_macro
/usr/local/share/rlwrap/filters/template
/usr/local/share/rlwrap/filters/unbackspace
[ verifying class <none> ]

Installation of <SMCrlwrp> was successful.
root@afi-ssaerp2n:/tmp/test# ls
readline-6.2-sol10-sparc-local     rlwrap-0.37-sol10-sparc-local
readline-6.2-sol10-sparc-local.gz  rlwrap-0.37-sol10-sparc-local.gz


root@afi-ssaerp2n:/tmp/test# pkgadd -d readline-6.2-sol10-sparc-local

The following packages are available:
  1  SMCreadl     readline
                  (sparc) 6.2

Select package(s) you wish to process (or 'all' to process
all packages). (default: all) [?,??,q]:

Processing package instance <SMCreadl> from </tmp/test/readline-6.2-sol10-sparc-local>

readline(sparc) 6.2
Lionel Cons et al
Using </usr/local> as the package base directory.
## Processing package information.
## Processing system information.
   3 package pathnames are already properly installed.
## Verifying disk space requirements.
## Checking for conflicts with packages already installed.

The following files are already installed on the system and are being
used by another package:
  /usr/local/include <attribute change only>
  /usr/local/include/readline <attribute change only>
  /usr/local/include/readline/chardefs.h
  /usr/local/include/readline/history.h
  /usr/local/include/readline/keymaps.h
  /usr/local/include/readline/readline.h
  /usr/local/include/readline/rlconf.h
  /usr/local/include/readline/rlstdc.h
  /usr/local/include/readline/rltypedefs.h
  /usr/local/include/readline/tilde.h
  /usr/local/lib <attribute change only>
  /usr/local/lib/libhistory.a
  /usr/local/lib/libhistory.so
  /usr/local/lib/libhistory.so.5
  /usr/local/lib/libreadline.a
  /usr/local/lib/libreadline.so
  /usr/local/lib/libreadline.so.5

Do you want to install these conflicting files [y,n,?,q] y
## Checking for setuid/setgid programs.

Installing readline as <SMCreadl>

## Installing part 1 of 1.
/usr/local/doc/readline/CHANGELOG
/usr/local/doc/readline/CHANGES
/usr/local/doc/readline/COPYING
/usr/local/doc/readline/INSTALL
/usr/local/doc/readline/MANIFEST
/usr/local/doc/readline/NEWS
/usr/local/doc/readline/README
/usr/local/doc/readline/USAGE
/usr/local/doc/readline/doc/Makefile
/usr/local/doc/readline/doc/Makefile.in
/usr/local/doc/readline/doc/fdl.texi
/usr/local/doc/readline/doc/history.0
/usr/local/doc/readline/doc/history.3
/usr/local/doc/readline/doc/history.dvi
/usr/local/doc/readline/doc/history.html
/usr/local/doc/readline/doc/history.info
/usr/local/doc/readline/doc/history.pdf
/usr/local/doc/readline/doc/history.ps
/usr/local/doc/readline/doc/history.texi
/usr/local/doc/readline/doc/history_3.ps
/usr/local/doc/readline/doc/hstech.texi
/usr/local/doc/readline/doc/hsuser.texi
/usr/local/doc/readline/doc/readline.0
/usr/local/doc/readline/doc/readline.3
/usr/local/doc/readline/doc/readline.dvi
/usr/local/doc/readline/doc/readline.html
/usr/local/doc/readline/doc/readline.info
/usr/local/doc/readline/doc/readline.pdf
/usr/local/doc/readline/doc/readline.ps
/usr/local/doc/readline/doc/readline_3.ps
/usr/local/doc/readline/doc/rlman.texi
/usr/local/doc/readline/doc/rltech.texi
/usr/local/doc/readline/doc/rluser.texi
/usr/local/doc/readline/doc/rluserman.dvi
/usr/local/doc/readline/doc/rluserman.html
/usr/local/doc/readline/doc/rluserman.info
/usr/local/doc/readline/doc/rluserman.pdf
/usr/local/doc/readline/doc/rluserman.ps
/usr/local/doc/readline/doc/rluserman.texi
/usr/local/doc/readline/doc/texi2dvi
/usr/local/doc/readline/doc/texi2html
/usr/local/doc/readline/doc/texinfo.tex
/usr/local/doc/readline/doc/version.texi
/usr/local/include/readline/chardefs.h
/usr/local/include/readline/history.h
/usr/local/include/readline/keymaps.h
/usr/local/include/readline/readline.h
/usr/local/include/readline/rlconf.h
/usr/local/include/readline/rlstdc.h
/usr/local/include/readline/rltypedefs.h
/usr/local/include/readline/tilde.h
/usr/local/lib/libhistory.a
/usr/local/lib/libhistory.so <symbolic link>
/usr/local/lib/libhistory.so.5
/usr/local/lib/libhistory.so.6
/usr/local/lib/libreadline.a
/usr/local/lib/libreadline.so <symbolic link>
/usr/local/lib/libreadline.so.4
/usr/local/lib/libreadline.so.5
/usr/local/lib/libreadline.so.6
/usr/local/share/info/history.info
/usr/local/share/info/readline.info
/usr/local/share/info/rluserman.info
/usr/local/share/man/man3/history.3
/usr/local/share/man/man3/readline.3
[ verifying class <none> ]

Installation of <SMCreadl> was successful.
root@afi-ssaerp2n:/tmp/test#


$ alias rlsql="/usr/local/bin/rlwrap /ora/app/oracle/product/11.2.0/dbhome_1/bin/sqlplus /nolog"

$ rlsql

$alias sql="/usr/local/bin/rlwrap /ora/app/oracle/product/11.2.0/dbhome_1/bin/sqlplus / as sysdba"

$ sql

Wednesday, July 27, 2016

Creating EM repository on Cluster Server




-bash-4.1$ ./emca -config dbcontrol db -repos recreate



STARTED EMCA at Jul 27, 2016 1:55:15 PM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle.  All rights reserved.

Enter the following information:
Database SID: ssaerp
Listener port number: 1521
Listener ORACLE_HOME [ /ora/app/oracle/product/11.2.0/dbhome_1 ]:
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
-----------------------------------------------------------------

You have specified the following settings

Database ORACLE_HOME ................ /ora/app/oracle/product/11.2.0/dbhome_1

Local hostname ................ afi-ssaerp2n
Listener ORACLE_HOME ................ /ora/app/oracle/product/11.2.0/dbhome_1
Listener port number ................ 1521
Database SID ................ ssaerp
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............

-----------------------------------------------------------------
----------------------------------------------------------------------
WARNING : While repository is dropped the database will be put in quiesce mode.
----------------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Jul 27, 2016 1:55:36 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /ora/app/oracle/cfgtoollogs/emca/ssaerp/emca_2016_07_27_13_55_15.log                                                            .
Jul 27, 2016 1:55:36 PM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
WARNING: ORA-12541: TNS:no listener

Jul 27, 2016 1:55:36 PM oracle.sysman.emcp.EMConfig perform
SEVERE:

Database connection through listener failed. Fix the error and run EM Configuration Assistant again.

Some of the possible reasons may be:

1) Listener port 1521 provided is incorrect. Provide the correct port.
2) Listener is not up. Start the Listener.
3) Database service ssaerp is not registered with listener. Register the database service.
4) Listener is up on physical host and ORACLE_HOSTNAME environment variable is set to virtual host. Unset OR                                                            ACLE_HOSTNAME environment variable.


5) Listener is up on virtual host. Set environment variable ORACLE_HOSTNAME=<virtual host>.


6) /etc/hosts does not have correct entry for hostname.

Refer to the log file at /ora/app/oracle/cfgtoollogs/emca/ssaerp/emca_2016_07_27_13_55_15.log for more detai                                                            ls.
Could not complete the configuration. Refer to the log file at ora/app/oracle/cfgtoollogs/emca/ssaerp/emca_                                               2016_07_27_13_55_15.log for more details.



Define Virtual name of host


-bash-4.1$ ORACLE_HOSTNAME=lh-ora-rs
-bash-4.1$ export ORACLE_HOSTNAME




-bash-4.1$ ./emca -config dbcontrol db -repos recreate



STARTED EMCA at Jul 27, 2016 1:56:15 PM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle.  All rights reserved.

Enter the following information:
Database SID: ssaerp
Listener port number: 1521
Listener ORACLE_HOME [ /ora/app/oracle/product/11.2.0/dbhome_1 ]:
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
-----------------------------------------------------------------

You have specified the following settings

Database ORACLE_HOME ................ /ora/app/oracle/product/11.2.0/dbhome_1

Local hostname ................ lh-ora-rs
Listener ORACLE_HOME ................ /ora/app/oracle/product/11.2.0/dbhome_1
Listener port number ................ 1521
Database SID ................ ssaerp
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............

-----------------------------------------------------------------
----------------------------------------------------------------------
WARNING : While repository is dropped the database will be put in quiesce mode.
----------------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Jul 27, 2016 1:56:34 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /ora/app/oracle/cfgtoollogs/emca/ssaerp/emca_2016_07_27_13_56_15.log                                                            .
Jul 27, 2016 1:56:35 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Jul 27, 2016 1:59:08 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Jul 27, 2016 1:59:08 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Jul 27, 2016 2:05:00 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Jul 27, 2016 2:05:03 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Jul 27, 2016 2:06:11 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Jul 27, 2016 2:06:13 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Jul 27, 2016 2:06:18 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Jul 27, 2016 2:06:18 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Jul 27, 2016 2:06:34 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Jul 27, 2016 2:06:34 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://lh-ora-rs:1158/em <<<<<<<<<<<
Jul 27, 2016 2:06:36 PM oracle.sysman.emcp.EMDBPostConfig invoke
WARNING:
************************  WARNING  ************************

Management Repository has been placed in secure mode wherein Enterprise Manager data will be encrypted.  The encryption key has been placed in the                       file: /ora/app/oracle/product/11.2.0/dbhome_1/lh-ora-rs_ssaerp/sysman/config/emkey.ora. Ensure this file is backed up as the encrypted data will                       become unusable if this file is lost.

***********************************************************
Enterprise Manager configuration completed successfully
FINISHED EMCA at Jul 27, 2016 2:06:36 PM
-bash-4.1$

Dbcontrol Repository already exists. Fix the error(s) and run EM Config




-bash-4.1$ ./emca -config dbcontrol db -repos create

STARTED EMCA at Jul 27, 2016 2:27:47 PM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle.  All rights reserved.

Enter the following information:
Database SID: ssaerp
Listener port number: 1521
Listener ORACLE_HOME [ /ora/app/oracle/product/11.2.0/dbhome1104 ]:
Password for SYS user:
Password for DBSNMP user:
Jul 27, 2016 2:34:12 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
WARNING: ORA-01017: invalid username/password; logon denied

Jul 27, 2016 2:34:20 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly

Jul 27, 2016 2:41:14 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
WARNING: ORA-01017: invalid username/password; logon denied

Invalid username/password.
Password for DBSNMP user:
Password for SYSMAN user:
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
-----------------------------------------------------------------

You have specified the following settings

Database ORACLE_HOME ................ /ora/app/oracle/product/11.2.0/dbhome1104

Local hostname ................ afi-ssaerp
Listener ORACLE_HOME ................ /ora/app/oracle/product/11.2.0/dbhome1104
Listener port number ................ 1521
Database SID ................ ssaerp
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Jul 27, 2016 2:42:50 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /ora/app/1104/oracle/cfgtoollogs/emca/ss                                                                                        aerp/emca_2016_07_27_14_27_46.log.
Jul 27, 2016 2:42:51 PM oracle.sysman.emcp.DatabaseChecks performReposChecks
SEVERE: Dbcontrol Repository already exists.  Fix the error(s) and run EM Config                             Duration Assistant again in standalone mode.




Solution




-bash-4.1$ ./emca -config dbcontrol db -repos recreate

STARTED EMCA at Jul 27, 2016 2:51:34 PM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle.  All rights reserved.

Enter the following information:
Database SID: ssaerp
Listener port number: 1521
Listener ORACLE_HOME [ /ora/app/oracle/product/11.2.0/dbhome1104 ]:
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
-----------------------------------------------------------------

You have specified the following settings

Database ORACLE_HOME ................ /ora/app/oracle/product/11.2.0/dbhome1104

Local hostname ................ afi-ssaerp
Listener ORACLE_HOME ................ /ora/app/oracle/product/11.2.0/dbhome1104
Listener port number ................ 1521
Database SID ................ ssaerp
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............

-----------------------------------------------------------------
----------------------------------------------------------------------
WARNING : While repository is dropped the database will be put in quiesce mode.
----------------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Jul 27, 2016 2:51:59 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /ora/app/1104/oracle/cfgtoollogs/emca/ssaerp/emca_2016_07_27_14_51_33.log.
Jul 27, 2016 2:52:00 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Jul 27, 2016 2:53:55 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Jul 27, 2016 2:53:56 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Jul 27, 2016 2:58:38 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Jul 27, 2016 2:58:41 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Jul 27, 2016 3:00:12 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Jul 27, 2016 3:00:13 PM oracle.sysman.emcp.ParamsManager getLocalListener
WARNING: Error retrieving listener for afi-ssaerp
Jul 27, 2016 3:00:14 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Jul 27, 2016 3:00:24 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Jul 27, 2016 3:00:24 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Jul 27, 2016 3:00:53 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Jul 27, 2016 3:00:54 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://afi-ssaerp:1158/em <<<<<<<<<<<
Jul 27, 2016 3:00:56 PM oracle.sysman.emcp.EMDBPostConfig invoke
WARNING:
************************  WARNING  ************************

Management Repository has been placed in secure mode wherein Enterprise Manager data will be encrypted.  The encryption key has been placed in the file: /ora/app/oracle/product/11.2.0/dbhome1104/afi-ssaerp_ssaerp/sysman/config/emkey.ora. Ensure this file is backed up as the encrypted data will become unusable if this file is lost.

***********************************************************
Enterprise Manager configuration completed successfully
FINISHED EMCA at Jul 27, 2016 3:00:56 PM


-bash-4.1$


Oracle Enterprise Manager failed to start, OC4J Configuration issue. Configure Enterprise Manager Database Control Manually with Enterprise Manager Configuration Assistant

You can drop the EM Repository

--------------------------------

[oracle@localhost ~]$ emca -deconfig dbcontrol db -repos drop
STARTED EMCA at Aug 5, 2013 7:54:35 PM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Enter the following information:
Database SID: fmw
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:

Do you wish to continue? [yes(Y)/no(N)]: Y
Aug 5, 2013 7:54:54 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/fmw/emca_2013_08_05_19_54_34.log.
Aug 5, 2013 7:54:55 PM oracle.sysman.emcp.EMDBPreConfig performDeconfiguration
WARNING: EM is not configured for this database. No EM-specific actions can be performed.
Aug 5, 2013 7:54:55 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Aug 5, 2013 7:57:04 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Enterprise Manager configuration completed successfully
FINISHED EMCA at Aug 5, 2013 7:57:04 PM

Now, let's configure it again


Create new for EM repository
---------------------------------------

[oracle@localhost ~]$ emca -config dbcontrol db -repos create
STARTED EMCA at Aug 5, 2013 7:58:22 PM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Enter the following information:
Database SID: fmw
Listener port number: 1521
Listener ORACLE_HOME [ /u01/app/oracle/product/11.2.0/dbhome_1 ]:
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
-----------------------------------------------------------------

You have specified the following settings
Database ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/dbhome_1
Local hostname ................ localhost.localhost.com
Listener ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/dbhome_1
Listener port number ................ 1521
Database SID ................ fmw
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
-----------------------------------------------------------------

Do you wish to continue? [yes(Y)/no(N)]: Y
Aug 5, 2013 7:58:53 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/fmw/emca_2013_08_05_19_58_21.log.
Aug 5, 2013 7:58:54 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Aug 5, 2013 8:05:56 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Aug 5, 2013 8:06:02 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Aug 5, 2013 8:07:14 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Aug 5, 2013 8:07:17 PM oracle.sysman.emcp.util.DBControlUtil configureSoftwareLib
INFO: Software library configured successfully.
Aug 5, 2013 8:07:17 PM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Deploying Provisioning archives ...
Aug 5, 2013 8:08:07 PM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Provisioning archives deployed successfully.
Aug 5, 2013 8:08:07 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Aug 5, 2013 8:08:53 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Aug 5, 2013 8:08:53 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Aug 5, 2013 8:10:16 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Aug 5, 2013 8:10:17 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://localhost.localhost.com:5500/em <<<<<<<<<<<
Aug 5, 2013 8:10:28 PM oracle.sysman.emcp.EMDBPostConfig invoke
WARNING:
************************ WARNING  ************************

Management Repository has been placed in secure mode wherein Enterprise Manager data will be encrypted.  The encryption key has been placed in the file: /u01/app/oracle/product/11.2.0/dbhome_1/localhost.localhost.com_fmw/sysman/config/emkey.ora.   Please ensure this file is backed up as the encrypted data will become unusable if this file is lost.

***********************************************************
Enterprise Manager Configuration completed successfully
FINISHED EMCA at Aug 5, 2013 8:10:28 PM

[oracle@localhost ~]$

Wednesday, July 13, 2016

Error with a file name containing parentheses



Solaris 11


When I tried to change file name from abc.file(1).zip to xyz.zip
It's says syntax error I am using Solaris 11.3 Sparc


# mv abc.file(1).zip xyz.zip

bash: syntax error near unexpected token '('



Solution:


The entire file name does not need quoting () do.


# mv 'abc.file(1).zip'  xyz.zip


The file just loaded does not appear to be executable




Solaris 11 installation on Sparc T4-2 Server getting below error after (init 0) OK Prompt


OK> boot cdrom

SPARC Enterprise T4-2 Server, using Domain console
Copyright (c) 1998, 2012, Oracle and/or its affiliates. All rights reserved.
Copyright (c) 2012, Oracle and/or its affiliates and Fujitsu Limited. All rights reserved.
OpenBoot 4.24.15, 49152 MB memory installed, Serial #94022600.
Ethernet address 0:41:28:2:15:9v, Host ID: 10202155z.



Rebooting with command: boot kernel/sparcv9/unix
Boot device: /pci@0,600000/pci@0/pci@8/pci@0/scsi@1/disk@0  File and args: kernel/sparcv9/unix

Can't open kernel/sparcv9/unix
ERROR: FCode Aborted.

Warning: Fcode sequence resulted in a net stack depth change of 1
Evaluating:

Evaluating:
The file just loaded does not appear to be executable.


{0} ok


Solution:




















OK>  devalias

Select DVD option













OK> boot dvd











Oracle Solaris Installation on Sparc T4-2 Server


Solaris 11.3 Installation on Sparc T4-2 Server



I getting error while booting from Solaris 11 CD..

# init 0  (Get OK prompt)

OK> boot cdrom

Boot device: /pci@1e,600000/ide@d/disk@0,0:a File and args: device 
can't open device 
Warning: Fcode sequence resulted in a net stack depth change of 1 Evaluating: 
Evaluating: 
the file just loaded does not appear to be executable.



Solution:




















OK devalias

Select dvd option













OK> boot dvd





















Please enter a number (1) 1












































































































































































Create Raid 5 for data


zpool create poolname raidz disk1 disk2 disk3

Example


# zpool create datapool raidz c0t0d0 c0t1d0 c0t2d0 c0t3d0




Create file systems

/ora_dat
/ora_idx
/ora
/ssaerp
/ora_temp


#   root@afi-drsvr:/ora_temp# zfs create datapool/backup2

#   root@afi-drsvr:/ora_temp# zfs set mountpoint=/backup2  datapool/backup2
 

  #  root@afi-drsvr:/ora_temp# zfs list

  NAME                              USED  AVAIL  REFER  MOUNTPOINT
  datapool                               467K  1.60T  46.4K  /datapool
  datapool/backup2                 44.9K  1.60T  44.9K  /backup2
  datapool/ora                         44.9K  1.60T  44.9K  /ora
  datapool/ora_dat                 44.9K  1.60T  44.9K  /ora_dat
  datapool/ora_idx                 44.9K  1.60T  44.9K  /ora_idx
  datapool/ora_temp                44.9K  1.60T  44.9K  /ora_temp
  datapool/ssaerp                   44.9K  1.60T  44.9K  /ssaerp
  rpool                                    73.0G   474G  73.5K  /rpool
  rpool/ROOT                        3.11G   474G    31K  legacy
  rpool/ROOT/solaris               3.11G   474G  2.89G  /
  rpool/ROOT/solaris/var            224M   474G   221M  /var
  rpool/VARSHARE                   2.53M   474G  2.44M  /var/share
  rpool/VARSHARE/pkg                 63K   474G    32K  /var/share/pkg
  rpool/VARSHARE/pkg/repositories    31K   474G    31K  /var/share/pkg/repo                             sitories
   35  rpool/VARSHARE/zones               31K   474G    31K  /system/zones
   36  rpool/dump                                     65.8G   476G  63.8G  -
   37  rpool/export                                    97.5K   474G    32K  /export
   38  rpool/export/home                          65.5K   474G    32K  /export/home
   39  rpool/export/home/admin              33.5K   474G  33.5K  /export/home/admin
   40  rpool/swap                                     4.13G   474G  4.00G  -
 

  root@afi-drsvr:/ora_temp#


Download from Oracle site Repository

https://www.oracle.com/solaris/solaris11/downloads/local-repository-downloads.html

Create folder....repo1


# root@afi-drsvr:/repo# ls

   COPYRIGHT                         sol-11_3-repo_1of5.zip
   install-repo.ksh                       sol-11_3-repo_2of5.zip
   NOTICES                               sol-11_3-repo_3of5.zip
   pkg5.repository                       sol-11_3-repo_4of5.zip
   README-repo-iso.txt            sol-11_3-repo_5of5.zip
   README-zipped-repo.txt      sol-11_3-repo_md5sums.txt
   readme.txt


  106  root@afi-drsvr:/repo# ls -l

  107  total 16478173
  108  -rw-r--r--   1 admin    staff       3440 Jul 13 14:52 COPYRIGHT
  109  -rw-r--r--   1 admin    staff      11612 Jul 13 14:52 install-.zip
  110  -rw-r--r--   1 admin    staff    1717187368 Jul 13 14:54 sol-11_3-repo_3of5.zip
  111  -rw-r--r--   1 admin    staff    1871913207 Jul 13 14:55 sol-11_3-repo_4of5.zip
  112  -rw-r--r--   1 admin    staff    1570373423 Jul 13 14:56 sol-11_3-repo_5of5.zip
  113  -rw-r--r--   1 admin    staff        285 Jul 13 14:56 sol-11_3-repo_md5sums.txt


Extracting Repository  of Solaris 11.3


root@afi-drsvr:/repo# ./install-repo.ksh -d /repo1/ -v

Using sol-11_3-repo download.
Uncompressing sol-11_3-repo_1of5.zip...done.
Uncompressing sol-11_3-repo_2of5.zip...done.
Uncompressing sol-11_3-repo_3of5.zip...done.
Uncompressing sol-11_3-repo_4of5.zip...done.
Uncompressing sol-11_3-repo_5of5.zip...done.
Repository can be found in /repo1/.
Initiating repository verification.
pkg://solaris/group/prerequisite/oracle/oracle-rdbms-server-12-1-preinstall 1442                                   pkg://solaris/system/domain-service-processor-protocol/sparc-enterprise 1774/548                               pkg://solaris/consolidation/instantclient/instantclient-incorporation 3066/5480                                     pkg://solaris/group/prerequisite/oracle/oracle-ebs-server-R12-preinstall 3383/54                                   pkg://solaris/system/kernel/dynamic-reconfiguration/ultra-enterprise-10000 3911/                                 pkg://solaris/group/prerequisite/oracle/oracle-rdbms-server-12cR1-preinstall 416



Publish Repository on repo1 folder

Installing Repository

# pkg install solaris-desktop






















For Xmanager Configuration to access solaris 11

# vi  /etc/gdm/custom.conf

[xdmcp]
Enable=true   (By default false)


# inetadm -e xvnc-inetd

# svcadm restart svc:/application/graphical-login/gdm:default



Root Access by default in Solaris 11

# vi /etc/ssh/sshd_config

PermitRootLgin Yes


# vi /etc/default/login

CONSOLE=/dev/Console

# svcadm restart svc:/network/ssh:default



Oracle Packages for installation oracle software




 # pkg install pkg://solaris/developer/build/make


  # pkg install pkg://solaris/developer/assembler