Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [solaris]

22 questions
3
votes
2 answers

How can I load 'utf8' into plperl by default?

I am attempting to solve a problem explained in another question here. On Debian 7.4 with Postgres 9.1.12, I am able to use the Perl qr operator just fine. On Solaris 5.11 with Postgres 9.2.4, however, I am not able to. As detailed in the question…
Flimzy
  • 609
  • 1
  • 5
  • 18
2
votes
0 answers

what is causing the reads in this configuration?

i have a setup here where we use a Solaris 10 x86, zpool for oracle12c-redo-log using mirrored disks and mirrored ZIL. logbias="latency", recordsize=128: pool: xxxxxx01_redo00 state: ONLINE scan: resilvered 25.1G in 0h1m with 0 errors on Thu Jan…
Bjarne2709
  • 21
  • 1
2
votes
1 answer

ORA-01658 on index tablespace when trying to insert into empty table of new database

We are getting ORA-01658 (Error :ORA-01658: unable to create INITIAL extent for segment in tablespace MYDATA_LDATA_INDEX) in our application logs. This happens when application is trying to insert data for the first time into tables that are empty.…
TiCL
  • 123
  • 1
  • 4
2
votes
1 answer

I am trying to restore an Oracle DB, but I am getting strange controlfile errors. What do I do next?

Oracle version = Oracle 8i (817_312) //Yes I know this is old. Database id = LED OS = Solaris 8 Oracle USERID = oraled Oracle DBA group = dba rman backups to disk. Sorry this is so long. I am not a DBA, I am UNIX/Linux system administrator. We…
Jim T
  • 21
  • 2
2
votes
1 answer

ORA-48108 & ORA-01034

I'm trying to set up a database on a Solaris 10 platform that had its database corrupted before. Due to the lack of backups, I was forced to reinstall Oracle server. Currently I'm facing an issue where answers I have found keep sending me in…
QwertyForever
  • 23
  • 1
  • 5
2
votes
1 answer

Is Oracle 10g smart enough to work on a WHERE clause identically as the equivalent INNER JOIN?

Way back when Michael Jackson was still alive, I made this question: https://stackoverflow.com/questions/1018822/inner-join-on-vs-where-clause And now I'm performance-auditing a system in which the developer used the first form, instead of an INNER…
JCCyC
  • 133
  • 1
  • 7
1
vote
0 answers

DB Link from Oracle 12c running on Solaris to MariaDb with dialog authentication method

I have Oracle 12c running on Solaris which is my main database for multiple systems and data processing. There is planned upgrade and migration from Solaris but this wont happen soon, my team is not responsible for this. I need to create Database…
cargt4
  • 13
  • 1
  • 4
1
vote
0 answers

How to change permissions of Oracle generated logs?

The oracle generated logs (ie. alert and listener logs) are being created with 600 permissions. These files are of course created automatically by the oracle user. How would I change the permissions to automatically be 640, for instance, in a…
Jeff Bauersfeld
  • 335
  • 5
  • 16
1
vote
1 answer

Logging procedure, package errors to OS's Syslog

Good day, Setup: Oracle 11G on Solaris 10 x86 We'd like to capture the errors/failures of our nightly scheduled procedures/ packages in the OS's syslog. That log will then be sent to a remote NMS managed by the NOC who'll alert the on-call…
jasmaar
  • 125
  • 4
1
vote
1 answer

What is the path of oratab on solaris?

What is the path of oratab on solaris? This is actually a question I google a lot and switching from environment to another, I tend to mix them up and forget. Today I googled it again and I wanted it in a place where I usually have all the answers.
Nicolas de Fontenay
  • 1,875
  • 2
  • 18
  • 37
1
vote
0 answers

SQLPlus TNS:protocol adapter error

i have two Oracle 12c instances. currently both are shutdown. when I try to connect with sqlplus / as sysdba it says tns protocol adapter error contents of tnsnames.ora are DB12102 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT…
Amit Jaiswal
  • 11
  • 2
1
vote
1 answer

Why does MySQLTuner only see 4Gb of RAM?

I ran MySQLTuner to verify the configuration of a MySQL database, and it reported this problem: [!!] Maximum possible memory usage: 40.9G (1022% of installed RAM) These figures come from computing max_connections multiplied by read_buffer_size +…
dr_
  • 1,334
  • 4
  • 19
  • 40
0
votes
2 answers

sql script hangs in SQLplus on Solaris

Running an sql script in SQLplus on Solaris Any idea why script hangs in line 9 '/' and not executed? declare dummy number; begin select 1 into dummy from dual ; end; /
lagios
  • 1
  • 1
0
votes
1 answer

How to know which process is causing high memory usage on DB?

I've got one Onesight alert mail stating below: Short Description: Onesight Alert: ZEUS DB Monitor (zeus04) Description: Solaris 5.8: vmstat memory(free) - Free Memory for zeus04 2065112 8:06:02 AM IST 2 min Free Memory below 4GB: Value was…
sweetritz
  • 371
  • 1
  • 5
  • 11
0
votes
2 answers

How to put Oracle Redo Log file at the outer edge of disk for performance?

I always read that the outer edge of disk is the fastest place. Somebody said "You better put your Oracle Redo Log file at the outer edge of disk". My question is: How to put Redo Log file at specific location in disk? How much performance will it…
Hajime
  • 1
  • 1
1
2