Amazon books

Saturday, November 14, 2009

Creating XA Oracle Services

--Create the service with this command
srvctl add service -d -s -r -a

--Start the service
srvctl start service -d -s

--Configure the service to use DTP that will guarantee that all global transaction will stay on the same instance
begin
DBMS_SERVICE.MODIFY_SERVICE(
service_name=>'',
dtp => TRUE
);
end;
/


--Service_name to insert into your tnsnames.ora client file
SERV_XA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = IP_MACHINE_DB_SERVER)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = )
)
)


--If you reach ORA-12520 error and are using RAC Database then execute the following commands on one instance connected as SYSDBA

1-
sqlplus / as sysdba
SQL> alter system set local_listener='LISTENER_MIDDLE_BWMDPR1' scope=both sid='BWMDPR1'; --Use the same value that is already in use

System altered.

SQL> alter system set local_listener='LISTENER_MIDDLE_BWMDPR2' scope=both sid='BWMDPR2'; --Use the same value that is already in use

System altered.

SQL>alter system register;

System altered.

2-Stop and Start listener (reload didn't help for me!)

Wednesday, November 11, 2009

To move datafile from one disk group to another you need to follow these steps

To move datafile from one disk group to another you need to follow these steps:

1-Identify datafiles that will be moved:
SQL>select
file_name
from
dba_data_files;

2-Identify the disk group destination
--Connect to ASM instance
SQL> select
name
from
v$asm_diskgroup;

3-Take the datafile OFFLINE
SQL>alter database datafile 'file_name' offline;

4-Copy the file using either dbms_file_transfer or RMAN:
--DBMS_FILE_TRANSFER
begin
dbms_file_transfer.copy_file(
source_directory_object => 'DIR_ORIG', --This is an object directory created pointing to original datafile location
source_file_name => 'Data_File_Name.dbf',
destination_directory_object => 'DIR_DEST', --This is an object directory pointing to destination of datafile
destination_file_name => 'Data_File_Name_New.dbf');
end;

--RMAN
RMAN>copy datafile '+DG_ORIG/dbname/datafiles/Data_File_Name.dbf' TO '+DB_DEST';

5-Rename the datafile
SQL alter database rename file '+DG_ORIG/dbname/datafiles/Data_File_Name.dbf' to '+DG_DEST/db_name/datafiles/Data_File_Name_New.dbf'

6-Recover the datafile
SQL>recover datafile '+DG_DEST/db_name/datafiles/Data_File_Name_New.dbf';

7-Put the datafile ONLINE
SQL>alter database datafile '+DG_DEST/db_name/datafiles/Data_File_Name_New.dbf' online;

8-Delete the old datafile using ASMCMD
ASMCMD> cd +DG_ORIG/dbname/datafiles/
ASMCMD> rm -rf Data_File_Name.dbf

9-Backup your tablespace or your database


Best Regards,
Paulo Portugal

Using DBMS_FILE_TRANSFER or RMAN to move datafiles from one Disk Group to another

To move datafile from one disk group to another you need to follow these steps:

1-Identify datafiles that will be moved:
SQL>select
file_name
from
dba_data_files;

2-Identify the disk group destination
--Connect to ASM instance
SQL> select
name
from
v$asm_diskgroup;

3-Take the datafile OFFLINE
SQL>alter database datafile 'file_name' offline;

4-Copy the file using either dbms_file_transfer or RMAN:
--DBMS_FILE_TRANSFER

Tuesday, November 10, 2009

Session Marked for Killed Forever

Find the OS process and kill it using kill -9 . Be carefull because some of then are backgorund process or parallel process for example so, use "ps -ef | grep ospid" before killing it. Example:

--Query to find the OSPID of session killed (for RAC run this query on each instance instead of using gv$ tables)

SQL>SELECT spid
FROM v$process
WHERE NOT EXISTS ( SELECT 1
FROM v$session
WHERE paddr = addr);

[hostname-SID1]/home/oracle> ps -ef | grep 2744432
oraebs 2601182 3592334 0 16:43:23 pts/7 0:00 grep 2744432
oraebs 2744432 1 0 16:59:17 - 0:00 oracleSID3 (LOCAL=NO)



This one you can kill but not this one below (This is a parallel process):

[hostname-SID3]/home/oracle> ps -ef | grep 5136530
oraebs 2601176 3592334 0 16:43:23 pts/7 0:00 grep 5136530
oraebs 5136530 1 0 Nov 07 - 7:44 ora_pz99_SID3



Best Regards,
Paulo Portugal

Convert Single Instance to RAC Database 10g

--Create bdumo,cdump and adump directories on both nodes
mkdir 1
mkdir -p /dbdbname/admin/1/bdump
mkdir -p /dbdbname/admin/1/cdump
mkdir -p /dbdbname/admin/1/udump
mkdir -p /dbdbname/admin/1/adump

mkdir 2
mkdir -p /dbdbname/admin/2/bdump
mkdir -p /dbdbname/admin/2/cdump
mkdir -p /dbdbname/admin/2/udump
mkdir -p /dbdbname/admin/2/adump


-On First Node:
--Install Oracle Clusterware (If you don't have it already installed)
--Create the listener on both nodes
--Backup the database and restore it on a shared location like ASM
--Add the following parameters to your pfile
*.cluster_database = TRUE
*.cluster_database_instances = 2
*.undo_management=AUTO
1.undo_tablespace=undotbs (undo tablespace which already exists)
1.instance_name=1
1.instance_number=1
1.thread=1
1.local_listener=LISTENER_DB_hostname01
2.instance_name=2
2.instance_number=2
2.local_listener=LISTENER_DB_hostname02
2.thread=2
2.undo_tablespace=UNDOTBS2
2.cluster_database = TRUE


--Copy the $ORACLE_HOME/dbs/init.ora to $ORACLE_HOME/dbs/init.ora on node1 and on node2 as SID2


--After create the listener on both nodes, add them at tnsnames.ora file
LISTENER_BPLS_hostname01 =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname01-vip.b2winc.com)(PORT = 1539))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.201.31)(PORT = 1539))
)



