Search results for query: *

Hello All I have five servers in my DB2 PureScale clusters as shown in the attached picture. Facility Servers F1, F2, and Node Servers N1, N2, N3. Supposing I want to increase the storage according to my research as follows: 1. List existing filesystems $ db2cluster -cfs -list -filesystem 2...

Hello All Can you help me with concatenation of BIG INT <select distinct CASE when pl.firstname IS NULL then '' else pl.firstname END as 'First Name', CASE when pl.lastname IS NULL then '' else pl.lastname END as 'Last Name', CASE when pl.playerId IS NULL then '' else pl.playerId END as...

Hello Can anyone point out what is wrong with my powershell not executed from Task Scheduler. Though manual execution works. Here is the content of the script: However, in Task Scheduler it does not work even though the history says successful below is the General Tab in Scheduler below is...

Hello All, I am trying to set up backups of multiple databases a multi-server environment while using Central Management Server and Server Groups. After I made IT-D-ADMIN2\SRVCEMNGR as my Master, in a Multi-server Administration from the SQL Server Agent, I was successful in adding and...

Hello I am new to a new organization - Las Vegas Casino as a SQL Server DBA to the organization. The databases are small as the organization is relatively small compared to others around here. Based on the fact that there is a lot of OLTP online transaction processing occurring everyday. Sorry...

Hello All, I was wondering if you can give me a lead or idea on how can perform the process described below: 1) Source (SQL Server databases ) 3) Target ( Azure Data Lake.) 4) The operation is to capture the DDL & DML changes from Source(1) databases and copy the changes to Target(2). Thanks...

Hello iN oRACLE 11G database , I am trying to start a workload load client after calibration: wrc sys/xxxxxxx$@enduserb mode=calibrate replaydir=/orahome/app/oracle/home/db_replay_capture Workload Replay Client: Release 11.2.0.4.0 - Production on Fri Apr 20 12:34:40 2018 Copyright (c) 1982...

Hello All, In a Korn Shell, I am trying to populate database table with the the contents of flat file. Here is the sample of my flat file and its contents: sample_file.txt - source: "\"GRP\".\"GEC_CLAIM_EVENT_SRI_PROCESS\"" target: "\"GRP\".\"GEC_CLAIM_EVENT_SRI_PROCESS\"" rsid...

Hello All, How can I hide the password on line 9 in the script below with using login as sysdba? #!/bin/ksh dbname=mydbname export ORACLE_SID=$dbname export ORACLE_HOME=/orahome/app/oracle/product/10.2.05/ . /usr/sislocal/$dbname/to$dbname #log into database sqlplus -s splex/password <<...

Hello All, The following routine is to Check the input file: if empty die and send error. OR if contains ORA-error die and send error. OR if empty die and send "no mismatch in tables" message. Please Help suggest how to achieve the last option lstoftables=`cat rowcount_sfgm_gtxs.txt`...

Hello Once Again, I am putting finishing touches to my script. Basically, it is functioning now, however, I wanted to additionally an if statement saying if there is no tables to be processed, the script should die, and exit with email saying there is no table to be repaired. The if statement...

Hello All, Can you help review this with a fresh set of eyes. Not sure where the error is, but the output error is: E_PIN ESS_USER ESS_USER_SER_ROLE ./spx_repair_sfgi_2.sh[37]: syntax error at line 55 : `<<' unmatched Below is the code in full: #!/bin/ksh dbname=sfgi export...

Hello All, I stumbled on some scripts from <https://github.com/oraclesean/shareplex> to help automate compare & repair. This compare& repair process happens in Control Panel of a third party apps Shareplex. The shell scripts suppose to be used for RAC nodes. However, we are using it to compare...

Hello All, I am wondering if anyone has upgraded a 10g database to 11g via a response file before. If so, can you give a sample of such response file, where to store it and which command to use. Thanks in advance and your effort will be appreciated. Sincerely, Tekpr00

Hello All, I am wondering if anyone has upgraded a 10g database to 11g via a response file before. If so, can you give a sample of such response file, where to store it and which command to use. Thanks in advance and your effort will be appreciated. Sincerely, Tekpr00

Hello I have two files as follow: man_exist_instances.txt 2100_ctxd 2100_sfgd 2200_sfga 2200_ctxa 2150_sfgi 2150_ctxi 2250_sfgm 2500_ctxd AND sys_exist_instances.txt 2650_sfg 2250_sfg sfga_220 2700_etx 2250_ctx 2650_etx 2100_sfg 2200_ctx 2150_sfg The objective is to compare...

Hello All, I am getting the following error when I run the PL/SQL embedded in a shell script. SELECT ts# into v_ts_id FROM v where name = v_rec.tablespace_name; * ERROR at line 30: ORA-06550: line 30, column 30: PL/SQL: ORA-00942: table or view does not exist...

Hello All, My aim is to list the current capacity for all the databases in oratab, future monthly growth rate and send to recipient email. I know this is achievable in OEM, but our version does not have this feature. #!/bin/ksh # # Script Name: future_growth.sh # #...

Hell All, I am flabbergasted by Korn Shell's behavior. I wrote a simple script as follows: chk_sp_cop.sh: csp=`ps -ef | grep -v grep | grep sp_cop | wc -l` if test $csp -ne 4 then mailx -s "SharePlex Configuration Processes(SPCP)" me@aol.com<<EOM One or more SharePlex Configuration Processes...

Hello All, I am trying to report sessions connection to the database withing the last 24 hours to include all of the following columns AND LOG_OFF_TIME: SELECT NVL(s.username, '(oracle)') AS username, s.osuser, s.sid, s.serial#, --p.spid, --s.lockwait...