create two database
in [Oracle]
|
From: Mass on 6 Jul 2008 01:17 Hi guys, I created two database but I have some problem : 1.How I can startup two data base or one of them ? 2.After create second database the listener is point on first data base ,How I can start listener for second database ? 3.Can not login to second database? Thanks
From: Arch on 6 Jul 2008 02:55 On Sat, 5 Jul 2008 22:17:34 -0700 (PDT), Mass <mass123(a)gmail.com> wrote: >Hi guys, > >I created two database but I have some problem : >1.How I can startup two data base or one of them ? >2.After create second database the listener is point on first data >base ,How I can start listener for second database ? >3.Can not login to second database? > >Thanks What operating system platform? What version of Oracle?
From: Mladen Gogala on 6 Jul 2008 06:58 On Sat, 05 Jul 2008 22:17:34 -0700, Mass wrote: > Hi guys, > > I created two database but I have some problem : 1.How I can startup two > data base or one of them ? 2.After create second database the listener > is point on first data base ,How I can start listener for second > database ? 3.Can not login to second database? > > Thanks You should do the following: First, start the listener for the instance on the port 1521 using the following command: "orasrv tcp SID1 1521" After that, type "sqldba". When you get the prompt, execute "connect internal" and then "startup open". Then repeat for the remaining instance, on the remaining port. Your Oracle 6 database will then be started. -- http://mgogala.freehostia.com
From: Mass on 7 Jul 2008 00:37 On Jul 6, 9:55 am, Arch <send...(a)spam.net> wrote: > On Sat, 5 Jul 2008 22:17:34 -0700 (PDT), Mass <mass...(a)gmail.com> > wrote: > > >Hi guys, > > >I created two database but I have some problem : > >1.How I can startup two data base or one of them ? > >2.After create second database the listener is point on first data > >base ,How I can start listener for second database ? > >3.Can not login to second database? > > >Thanks > > What operating system platform? What version of Oracle? i was have this problem in both Solaris 10 and windows 2003 server with oracle 10g thanks
From: isma.sanchez on 8 Jul 2008 04:17
On Jul 7, 6:37 am, Mass <mass...(a)gmail.com> wrote: > On Jul 6, 9:55 am, Arch <send...(a)spam.net> wrote: > > > On Sat, 5 Jul 2008 22:17:34 -0700 (PDT), Mass <mass...(a)gmail.com> > > wrote: > > > >Hi guys, > > > >I created two database but I have some problem : > > >1.How I can startup two data base or one of them ? > > >2.After create second database the listener is point on first data > > >base ,How I can start listener for second database ? > > >3.Can not login to second database? > > > >Thanks > > > What operating system platform? What version of Oracle? > > i was have this problem in both Solaris 10 and windows 2003 server > with oracle 10g > > thanks Windows 2003 Server: If you want to use the same port (1521) on both databases : - Modify listener.ora (make a copy before ;-) ) to include the new database and re-start the listener service. In other case: - Use Network Configuration Assistance |