LISTENER_BPLS_hostname02 =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname01-vip.b2winc.com)(PORT = 1539))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.201.31)(PORT = 1539))
)


--Use an pfile to startup nomount and them create the spfile

SQL>startup nomount pfile='temp_pfile.ora'

SQL>create SPFILE='+DG_dbname_FRA//spfile.ora' from pfile='temp_pfile_1.ora';


SQL>shutdown immediate

SQL>startup mount


--Create UNDO tablespaces for both nodes
SQL>create undo tablespace UNDOTBS1 datafile '+DG_dbname_FRA' size 500M;
SQL>create undo tablespace UNDOTBS2 datafile '+DG_dbname_FRA' size 500M;

--Create redo groups for thread 2
SQL>alter database add logfile thread 2 group 4 size 50M;
SQL>alter database add logfile thread 2 group 5 size 50M;
SQL>alter database add logfile thread 2 group 6 size 50M;

--Open the database and enable thread 2
SQL>alter database open;

SQL>alter database enable public thread 2;

--On second node, copy the init file, change the name to dbnameSID2.ora and start the database
export ORACLE_SID=dbname.ora
sqlplus / as sysdba
SQL>startup


--Finally create services
srvctl add database -d -o /dbdbname/products/rdbms -p /dbdbname/products/rdbms/init.ora

srvctl add instance -d -i 1 -n hostname01

srvctl add instance -d -i 2 -n hostname02


=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname01-vip.b2winc.com)(PORT = 1539))
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname02-vip.b2winc.com)(PORT = 1539))
(LOAD_BALANCE = yes)
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = )
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES = 180)
(DELAY = 5)
)
)
)



Best Regards,
Paulo Portugal

Using OS tools to monitor swap space and check packages, patches and 64 bit Capacle

--AIX
host:root@/> usr/sbin/lsps -a
Page Space Physical Volume Volume Group Size %Used Active Auto Type
paging00 hdisk0 rootvg 6912MB 2 yes yes lv
hd6 hdisk1 rootvg 6912MB 2 yes yes lv
host:root@/>

--Check packages on AIX
lslpp -w | grep -i "Patch_Name" (applies to APARs and PTFs)

--Check patches on AIX
/usr/sbin/instfix -ik patch number

--Check packages on HP-UX
/usr/sbin/swlist -lproduct PH
/usr/contrib/bin/show_patches

--Check patches pn HP-UX
/usr/sbin/swlist -l fileset | grep -i

--Check patches on Solaris
/bin/showrev -p

