vi /etc/sysconfig/network
NETWORKING=yes
HOSTNAME=newHostName
vi /etc/hosts
127.0.0.1 newHostName
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
rebooting the system$ cd /usr/lib/cgi-bin $ vi first.cgi
#!/bin/bash echo "Content-type: text/html" echo "" echo "<html><head><title>Bash as CGI" echo "</title></head><body>" echo "<h1>Hello world</h1>" echo "Today is $(date)" echo "</body></html>"
$ chmod +x first.cgi
echo "Today is $(date)"
$(command)
#!/bin/bash echo "Content-type: text/html" echo "" echo "<html><head><title>Bash as CGI" echo "</title></head><body>" echo "<h1>General system information for host $(hostname -s)</h1>" echo "" echo "<h1>Memory Info</h1>" echo "<pre> $(free -m) </pre>" echo "<h1>Disk Info:</h1>" echo "<pre> $(df -h) </pre>" echo "<h1>Logged in user</h1>" echo "<pre> $(w) </pre>" echo "<center>Information generated on $(date)</center>" echo "</body></html>"
$ chmod +x script.cgi
MACRO #dbconnect
BEGIN
userid gguser, password AACAAAAAAAAAAAHAAIFBOIYAMCGIMARE, encryptkey default
END;
MACRO #bpsettings
BEGIN
-- The following are "best practice" runtime options which may be
-- used for workload accounting and load balancing purposes.
-- STATOPTIONS RESETREPORTSTATS ensures that process
-- statistics counters will be reset whenever a new report file is
-- created.
STATOPTIONS RESETREPORTSTATS
-- Generate a report every day at 1 minute after midnight.
-- This report will contain the number of operations, by operation
-- type, performed on each table.
REPORT AT 00:01
-- Close the current report file and create a new one daily at 1
-- minute after midnight. Eleven report files are maintained on disk
-- in the dirrpt directory/folder for each GoldenGate group. The
-- current report file names are <group name>.rpt. The older reports
-- are <group name>0.rpt through <group name>9.rpt, with the
-- older report files having larger numbers.
REPORTROLLOVER AT 00:01
-- REPORTCOUNT denotes that every 60 seconds the Replicat report file
-- in the dirrpt directory/folder will have a line added to it that reports the
-- total number of records processed since startup, along with the rated
-- number of records processed per second since startup, and the change
-- in rate, or "delta" since the last report.
-- In a production environment, this setting would typically be 1 hour.
REPORTCOUNT EVERY 60 SECONDS, RATE
-- End of "best practices" section
END;
MACRO #funcsmap
PARAMS (#src_table, #target_table)
BEGIN
-- Map the source table provided in the variable #src_table to the target
-- table listed in the variable #target_table. There are extra columns in the
-- target we need to populate, so get the data from either the environment
-- variable, or the user token data sent over from Extract
MAP #src_table, TARGET #target_table,
colmap (usedefaults,
orders_trans_ts = @GETENV ("GGHEADER", "COMMITTIMESTAMP"),
trans_rec_loc8tr = @STRCAT (@GETENV ("RECORD", "FILESEQNO"),
@GETENV ("RECORD", "FILERBA")),
extract_lag_ms = @TOKEN ("TKN-EXTLAG-MSEC"),
replicat_lag_ms = @GETENV ("LAG", "MSEC"),
src_db_name = @TOKEN ("TKN-SRC-DBNAME"),
src_db_version = @TOKEN ("TKN-SRC-DBVERSION"),
src_txn_csn = @TOKEN ("TKN-TXN-CSN")
);
END;
nolist include ./dirmac/macrolib.mac list replicat rfuncb #dbconnect () #bpsettings () sourcedefs ./dirdef/mydefs.defs discardfile ./dirrpt/rfuncb.dsc, purge #funcsmap (amer.orders, euro.funcs_test)
How to drop all indexes in a SCHEMA–Login as the schema user whose indexes you want to dropSQL>set pages 10000
SQL>set wrap off
SQL>set heading off
SQL>spool /u2/scripts/idxswx.txtSQL> select ‘ drop index ‘ || index_name ||’;’ from user_indexes;
drop index IND1;
drop index IND2;
drop index IND3;SQL> spool off;— This will spool the file to the set location and now run the Script as the schema user
SQL> conn scott/tigerSQL>@indx.sql–in the particular schema in which you want to drop indexes.A similar script can be used for synonyms especially when you import a schema into a different name than when it was exported.
AuditPos
|
user_projects\domains\MedRecDomain\bin\setDomainEnv.cmd
1
2
3
4
5
6
| [root@ovm /]# service nfs startStarting NFS services: [ OK ]Starting NFS quotas: Cannot register service: RPC: Unable to receive; errno = Connection refusedrpc.rquotad: unable to register (RQUOTAPROG, RQUOTAVERS, udp).[FAILED]Starting NFS daemon: [FAILED] |
1
2
| [root@ovm /]# rpcinfo -prpcinfo: can't contact portmapper: RPC: Remote system error - Connection refused |
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
| [root@ovm /]# yum install nfs-utilsLoaded plugins: rhnplugin, securityThis system is not registered with ULN.You can use up2date --register to register.ULN support will be disabled.Setting up Install ProcessResolving Dependencies--> Running transaction check---> Package nfs-utils.x86_64 1:1.0.9-70.el5 set to be updated--> Processing Dependency: initscripts >= 8.45.43 for package: nfs-utils--> Running transaction check---> Package initscripts.x86_64 0:8.45.44-3.0.1.el5 set to be updated--> Finished Dependency ResolutionDependencies Resolved=============================================================================================================================================================Package Arch Version Repository Size=============================================================================================================================================================Updating:nfs-utils x86_64 1:1.0.9-70.el5 el5_latest 409 kUpdating for dependencies:initscripts x86_64 8.45.44-3.0.1.el5 el5_latest 1.6 MTransaction Summary=============================================================================================================================================================Install 0 Package(s)Upgrade 2 Package(s)Total download size: 2.0 MIs this ok [y/N]: yDownloading Packages:(1/2): nfs-utils-1.0.9-70.el5.x86_64.rpm | 409 kB 00:00 (2/2): initscripts-8.45.44-3.0.1.el5.x86_64.rpm | 1.6 MB 00:01 -------------------------------------------------------------------------------------------------------------------------------------------------------------Total 598 kB/s | 2.0 MB 00:03 Running rpm_check_debugRunning Transaction TestFinished Transaction TestTransaction Test SucceededRunning TransactionUpdating : initscripts 1/4warning: /etc/sysctl.conf created as /etc/sysctl.conf.rpmnewUpdating : nfs-utils 2/4Cleanup : nfs-utils 3/4Cleanup : initscripts 4/4Updated:nfs-utils.x86_64 1:1.0.9-70.el5Dependency Updated:initscripts.x86_64 0:8.45.44-3.0.1.el5Complete! |
1
2
| [root@ovm /]# rpcinfo -prpcinfo: can't contact portmapper: RPC: Remote system error - Connection refused |
1
2
| [root@ovm /]# chkconfig portmap on[root@ovm yum.repos.d]# service portmap start |
1
2
3
4
| [root@ovm yum.repos.d]# rpcinfo -pprogram vers proto port100000 2 tcp 111 portmapper100000 2 udp 111 portmapper |
1
2
3
4
5
6
| [root@ovm /]# service nfs startStarting NFS services: [ OK ]Starting NFS quotas: [ OK ]Starting NFS daemon: [ OK ]Starting NFS mountd: [ OK ][root@ovm /]# chkconfig nfs on |