Oracle - Revision history

PhilippeTeuwen: Reverted edits by Etegohy (Talk) to last revision by 85.234.199.24

2010-11-24T20:34:50Z

Reverted edits by Etegohy (Talk) to last revision by 85.234.199.24

Can't load revision 6839

at 00:29, 24 November 2010

2010-11-24T00:29:41Z

Can't load revision 6681

85.234.199.24: /* Start Oracle Enterprise Manager Console */

2007-02-10T15:46:08Z

Start Oracle Enterprise Manager Console

← Older revision		Revision as of 15:46, 10 February 2007
Line 100:		Line 100:
	Launch Standalone		Launch Standalone
	Connect manually to DB at 127.0.0.1:1521 SID:test		Connect manually to DB at 127.0.0.1:1521 SID:test
	user SYS pwd sys as SYSDBA		user SYS pwd sys service TEST_127.0.0.1 as SYSDBA

85.234.199.24 at 15:44, 10 February 2007

2007-02-10T15:44:07Z

← Older revision		Revision as of 15:44, 10 February 2007
Line 1:		Line 1:
	==Oracle9i on Debian Etch==		==Oracle9i on Debian Etch==
			===Prepare installation===

	Get files from		Get files from
	http://www.oracle.com/technology/software/products/oracle9i/htdocs/linuxsoft.html		http://www.oracle.com/technology/software/products/oracle9i/htdocs/linuxsoft.html
Line 36:		Line 36:
	export ORACLE_SID=dbname		export ORACLE_SID=dbname
	sysctl kernel.sem		sysctl kernel.sem
	sysctl -w kernel.sem="250 ~~32000 100 128~~"		sysctl -w kernel.sem="250"
	sysctl kernel.shmall		sysctl kernel.shmall
	sysctl kernel.shmmax		sysctl kernel.shmmax
Line 49:		Line 49:
	But I didn't export this one so Oracle installed its own (very old) JRE		But I didn't export this one so Oracle installed its own (very old) JRE
	#export JAVA_HOME=/usr/lib/jvm/java-1.5.0-sun		#export JAVA_HOME=/usr/lib/jvm/java-1.5.0-sun
			===Installation===

	When trying to launch the installer I got the error		When trying to launch the installer I got the error
	Unable to load native library: /tmp/OraInstall2003-10-25_03-14-57PM/jre/lib/i386/libjava.so:		Unable to load native library: /tmp/OraInstall2003-10-25_03-14-57PM/jre/lib/i386/libjava.so:
