Re: Please help !

Thanks ! ;)

Can you please tell me one more thing...how can i access Oracle Enterprise Manager...? I followed these steps but no luck... :(

Accessing the Database with SQL*Plus

Log into Linux as oracle. Set the environment.

Set the Oracle environment variables:

$ . oraenvORACLE_SID = [oracle] ? demo1Run SQL*Plus:

$ sqlplusSQL*Plus: Release 10.2.0.1.0 - Production on Sun Nov 27 15:40:29 2005Copyright (c) 1982, 2005, Oracle. All rights reserved.Enter user-name: / as sysdbaConnected to:Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, OLAP and Data Mining optionsSQL>Using Oracle Enterprise Manager 10g Database Control

In a Web browser, connect to the URL provided during the installation.

Ex:
http://ds1.orademo.org:1158/em (You may have to use the IP address instead of the host name if your database server isn't in your DNS.)

User Name: SYS
Password: <The password you chose during installation> Connect As: SYSDBA

Click on <Login>

"gazzag" <gareth_at_jamms.org> wrote in message news:1183544802.344190.243990_at_k79g2000hse.googlegroups.com...
> On 4 Jul, 11:51, "Malone" <davor.boko..._at_zg.t-com.hr> wrote:
>> First of all, compliments to the group ! ;)
>>
>> Well, about my problem..I installed Oracle 10g release 2 on centOS and
>> i'm
>> searching one information. How can I check is my instance unicode ?
>>
>> Please explain me like you are explaining 12 year old kid because I'm new
>> to
>> this stuff ! :))
>>
>> Thanks !
>
> Hi Malone,
>
> One idea that springs to mind is to issue the following statements in
> a SQL*Plus session:
>
> SYSTEM_at_db1> alter database backup controlfile to trace;
>
> Database altered.
>
> SYSTEM_at_inetprd1> show parameter user_dump_dest
>
> NAME TYPE VALUE
> ------------------------------------ -----------
> ------------------------------
> user_dump_dest string C:\ORACLE\PRODUCT
> \10.2.0\ADMIN
> \DB1\UDUMP
> SYSTEM_at_db1>
>
> Now, check in the directory that USER_DUMP_DEST points to for the most
> recently produced trace file. In it, you'll find the SQL required to
> create a new control file. It will look something like this:
>
> CREATE CONTROLFILE REUSE DATABASE "DB1" NORESETLOGS ARCHIVELOG
> MAXLOGFILES 16
> MAXLOGMEMBERS 4
> MAXDATAFILES 100
> MAXINSTANCES 8
> MAXLOGHISTORY 292
> LOGFILE
> GROUP 1 'D:\ORADATA\DB1\REDO01.LOG' SIZE 50M,
> GROUP 2 'D:\ORADATA\DB1\REDO02.LOG' SIZE 50M,
> GROUP 3 'D:\ORADATA\DB1\REDO03.LOG' SIZE 50M
> -- STANDBY LOGFILE
> DATAFILE
> 'D:\ORADATA\DB1\SYSTEM01.DBF',
> 'D:\ORADATA\DB1\UNDOTBS01.DBF',
> 'D:\ORADATA\DB1\SYSAUX01.DBF',
> 'D:\ORADATA\DB1\USERS01.DBF'
> CHARACTER SET WE8MSWIN1252
> ;
>
> As you can see, the CHARACTER SET is mentioned on the last line.
>
> HTH
>
> -g
>
Received on Wed Jul 04 2007 - 06:53:43 CDT