--Check packages on Solaris
/bin/pkginfo -l | grep -i "Pkg_Name"

--Linux
rpm -qa | grep "package name"
rpm -qa --queryformat "%{NAME}-%{VERSION}.%{RELEASE} (%{ARCH})\n" > /tmp/rpm-queryformat.txt
rpm -qa --qf "%{NAME}-%{VERSION}-%{RELEASE}_%{ARCH}\\n" | grep "PKG_Name"

--Show What package have the library specified on Linux
rpm -q --whatprovides --qf "%{NAME}-%{VERSION}-%{RELEASE}_%{ARCH}\\n" "full path/library name"


--Check if OS is 64 bit or not
--AIX
lslpp -L | grep 64bit
--HP
getconf KERNEL_BITS
--Solaris
/bin/isainfo -kv

--sar example
sar -r 5 5



Best Regards,
Paulo Portugal

Close trace that has been removed to free up space on operational system

--You have killed a session that was generating big trace file and deleted the file but the space wasn't freed

Fisrt, you need to get the spid using the query bellow or use the name of trace file that has this number:

select
p.spid
from
v$process p,
v$session s
where
p.addr=s.paddr
and
s.sid=;


Then, you will use oradebug to close the trace
oradebug setospid
oradebug close_trace

This operation will close the trace file removed and thus freeing up space on your OS.

Best Regards,
Paulo Portugal

TNS-12560 and TNS-00583 when starting Listener

If you are trying to start the listener and are runing into the message below:

###############################################
TNSLSNR for Linux: Version 11.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/11.2.0/db11g/network/admin/list ener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/dbms/listener/alert/log.xml
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dbms.f2c.com.br)(P ORT=1521)))
TNS-12560: TNS:protocol adapter error
TNS-00583: Valid node checking: unable to parse configuration parameters

###############################################

Then , rename your sqlnet.ora, listener.ora and create another listener using netca or netmgr an try again.

This should solve your problem.

Best Regards,
Paulo Portugal

Monday, November 9, 2009

Scripts to Reorg LOB Segments

This to script are used to reorg LOB segments.

The first one will change some parameters of segment and will also shrink it so the move command will run faster.

The seccond script is the MOVE command.

Below the examples:
###############################
#####Script Pre-Reorg##########
###############################

#!/bin/ksh
sqlplus /nolog < ###" connect system/passwd@SID
show user
spool reorg_otm_18102009_30.log
select sysdate from dual;

set time on
set timing on
SET LINESIZE 150
SET PAGESIZE 100
SET HEAD OFF
SET ECHO OFF
SET TIME ON;
SET TIMING ON;


alter table GLOGOWNER.I_TRANSMISSION modify lob (XML_BLOB) (freepools 1);
alter table GLOGOWNER.I_TRANSMISSION modify lob (XML_BLOB) (shrink space cascade);
alter table GLOGOWNER.I_TRANSMISSION modify lob (XML_BLOB) (pctversion 0);
alter table GLOGOWNER.I_TRANSMISSION modify lob (XML_BLOB) (retention);


spool off
exit;
###EOF - Remove '###'

###############################
#####Script Reorg##############
###############################
#!/bin/ksh
sqlplus /nolog <### connect system/passwd@SID
show user
spool reorg_otm_18102009_32.log
select sysdate from dual;

set time on
set timing on
SET LINESIZE 150
SET PAGESIZE 100
SET HEAD OFF
SET ECHO OFF
SET TIME ON;
SET TIMING ON;

ALTER TABLE GLOGOWNER.I_TRANSMISSION move partition INBOUND2 LOB (XML_BLOB) STORE AS (TABLESPACE LOB4) parallel 8 nologging;

spool off
exit;
###EOF - Remove '###'

Backing up OCR , Voting ,Tar CRS_HOME and Inventory Home Before Applying Patch Set

Before applying Oracle Patch Set 10.2.0.x on your $CRS_HOME it's advisable to backup your binaries on $CRS_HOME and also your OCR and Voting devices.

Here is a simple example of how to do that:

--Backup CRS_HOME
tar cvhf crs_bkp_06_nov_2009_node1.tar /opt/oracle/products/crs
tar cvhf crs_bkp_06_nov_2009_node2.tar /opt/oracle/products/crs
tar cvhf crs_bkp_06_nov_2009_node3.tar /opt/oracle/products/crs