Line 80:		Line 80:
	# Set shell search paths		# Set shell search paths
	export PATH=$PATH:$ORACLE_HOME/bin		export PATH=$PATH:$ORACLE_HOME/bin
			===DB Creation Assistant===

	When trying dbca, the tool died with sth like		When trying dbca, the tool died with sth like
	dbca: line 124: 26649 Segmentation fault (or Killed)		dbca: line 124: 26649 Segmentation fault (or Killed)
	I solved it by doing what they proposed [http://www.puschitz.com/InstallingOracle9i.shtml here]:		I solved it by doing what they proposed [http://www.puschitz.com/InstallingOracle9i.shtml here]:
	touch /etc/rac_on		touch /etc/rac_on
			===Start DB===
	To start the DB I edited /etc/oratab:		To start the DB I edited /etc/oratab:
	test:/opt/oracle/OraHome:Y		test:/opt/oracle/OraHome:Y
	And I had to copy the init file of my database "test":		And I had to copy the init file of my database "test":
	cp /opt/oracle/admin/test/pfile/init.ora.192007235112 /opt/oracle/OraHome/dbs/inittest.ora		cp /opt/oracle/admin/test/pfile/init.ora.192007235112 /opt/oracle/OraHome/dbs/inittest.ora
			Now we can start it with
			dbstart
			===Start listener===
			lsnrctl start
			You can control the service is running and listening on port 1521:
			netstat -ln \|grep 1521
			===Start Oracle Enterprise Manager Console===
			oemapp console
			Launch Standalone
			Connect manually to DB at 127.0.0.1:1521 SID:test
			user SYS pwd sys as SYSDBA

PhilippeTeuwen at 22:58, 9 February 2007

2007-02-09T22:58:05Z

← Older revision		Revision as of 22:58, 9 February 2007
Line 85:		Line 85:
	I solved it by doing what they proposed [http://www.puschitz.com/InstallingOracle9i.shtml here]:		I solved it by doing what they proposed [http://www.puschitz.com/InstallingOracle9i.shtml here]:
	touch /etc/rac_on		touch /etc/rac_on
			To start the DB I edited /etc/oratab:
			test:/opt/oracle/OraHome:Y
			And I had to copy the init file of my database "test":
			cp /opt/oracle/admin/test/pfile/init.ora.192007235112 /opt/oracle/OraHome/dbs/inittest.ora

PhilippeTeuwen at 22:41, 9 February 2007

2007-02-09T22:41:40Z

← Older revision		Revision as of 22:41, 9 February 2007
Line 64:		Line 64:
	<br> Exporting this variable solved the problem:		<br> Exporting this variable solved the problem:
	export LD_ASSUME_KERNEL=2.4.19		export LD_ASSUME_KERNEL=2.4.19
	This can be added to the .bash_profile as well as ~~DISPLAY=:0.0~~		This can be added to the .bash_profile as well as
			export DISPLAY=:0.0

	Added some more variables:		Added some more variables:
			export ORACLE_HOME=/opt/oracle/OraHome
			export ORACLE_BASE=/opt/oracle
			export ORACLE_SID=test
			export ORACLE_TERM=xterm
			export NLS_LANG=AMERICAN;
			export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
			LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
			LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib
			export LD_LIBRARY_PATH

			# Set shell search paths
			export PATH=$PATH:$ORACLE_HOME/bin

	When trying dbca, the tool died with sth like		When trying dbca, the tool died with sth like

PhilippeTeuwen at 22:32, 9 February 2007

2007-02-09T22:32:01Z

← Older revision		Revision as of 22:32, 9 February 2007
Line 63:		Line 63:
	/opt/oracle/jre/1.1.8/bin/../lib/i686/green_threads/libzip.so: symbol errno, version GLIBC_2.0 not defined in file libc.so.6 with link time reference		/opt/oracle/jre/1.1.8/bin/../lib/i686/green_threads/libzip.so: symbol errno, version GLIBC_2.0 not defined in file libc.so.6 with link time reference
	<br> Exporting this variable solved the problem:		<br> Exporting this variable solved the problem:
	export LD_ASSUME_KERNEL=2.4.1		export LD_ASSUME_KERNEL=2.4.19
	This can be added to the .bash_profile as well as DISPLAY=:0.0		This can be added to the .bash_profile as well as DISPLAY=:0.0

			Added some more variables:

			When trying dbca, the tool died with sth like
			dbca: line 124: 26649 Segmentation fault (or Killed)
			I solved it by doing what they proposed [http://www.puschitz.com/InstallingOracle9i.shtml here]:
			touch /etc/rac_on

PhilippeTeuwen: /* Oracle9i on Debian Etch */

2007-02-08T22:55:25Z

Oracle9i on Debian Etch

← Older revision		Revision as of 22:55, 8 February 2007
Line 47:		Line 47:
	ulimit -u 16386		ulimit -u 16386
	ulimit -f		ulimit -f
			But I didn't export this one so Oracle installed its own (very old) JRE
	export JAVA_HOME=/usr/lib/jvm/java-1.5.0-sun		#export JAVA_HOME=/usr/lib/jvm/java-1.5.0-sun

	When trying to launch the installer I got the error		When trying to launch the installer I got the error
Line 57:		Line 58:
	export DISPLAY=:0.0		export DISPLAY=:0.0

	* Oracle Database / Enterprise edition / ~~General~~ ~~Purpose~~ / ~~dba? -> root~~		* Oracle Database / Enterprise edition / Only software /

			When I wanted to launch ~/bin/dbca I got the error
			/opt/oracle/jre/1.1.8/bin/../lib/i686/green_threads/libzip.so: symbol errno, version GLIBC_2.0 not defined in file libc.so.6 with link time reference
			<br> Exporting this variable solved the problem:
			export LD_ASSUME_KERNEL=2.4.1
			This can be added to the .bash_profile as well as DISPLAY=:0.0

85.234.199.24 at 00:21, 3 February 2007

2007-02-03T00:21:49Z

← Older revision		Revision as of 00:21, 3 February 2007
Line 12:		Line 12:
	<br>Mount the DVD with exec rights:		<br>Mount the DVD with exec rights:
	mount /cdrom -o exec		mount /cdrom -o exec
	I followed [http://wiki.nanthrax.net/NanthraxWiki/Wiki.jsp?page=DebianOracleInstall this doc (french)]		I followed [http://wiki.nanthrax.net/NanthraxWiki/Wiki.jsp?page=DebianOracleInstall this doc (french)] but there is also [http://www.the-love-shack.net/oracle-on-sid.html this one]

	mkdir /opt/oracle		mkdir /opt/oracle

85.234.199.24 at 00:17, 3 February 2007

2007-02-03T00:17:57Z

← Older revision		Revision as of 00:17, 3 February 2007
Line 56:		Line 56:
	<br>I ran it as the new oracle user, this means the local user had to give access to the X11 (xhost local:) and I had to export in the env of the user oracle the following:		<br>I ran it as the new oracle user, this means the local user had to give access to the X11 (xhost local:) and I had to export in the env of the user oracle the following:
	export DISPLAY=:0.0		export DISPLAY=:0.0

			* Oracle Database / Enterprise edition / General Purpose / dba? -> root