----Backup inventory
tar cvhf inventory_bkp_06_nov_2009_node1.tar /opt/oracle/oraInventory
tar cvhf inventory_bkp_06_nov_2009_node2.tar /opt/oracle/oraInventory
tar cvhf inventory_bkp_06_nov_2009_node3.tar /opt/oracle/oraInventory

--Backup OCR (Backups are done automatically by Oracle but it's a good idea to make it again)
ocrconfig -showbackup
ocrconfig -export OCR_export_07_nov_2009_node1 -s online
ocrconfig -export OCR_export_07_nov_2009_node2 -s online
ocrconfig -export OCR_export_07_nov_2009_node3 -s online
ocrcheck --checking where they are
--Using dd command:
dd if=/dev/rlv_OCR1 of=bkp_OCR1_node1
dd if=/dev/rlv_OCR1 of=bkp_OCR1_node2
dd if=/dev/rlv_OCR1 of=bkp_OCR1_node3

--Backup voting disks
crsctl query css votedisk --Checking where they are
dd if=/dev/rlv_VOTE1 of=bkp_VOTE1_node1
dd if=/dev/rlv_VOTE1 of=bkp_VOTE1_node2
dd if=/dev/rlv_VOTE1 of=bkp_VOTE1_node3



Now you can Upgrade your CRS_HOME using Rolling Upgrade Option or NoRolling (all of then at the same time).

It's important to remember that when you are upgrading CRS_HOME, all nodes will be marked by default, you can install binaries with all services online (instances, listeners, services and CRS deamons) and just need to shutdown services at the end of installation before runing the root102.sh script. At that time you can stop one node at a time and this is rolling upgrade.

Make sure that you have read all the Patch Set Note(Installation Note)!!!

Backup OCR and Voting Disks

Befeore applying Oracle Set Patch like 10.2.0.4 on your $CRS_HOME you should

Sunday, November 8, 2009

Oracle OPatch Utility

--opatch prereq commands

--Check if ORACLE_HOME is valid
$ opatch prereq CheckOracleHome

--Check if the oraInst.loc file
$ opatch prereq CheckOraInstLocation

--Check Central Inventory
$ opatch prereq CheckCentralInventoryLocation

--Check if OH is registered in Inventory
$ opatch prereq CheckCentralInventoryForOH

--Check Inventory for Read and Write Permission
$opatch prereq CheckCentralInventoryForRWSession

--Check if OH have JDK in it
$opatch prereq CheckJDK

--Check if oui in OH is compatible with OPatch utility
$opatch prereq CheckOUIVersionCompatible

--Check if libraries required are OK
$opatch prereq CheckRequiredLibs

--Check if another session is already locking OH
$opatch prereq CheckIfOHLockedForPatching

--Check System Space required
$opatch prereq CheckSystemSpace

--Check for conflits among patches already installed
$opatch prereq CheckConflictAmongPatchesWithDetail

--Check RAC nodes
$opatch prereq CheckRACNodeList

--Check if commands can be invoked on remote machines
$opatch prereq CheckRemoteCommandInvocable

--Check permissions for copy and remove files on remote machines
$opatch prereq CheckRemoteCopyAndRemove

--Check if Central Inventory has a CRS Home registered
$opatch prereq CheckForCRSHomeIfRAC

--opatch util commands

--Apply a set of patches
$opatch napply

Thursday, November 5, 2009

ORA-28368: cannot auto-create wallet

If you got this error simple create a directory named "wallet" on your $ORACLE_BASE/admin/$ORACLE_SID.


SQL> alter system set encryption key identified by manager;
alter system set encryption key identified by manager
*
ERROR at line 1:
ORA-28368: cannot auto-create wallet

[ora11g@dbms admin]$ mkdir -p $ORACLE_BASE/admin/$ORALE_SID wallet

[ora11g@dbms dbms]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Thu Nov 5 13:30:43 2009

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options

SQL> alter system set encryption key identified by manager;

System altered.

SQL> exit

Oracle Services - SRVCTL Command

################################################
############SRVCTL Command Examples#############
################################################
--Stopping an instance
srvctl stop instance -d capdb14p -i capdb14p1

--Database status
srvctl status database -d BWEBTST

--Creating Services
srvctl add service -d database_unique_name -s service_name -r preferred_list[-a
available_list] [-P TAF_policy]

--Stopping and Starting databases
srvctl start service -d database_unique_name [-s service_name_list] [-i inst_name]
[-o start_options] [-c connect_str | -q]

srvctl stop service -d database_unique_name -s service_name_list [-i inst_name]
[-o start_options] [-c connect_str | -q]

--Enable/Disable Services
srvctl enable service -d database_unique_name -s service_name_list [-i inst_name]
srvctl disable service -d database_unique_name -s service_name_list [-i inst_name]

--Relocating Services
srvctl relocate service -d apps -s crm -i apps1 -t apps3

--Services Status
srvctl status service -d BWWMSPR -s crm

--Checking Services
srvctl config service -d BWWMSPR -s crm -a

--Check services status deep info
srvctl status service -d BWSLPR -s SERV1,SERV2,SERV3,SERVxxx -v -S 9 -f

Wednesday, November 4, 2009

Connecting to TimesTen Instance

[oratt@dbms bin]$ ./ttisql

Copyright (c) 1996-2009, Oracle. All rights reserved.
Type ? or "help" for help, type "exit" to quit ttIsql.


Command> connect "dsn=TT_1121"; --At this time the database is created and loaded into memory
Connection successful:
Command>

Installing Oracle TimesTen on Linux

--TimesTen information
###############################################
##############Installing#######################
###############################################
--Default instance name is tt1121_32 and tt1121_64 for 32 and 64bit
--On UNIX the default port is 53384 for 32bit 53388 for 64bit
--Create a group named timesten and put the user on this group
--Create the directory and group
mkdir /etc/TimesTen
groupadd ttadmin
useradd -g ttadmin -oinstall oratt
--Give the right privileges on directories
# chgrp -R ttadmin /etc/TimesTen
# chmod 770 /etc/TimesTen/
# chmod 660 /etc/TimesTen/*
--Install TimesTen using record option to use with batch option in future (optional)
./setup.sh -record setup_rec_04112009.rec
--Start TimesTen Instance on rebbot:
# cd install_dir/bin
# setuproot -install
--Execute the following command:
setprivgrp ttadmin MLOCK
--Check the privilege of the group
getprivgrp timesten

--Output
[oratt@dbms linux86]$ ./setup.sh -record setup_rec_04112009.rec

NOTE: Each TimesTen installation is identified by a unique instance name.
The instance name must be a non-null alphanumeric string, not longer
than 255 characters.

Please choose an instance name for this installation? [ tt1121 ] oratt
Instance name will be 'oratt'.
Is this correct? [ yes ]

Of the three components:

[1] Client/Server and Data Manager
[2] Data Manager Only
[3] Client Only

Which would you like to install? [ 1 ]
Where would you like to install the oratt instance of TimesTen? [ /home/oratt ] /u01/app/oracle/product/timesten
Where would you like to create the daemon home directory? [ /u01/app/oracle/product/timesten/TimesTen/oratt/info ]
Installing into /u01/app/oracle/product/timesten/TimesTen/oratt ...
Uncompressing ...

NOTE: If you are configuring TimesTen for use with Oracle Clusterware, the
daemon port number must be the same across all TimesTen installations
managed within the same Oracle Clusterware cluster.

NOTE: All installations that replicate to each other must use the same daemon
port number that is set at installation time. The daemon port number can
be verified by running 'ttVersion'.

The default port number is 53384.

Do you want to use the default port number for the TimesTen daemon? [ yes ]
The daemon will run on the default port number (53384).

NOTE: For security, we recommend that you restrict access to the
TimesTen installation to members of a single OS group. Only members of
that OS group will be allowed to perform direct mode connections to
TimesTen, and only members of that OS group will be allowed to perform
operations that access TimesTen data stores, TimesTen files and shared
memory. The OS group defaults to the primary group of the instance
administrator. You can default to this group, choose another OS group
or you can make this instance world-accessible. If you choose to make
this instance world-accessible, all database files and shared memory
are readable and writable by all users.

Restrict access to the the TimesTen installation to the group 'ttadmin'? [ yes ]

NOTE: Enabling PL/SQL will increase the size of some TimesTen libraries.

Would you like to enable PL/SQL for this instance? [ yes ]

The daemon logs will be located in /u01/app/oracle/product/timesten/TimesTen/oratt/info
Would you like to specify a different location for the daemon logs? [ no ]

In order to use the 'In-Memory Database Cache' feature in any databases
created within this installation, you must set a value for the TNS_ADMIN
environment variable. It can be left blank, and a value can be supplied later
using /bin/ttModInstall.

Please enter a value for TNS_ADMIN (s=skip)? [ ]
Please enter a value for TNS_ADMIN (s=skip)? [ ]
Please enter a value for TNS_ADMIN (s=skip)? [ ] skip
skip is not a readable directory, use it anyways ? [ no ]
Please enter a value for TNS_ADMIN (s=skip)? [ ] /u01/app/oracle/product/timesten/TimesTen/

TNS_ADMIN will be set to /u01/app/oracle/product/timesten/TimesTen
You can change TNS_ADMIN later by running /bin/ttmodinstall.


Installing server components ...
What is the TCP/IP port number that you want the TimesTen Server to listen on? [ 53385 ]
Do you want to install QuickStart and the TimesTen Documentation? [ no ] Yes
Where would you like to install the quickstart and doc directories (s=skip)? [ /u01/app/oracle/product/timesten/TimesTen/oratt ] /u01/app/oracle/product/timesten/TimesTen/oratt/docs
The directory /u01/app/oracle/product/timesten/TimesTen/oratt/docs does not exist.
Do you want to create it? [ yes ]

The TimesTen Quickstart applications can take up to 64 Mbytes of disk space.
Depending on how your system is configured, you may not want to create the
QuickStart DemoDataStore directory in the default location,
/u01/app/oracle/product/timesten/TimesTen/oratt/info/DemoDataStore

Where would you like to create the DemoDataStore directory? [ /u01/app/oracle/product/timesten/TimesTen/oratt/info ] /u01/app/oracle/product/timesten/TimesTen/oratt/info/demo
The directory /u01/app/oracle/product/timesten/TimesTen/oratt/info/demo does not exist.
Do you want to create it? [ yes ]
Creating /u01/app/oracle/product/timesten/TimesTen/oratt/info/demo/DemoDataStore ...

Installing client components ...

Would you like to use TimesTen Replication with Oracle Clusterware? [ no ]

NOTE: The TimesTen daemon startup/shutdown scripts have not been installed.

Run the 'setuproot' script :
cd /u01/app/oracle/product/timesten/TimesTen/oratt/bin
./setuproot -install
This will move the TimesTen startup script into its appropriate location.

The startup script is currently located here :
'/u01/app/oracle/product/timesten/TimesTen/oratt/startup/tt_oratt'.

The Quickstart home page can be accessed here :
'/u01/app/oracle/product/timesten/TimesTen/oratt/quickstart/index.html'

The 11.2.1.3 Release Notes are located here :
'/u01/app/oracle/product/timesten/TimesTen/oratt/README.html'

Starting the daemon ...
TimesTen Daemon startup OK.
End of TimesTen installation.
[oratt@dbms linux86]$ cd /u01/app/oracle/product/timesten/TimesTen/oratt/bin
[oratt@dbms bin]$ ./setuproot -install
Sorry, you must be root to install the TimesTen daemon start script ...

[root@dbms timesten]# cd /u01/app/oracle/product/timesten/TimesTen/oratt/bin
[root@dbms bin]# ./setuproot -install
Would you like to install the TimesTen daemon startup scripts into /etc/init.d? [ yes ]
Copying /u01/app/oracle/product/timesten/TimesTen/oratt/startup/tt_oratt to /etc/init.d

Successfully installed the following scripts :
/etc/init.d/tt_oratt
/etc/rc.d/rc0.d/K45tt_oratt
/etc/rc.d/rc1.d/K45tt_oratt
/etc/rc.d/rc2.d/S90tt_oratt
/etc/rc.d/rc3.d/S90tt_oratt
/etc/rc.d/rc5.d/S90tt_oratt
/etc/rc.d/rc6.d/K45tt_oratt

###############################################
###########Start/Stop##########################
###############################################
[oratt@dbms startup]$ pwd
/u01/app/oracle/product/timesten/TimesTen/oratt/startup
[oratt@dbms startup]$ ls
tt_oratt
[oratt@dbms startup]$ ./tt_oratt stop
Stopping TimesTen Daemon : [ OK ]
[oratt@dbms startup]$ ./tt_oratt start
Starting TimesTen Daemon : [ OK ]
[oratt@dbms startup]$